Hi,
Im getting error in check report in total colomn. Please see the below report.
I written the the below logic in Check Rule Group.
For Source:
| ~Actual,Mar-18,,,400,330301,,000,,,,140,,,,,,,,,,,,,,,,~;
|
For Target:
| |Actual,Mar,,,,400,330301,FCCS_Entity Input,FCCS_No Intercompany,,FCCS_Mvmts_OtherCurrentLiabilities,No Dimension 2,140,No Dimension 1,FCCS_Local GAAP,FCCS_Managed Data,,,,,,,,,,,,,|;
|
Last Field Check Rule:
def runVal():
msg="
dbVal=abs(~Actual,Mar-18,,,400,330301,,000,,,,140,,,,,,,,,,,,,,,,~)-(|Actual,Mar,,,,400,330301,FCCS\_Entity Input,FCCS\_No Intercompany,,FCCS\_Mvmts\_OtherCurrentLiabilities,No Dimension 2,140,No Dimension 1,FCCS\_Local GAAP,FCCS\_Managed Data,,,,,,,,,,,,,|;)
if(dbVal==0):
RESULT='True'
msg='Balanced'
else:
RESULT=False
msg='Not Balanced'
return [RESULT,msg]
log:
2019-02-10 04:55:07,511 INFO [AIF]: FDMEE Process: 625, Log Level: 5
2019-02-10 04:55:07,511 INFO [AIF]: Location : xxxx (Partitionkey:25)
2019-02-10 04:55:07,512 INFO [AIF]: Period Name : Mar-18 (Period Key:3/31/18 12:00 AM)
2019-02-10 04:55:07,512 INFO [AIF]: Category Name: Actual (Category key:1)
2019-02-10 04:55:07,512 INFO [AIF]: Rule Name : xxxx (Rule ID:24)
2019-02-10 04:55:09,450 INFO [AIF]: FDM Version: 11.1.2.4.230
2019-02-10 04:55:09,451 INFO [AIF]: Log File Encoding: UTF-8
2019-02-10 04:55:10,486 INFO [AIF]: -------START IMPORT STEP-------
2019-02-10 04:55:10,660 DEBUG [AIF]: CommData.preImportData - START
2019-02-10 04:55:10,660 DEBUG [AIF]: CommData.getRuleInfo - START
2019-02-10 04:55:10,663 DEBUG [AIF]:
SELECT adim.BALANCE\_COLUMN\_NAME DIMNAME, adim.DIMENSION\_ID, adim.TARGET\_DIMENSION\_CLASS\_NAME, tiie.IMPCONCATCHAR
,(SELECT COA\_SEGMENT\_NAME FROM AIF\_COA\_SEGMENTS cs WHERE cs.COA\_LINE\_ID = tiie.IMPSOURCECOALINEID1) COA\_SEGMENT\_NAME1
FROM TPOVPARTITION tpp
INNER JOIN AIF\_TARGET\_APPL\_DIMENSIONS adim
ON adim.APPLICATION\_ID = 14
LEFT OUTER JOIN TBHVIMPITEMERPI tiie
ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE\_COLUMN\_NAME AND tiie.IMPMAPTYPE = 'ERP'
WHERE tpp.PARTITIONKEY = 25
AND adim.BALANCE\_COLUMN\_NAME IS NOT NULL
AND adim.TARGET\_DIMENSION\_CLASS\_NAME \<> 'ICPTRANS'
AND (adim.VALID\_FOR\_PLAN1 = 1 OR adim.TARGET\_DIMENSION\_CLASS\_NAME = 'LOOKUP')
ORDER BY adim.BALANCE\_COLUMN\_NAME
2019-02-10 04:55:10,665 DEBUG [AIF]: {'PLAN_NUMBER': 1L, 'EXPORT_TO_TARGET_FLAG': u'Y', 'SRC_TARGET_APP_NAME': u'xxxxAccountingFlexfield_2', 'JOURNAL_FLAG': None, 'DIMNAME_MAP': {u'UD2': {'DIMNAME': u'UD2', 'TARGET_DIMENSION_CLASS_NAME': u'Movement'}, u'UD4': {'DIMNAME': u'UD4', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD3': {'DIMNAME': u'UD3', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD6': {'DIMNAME': u'UD6', 'TARGET_DIMENSION_CLASS_NAME': u'Multi-GAAP'}, u'UD5': {'DIMNAME': u'UD5', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD7': {'DIMNAME': u'UD7', 'TARGET_DIMENSION_CLASS_NAME': u'Data Source'}, u'ACCOUNT': {'DIMNAME': u'ACCOUNT', 'TARGET_DIMENSION_CLASS_NAME': u'Account'}, u'ENTITY': {'DIMNAME': u'ENTITY', 'TARGET_DIMENSION_CLASS_NAME': u'Entity'}, u'ICP': {'DIMNAME': u'ICP', 'TARGET_DIMENSION_CLASS_NAME': u'ICP'}}, 'CATKEY': 1L, 'TGT_APP_SUB_TYPE': u'FCCS', 'TGT_APP_ID': 14L, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD2', u'UD3', u'UD4', u'UD5', u'UD6', u'UD7'], 'SRC_SOURCE_SYSTEM_ID': 15L, 'TGT_SOURCE_SYSTEM_TYPE': None, 'TGT_APP_TYPE': u'HPL', 'CALENDAR_ID': None, 'TGT_TARGET_APP_NAME': u'xxxx', 'PARTITIONKEY': 25L, 'EXECUTION_MODE': u'REPLACE', 'LEDGER_GROUP_CODE': u'NONE', 'PS_LEDGER': None, 'SRC_DATA_LOAD_METHOD': u'FUSION_GL_CLOUD', 'PARTVALGROUP': u'xxxx_Check', 'WEB_SERVICE_URL': u'http://em2pbcsr911301.nldc1.oraclecloud.com:9000/aif', 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'IS_INCREMENTAL_LOAD': False, 'INCLUDE_ADJ_PERIODS_FLAG': u'B', 'SRC_APP_NAME': u'xxxxAccountingFlexfield_2', 'FCI_FLAG': 'N', 'KK_FLAG': u'N', 'LAST_UPDATED_BY': u'xxxx@xxxx.com', 'CHECK_FLAG': u'Y', 'RULE_ID': 24L, 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SRC_APP_ID': u'17', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'IMPGROUPKEY': u'xxxx', 'TGT_SOURCE_SYSTEM_ID': 0L, 'SRC_APP_TYPE': u'ESSBASE', 'TGT_APP_NAME': u'xxxx', 'IMPGROUPFILETYPE': u'EPM_EPM', 'LEDGER_GROUP': None, 'TGT_COA_ID': 0L, 'SOURCE_ADAPTER_FLAG': u'N', 'RECALCULATE_FLAG': u'Y', 'TGT_DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'SRC_SOURCE_SYSTEM_TYPE': u'FUSION_GL_CLOUD', 'PLAN_TYPE': u'PLAN1', 'TGT_METADATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI'}
2019-02-10 04:55:10,668 DEBUG [AIF]: {u'Intercompany': {'BCN': u'ICP', 'DCN': u'ICP'}, u'Account': {'BCN': u'ACCOUNT', 'DCN': u'Account'}, u'Entity': {'BCN': u'ENTITY', 'DCN': u'Entity'}, u'Movement': {'BCN': u'UD2', 'DCN': u'Movement'}, u'Years': {'BCN': None, 'DCN': u'Year'}, u'Dimension 2': {'BCN': u'UD3', 'DCN': u'Generic'}, u'Service Line': {'BCN': u'UD4', 'DCN': u'Generic'}, u'Dimension 1': {'BCN': u'UD5', 'DCN': u'Generic'}, u'Period': {'BCN': None, 'DCN': u'Period'}, u'Multi-GAAP': {'BCN': u'UD6', 'DCN': u'Multi-GAAP'}, u'View': {'BCN': None, 'DCN': u'View'}, u'Scenario': {'BCN': None, 'DCN': u'Scenario'}, u'Consolidation': {'BCN': None, 'DCN': u'Consolidation'}, u'Data Source': {'BCN': u'UD7', 'DCN': u'Data Source'}, u'Currency': {'BCN': None, 'DCN': u'Currency'}}
2019-02-10 04:55:10,669 DEBUG [AIF]: {u'UD4': {'IMPFLDSOURCECOLNAME': u'xxxx Service line'}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': u'xxxx Account'}, u'ENTITY': {'IMPFLDSOURCECOLNAME': u'xxxx Legal Entity'}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': u'Amount'}, u'ICP': {'IMPFLDSOURCECOLNAME': u'xxxx Interco'}}
2019-02-10 04:55:10,669 DEBUG [AIF]: CommData.getRuleInfo - END
2019-02-10 04:55:10,669 DEBUG [AIF]: CommData.insertEpmPeriods - START
2019-02-10 04:55:10,671 DEBUG [AIF]: doAppPeriodMappingsExist - xxxx: Y
2019-02-10 04:55:10,672 DEBUG [AIF]: doAppPeriodMappingsExist - xxxxAccountingFlexfield_2: Y
2019-02-10 04:55:10,672 DEBUG [AIF]: Period mapping section: ADJUSTMENT
2019-02-10 04:55:10,672 DEBUG [AIF]: Period mapping section: DEFAULT
2019-02-10 04:55:10,672 DEBUG [AIF]:
INSERT INTO AIF\_PROCESS\_PERIODS (
PROCESS\_ID, PERIODKEY, ADJUSTMENT\_PERIOD\_FLAG, GL\_PERIOD\_YEAR, GL\_PERIOD\_YEAR\_CHAR, GL\_PERIOD\_NUM, GL\_PERIOD\_NAME, GL\_PERIOD\_CODE
,GL\_EFFECTIVE\_PERIOD\_NUM, YEARTARGET, PERIODTARGET, IMP\_ENTITY\_TYPE, IMP\_ENTITY\_NAME, TRANS\_ENTITY\_TYPE, TRANS\_ENTITY\_NAME, PRIOR\_PERIOD\_FLAG
)
SELECT DISTINCT brl.LOADID PROCESS\_ID
,tpp.PERIODKEY PERIODKEY
,'Y' ADJUSTMENT\_PERIOD\_FLAG
,0 GL\_PERIOD\_YEAR
,ppsrc.GL\_PERIOD\_YEAR GL\_PERIOD\_YEAR\_CHAR
,0 GL\_PERIOD\_NUM
,ppsrc.GL\_PERIOD\_NAME GL\_PERIOD\_NAME
,ppsrc.GL\_PERIOD\_NAME GL\_PERIOD\_CODE
,0 GL\_EFFECTIVE\_PERIOD\_NUM
,tpp.YEARTARGET YEARTARGET
,tpp.PERIODTARGET PERIODTARGET
,'PROCESS\_BAL\_IMP\_FILE' IMP\_ENTITY\_TYPE
,'xxxxAccountingFlexfield\_2\_625.dat' IMP\_ENTITY\_NAME
,'PROCESS\_BAL\_TRANS' TRANS\_ENTITY\_TYPE
,tpp.PERIODDESC TRANS\_ENTITY\_NAME
,'N' PRIOR\_PERIOD\_FLAG
FROM (
AIF\_BAL\_RULE\_LOADS brl
INNER JOIN TPOVCATEGORY pc
ON pc.CATKEY = brl.CATKEY
INNER JOIN TPOVPERIODADAPTOR\_FLAT\_V tpp
ON tpp.PERIODFREQ = pc.CATFREQ
AND tpp.PERIODKEY >= brl.START\_PERIODKEY
AND tpp.PERIODKEY \<= brl.END\_PERIODKEY
AND tpp.INTSYSTEMKEY = 'xxxx'
)
INNER JOIN TPOVPERIODSOURCE ppsrc
ON ppsrc.TARGET\_PERIODKEY = tpp.PERIODKEY
AND ppsrc.SOURCE\_SYSTEM\_ID = 15
AND SOURCE\_APPLICATION\_NAME = 'xxxxAccountingFlexfield\_2'
AND ppsrc.MAPPING\_TYPE = 'ADJUSTMENT'
WHERE brl.LOADID = 625
ORDER BY tpp.PERIODKEY, ppsrc.GL\_PERIOD\_NAME
2019-02-10 04:55:10,673 DEBUG [AIF]: periodSQL - periodParams: [u'xxxxAccountingFlexfield_2_625.dat', u'xxxx', 15L, u'xxxxAccountingFlexfield_2', 625]
2019-02-10 04:55:10,674 DEBUG [AIF]: insertRowCount: 0
2019-02-10 04:55:10,674 DEBUG [AIF]:
INSERT INTO AIF\_PROCESS\_PERIODS (
PROCESS\_ID, PERIODKEY, ADJUSTMENT\_PERIOD\_FLAG, GL\_PERIOD\_YEAR, GL\_PERIOD\_YEAR\_CHAR, GL\_PERIOD\_NUM, GL\_PERIOD\_NAME, GL\_PERIOD\_CODE
,GL\_EFFECTIVE\_PERIOD\_NUM, YEARTARGET, PERIODTARGET, IMP\_ENTITY\_TYPE, IMP\_ENTITY\_NAME, TRANS\_ENTITY\_TYPE, TRANS\_ENTITY\_NAME, PRIOR\_PERIOD\_FLAG
)
SELECT DISTINCT brl.LOADID PROCESS\_ID
,tpp.PERIODKEY PERIODKEY
,'N' ADJUSTMENT\_PERIOD\_FLAG
,0 GL\_PERIOD\_YEAR
,spp.YEARTARGET GL\_PERIOD\_YEAR\_CHAR
,0 GL\_PERIOD\_NUM
,spp.PERIODTARGET GL\_PERIOD\_NAME
,spp.PERIODKEY GL\_PERIOD\_CODE
,0 GL\_EFFECTIVE\_PERIOD\_NUM
,tpp.YEARTARGET YEARTARGET
,tpp.PERIODTARGET PERIODTARGET
,'PROCESS\_BAL\_IMP\_FILE' IMP\_ENTITY\_TYPE
,'xxxxAccountingFlexfield\_2\_625.dat'
,'PROCESS\_BAL\_TRANS' TRANS\_ENTITY\_TYPE
,tpp.PERIODDESC TRANS\_ENTITY\_NAME
,'N' PRIOR\_PERIOD\_FLAG
FROM (
AIF\_BAL\_RULE\_LOADS brl
INNER JOIN TPOVCATEGORY pc
ON pc.CATKEY = brl.CATKEY
INNER JOIN TPOVPERIODADAPTOR\_FLAT\_V tpp
ON tpp.PERIODFREQ = pc.CATFREQ
AND tpp.PERIODKEY >= brl.START\_PERIODKEY
AND tpp.PERIODKEY \<= brl.END\_PERIODKEY
AND tpp.INTSYSTEMKEY = 'xxxx'
)
INNER JOIN TPOVPERIODADAPTOR\_FLAT\_V spp
ON spp.PERIODFREQ = pc.CATFREQ
AND spp.PERIODKEY > tpp.PRIORPERIODKEY
AND spp.PERIODKEY \<= tpp.PERIODKEY
AND spp.INTSYSTEMKEY = 'xxxxAccountingFlexfield\_2'
WHERE brl.LOADID = 625
ORDER BY tpp.PERIODKEY, spp.PERIODKEY
2019-02-10 04:55:10,674 DEBUG [AIF]: periodSQL - periodParams: [u'xxxxAccountingFlexfield_2_625.dat', u'xxxx', u'xxxxAccountingFlexfield_2', 625]
2019-02-10 04:55:10,738 DEBUG [AIF]: insertRowCount: 1
2019-02-10 04:55:10,739 DEBUG [AIF]: CommData.insertEpmPeriods - END
2019-02-10 04:55:10,739 DEBUG [AIF]: CommData.updateBalRuleLoadParams - START
2019-02-10 04:55:10,742 DEBUG [AIF]: yearDimensionName=, yearFilter=
2019-02-10 04:55:10,742 DEBUG [AIF]: periodDimensionName=AccountingPeriod, periodFilter="Mar-17-18"
2019-02-10 04:55:10,745 DEBUG [AIF]: CommData.updateBalRuleLoadParams - END
2019-02-10 04:55:10,745 DEBUG [AIF]: CommData.getPovList - START
2019-02-10 04:55:10,745 DEBUG [AIF]:
SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY
,COALESCE(pp.PERIODDESC, TO\_CHAR(pprd.PERIODKEY,'YYYY-MM-DD HH24:MI:SS')) PERIODDESC
,brl.RULE\_ID, br.RULE\_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK\_FLAG
FROM AIF\_BAL\_RULE\_LOADS brl
INNER JOIN AIF\_BALANCE\_RULES br
ON br.RULE\_ID = brl.RULE\_ID
INNER JOIN TPOVPARTITION part
ON part.PARTITIONKEY = brl.PARTITIONKEY
INNER JOIN TPOVCATEGORY cat
ON cat.CATKEY = brl.CATKEY
INNER JOIN AIF\_PROCESS\_PERIODS pprd
ON pprd.PROCESS\_ID = brl.LOADID
LEFT OUTER JOIN TPOVPERIODADAPTOR pp
ON pp.PERIODKEY = pprd.PERIODKEY AND pp.INTSYSTEMKEY = 'xxxx'
LEFT OUTER JOIN TLOGPROCESS tlp
ON tlp.PARTITIONKEY = brl.PARTITIONKEY AND tlp.CATKEY = brl.CATKEY AND tlp.PERIODKEY = pprd.PERIODKEY AND tlp.RULE\_ID = brl.RULE\_ID
WHERE brl.LOADID = 625
ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE\_ID
2019-02-10 04:55:10,747 DEBUG [AIF]: CommData.getPovList - END
2019-02-10 04:55:10,747 DEBUG [AIF]: CommData.preImportData - END
2019-02-10 04:55:10,804 DEBUG [AIF]: CommData.extractDataFromSource - START
2019-02-10 04:55:10,804 DEBUG [AIF]: AIFUtil.callOdiServlet - START
2019-02-10 04:55:10,823 INFO [AIF]: EssbaseService.extractData - START
2019-02-10 04:55:10,872 DEBUG [AIF]: appId:14, appType:ESSBASE, mcFlag:false, dataLoadMethod:FUSION_GL_CLOUD, mDataFlowNode:LOCAL, textDataLoad:N, isFccsLoad:false, isJournalLoad:false
2019-02-10 04:55:10,872 DEBUG [AIF]: LOAD_METHOD:HPL, LOAD_TYPE:Data, EXPORT_MODE:Replace, CREATE_DRILL_REGION:false, PURGE_DATA_FILE:false, EXPORT_FILE_DELIMITER:comma, BATCH_SIZE:10000
2019-02-10 04:55:10,958 INFO [AIF]: cloudServiceType: FCCS, Resolved user: epm_default_cloud_admin, planningUserName: xxxx@xxxx.com
2019-02-10 04:55:10,958 DEBUG [AIF]: No need to connect to Essbase server.
2019-02-10 04:55:10,966 DEBUG [AIF]: Extracting data from xxxxAccountingFlexfield_2:db...
2019-02-10 04:55:11,007 INFO [AIF]: Preparing the data extract Script...
2019-02-10 04:55:11,007 DEBUG [AIF]: Extract Script (MDX): SELECT {[AccountingPeriod].[Mar-17-18]} ON COLUMNS,NON EMPTY {CROSSJOIN({Descendants([xxxx Service line].[All xxxx Service line Values],[xxxx Service line].Levels(0))},CROSSJOIN({Descendants([xxxx Future 2].[All xxxx Future 2 Values],[xxxx Future 2].Levels(0))},CROSSJOIN({[Scenario].[Actual]},CROSSJOIN({[Amount Type].[YTD]},CROSSJOIN({[Currency Type].[Total]},CROSSJOIN({Descendants([xxxx Account].[All xxxx Account Values],[xxxx Account].Levels(0))},CROSSJOIN({Descendants([Currency].[Currency],[Currency].Levels(0))},CROSSJOIN({[Ledger].[xxxx Secondary Ledger]},CROSSJOIN({[xxxx Legal Entity].[All xxxx Legal Entity Values].[400]},CROSSJOIN({[Balance Amount].[Ending Balance]},CROSSJOIN({Descendants([xxxx Cost Center].[All xxxx Cost Center Values],[xxxx Cost Center].Levels(0))},CROSSJOIN({Descendants([xxxx Interco].[All xxxx Interco Values],[xxxx Interco].Levels(0))},CROSSJOIN({Descendants([xxxx Future 1].[All xxxx Future 1 Values],[xxxx Future 1].Levels(0))},{Descendants([xxxx Geography].[All xxxx Geography Values],[xxxx Geography].Levels(0))})))))))))))))} ON ROWS FROM xxxxAccountingFlexfield_2.db
2019-02-10 04:55:11,010 INFO [AIF]: EssbaseService.extractData - END (true)
2019-02-10 04:55:11,022 DEBUG [AIF]: AIFUtil.callOdiServlet - END
2019-02-10 04:55:11,022 DEBUG [AIF]: Comm.executeFusionService - START
2019-02-10 04:55:11,023 DEBUG [AIF]: Comm.doScriptInit - START
2019-02-10 04:55:11,068 DEBUG [AIF]: fdmContext: {PERIODKEY=2018-03-31, CATKEY=1, APPNAME=xxxx, EXPORTFLAG=Y, SOURCEID=15, TARGETAPPNAME=xxxx, USERLOCALE=en, IMPORTFLAG=Y, SCRIPTSDIR=/u03/inbox/data/scripts, SOURCENAME=xxxx_Fusion, PERIODNAME=Mar-18, BATCHSCRIPTDIR=/u02/user_projects/instance0/FinancialDataQuality, LOCNAME=xxxx, USERNAME=xxxx@xxxx.com, APPROOTDIR=/u03/inbox, EPMORACLEHOME=/u02/Oracle/Middleware/EPMSystem11R1, TARGETAPPTYPE=HPL, OUTBOXDIR=/u03/inbox/outbox, TARGETAPPDB=PLAN1, FILEDIR=inbox, APPID=14, MULTIPERIODLOAD=N, LOADID=625, RULEID=24, IMPORTMODE=REPLACE, SOURCETYPE=FUSION_GL_CLOUD, CATNAME=Actual, RULENAME=xxxx, LOCKEY=25, EXPORTMODE=Replace, INBOXDIR=/u03/inbox/inbox, EPMORACLEINSTANCEHOME=/u02/user_projects/instance0, IMPORTFORMAT=xxxx}
2019-02-10 04:55:11,072 DEBUG [AIF]: The executeEventScript is set to: NO
2019-02-10 04:55:11,072 DEBUG [AIF]: The AppRootFolder is set to: /u03/inbox
2019-02-10 04:55:11,073 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35
2019-02-10 04:55:11,073 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE
2019-02-10 04:55:11,073 DEBUG [AIF]: Comm.doScriptInit - END
2019-02-10 04:55:11,073 DEBUG [AIF]: Comm.executeJythonScript - START
2019-02-10 04:55:11,074 INFO [AIF]: Executing the following script: /u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py
2019-02-10 04:55:11,088 INFO [AIF]: FusionCloudAdapter.extractBalanceData - START
2019-02-10 04:55:11,088 INFO [AIF]: FusionCloudAdapter.fusionCloudHelper - START
2019-02-10 04:55:11,088 DEBUG [AIF]: /u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.sh "/u02/Oracle/Middleware/EPMSystem11R1" "/u02/user_projects/instance0" "extractBalanceData" "625"
2019-02-10 04:55:40,340 INFO [AIF]: Standard Output: INFO: Starting script FusionCloudAdapter...
PBCS Production Deployment setup proxy
Starting FusionAdapter main program...
prod mode: extractBalanceData, pid: 625
Initializing FusionAdapter in prod mode...
fusionIntegrationType: V2
fusionGlWebServiceWsdl: xxxxekia-test.fa.em2.oraclecloud.com/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL
fusionGlWebServiceUser: xxxxraj@xxxx.com
batchTimeoutInMinutes: 30
processFlow: DL
fusionProductType: null
FusionAdapter initialized fine.
Submitted request to extract balance data, Ess request: 20686
Current polled request status is: WAIT
Current polled request status is: SUCCEEDED
Ess request has completed fine.
Document Name: 20686.zip
Skipping file: /u02/user_projects/instance0/tmp/20686.log
Downloading file: /u02/user_projects/instance0/tmp/20686.txt
downloadedDataFileFullName: /u02/user_projects/instance0/tmp/20686.txt
Copying downloaded data file to: /u03/inbox/data/xxxxAccountingFlexfield_2_625.dat
Updated data file location in temp table: /u03/inbox/data/xxxxAccountingFlexfield_2_625.dat
Deleting temporary file: /u02/user_projects/instance0/tmp/20686.txt
The FusionAdapter main program has completed.
INFO: The script FusionCloudAdapter has completed.
2019-02-10 04:55:40,340 INFO [AIF]: FusionCloudAdapter.fusionCloudHelper - END
2019-02-10 04:55:40,340 INFO [AIF]: FusionCloudAdapter.extractBalanceData - END
2019-02-10 04:55:40,341 DEBUG [AIF]: Comm.executeJythonScript - END
2019-02-10 04:55:40,342 DEBUG [AIF]: Comm.executeFusionService - END
2019-02-10 04:55:40,342 DEBUG [AIF]: UPDATE aif_bal_rule_loads SET file_path = 'data', file_name_static = 'xxxxAccountingFlexfield_2_625.dat' WHERE loadid = 625
2019-02-10 04:55:40,344 DEBUG [AIF]: Updated data file name in bal rule loads table: xxxxAccountingFlexfield_2_625.dat
2019-02-10 04:55:40,344 DEBUG [AIF]:
UPDATE AIF\_PROCESS\_DETAILS
SET STATUS = 'SUCCESS'
,RECORDS\_PROCESSED = CASE WHEN RECORDS\_PROCESSED IS NULL THEN 0 ELSE RECORDS\_PROCESSED END + NULL
,EXECUTION\_END\_TIME = CURRENT\_TIMESTAMP
,LAST\_UPDATED\_BY = CASE WHEN (NULL IS NULL) THEN LAST\_UPDATED\_BY ELSE NULL END
,LAST\_UPDATE\_DATE = CURRENT\_TIMESTAMP
WHERE PROCESS\_ID = 625 AND ENTITY\_TYPE = 'PROCESS\_EXTRACT\_ESS' AND ENTITY\_NAME = 'xxxxAccountingFlexfield\_2'
2019-02-10 04:55:40,347 DEBUG [AIF]: CommData.extractDataFromSource - END
2019-02-10 04:55:40,378 DEBUG [AIF]: CommData.insertImportProcessDetails - START
2019-02-10 04:55:40,379 DEBUG [AIF]:
INSERT INTO AIF\_PROCESS\_DETAILS (
PROCESS\_ID, ENTITY\_TYPE, ENTITY\_ID, ENTITY\_NAME, ENTITY\_NAME\_ORDER, TARGET\_TABLE\_NAME, EXECUTION\_START\_TIME
,EXECUTION\_END\_TIME, RECORDS\_PROCESSED, STATUS, LAST\_UPDATED\_BY, LAST\_UPDATE\_DATE
)
SELECT PROCESS\_ID, ENTITY\_TYPE, ENTITY\_ID, ENTITY\_NAME, ENTITY\_NAME\_ORDER, 'TDATASEG' TARGET\_TABLE\_NAME, CURRENT\_TIMESTAMP EXECUTION\_START\_TIME
,NULL EXECUTION\_END\_TIME, 0 RECORDS\_PROCESSED, 'PENDING' STATUS, ['xxxx@xxxx.com](mailto:'xxxx@xxxx.com)' LAST\_UPDATED\_BY, CURRENT\_TIMESTAMP LAST\_UPDATE\_DATE
FROM (
SELECT DISTINCT PROCESS\_ID, IMP\_ENTITY\_TYPE ENTITY\_TYPE, IMP\_ENTITY\_ID ENTITY\_ID, IMP\_ENTITY\_NAME ENTITY\_NAME
,(COALESCE(SOURCE\_LEDGER\_ID,0) \* 100000000 + GL\_EFFECTIVE\_PERIOD\_NUM) ENTITY\_NAME\_ORDER
FROM AIF\_PROCESS\_PERIODS
WHERE PROCESS\_ID = 625
) q
ORDER BY ENTITY\_NAME\_ORDER
2019-02-10 04:55:40,382 DEBUG [AIF]: CommData.insertImportProcessDetails - END
2019-02-10 04:55:40,413 DEBUG [AIF]: FileData.importData - START
2019-02-10 04:55:40,413 DEBUG [AIF]: Importing data for load id: 625
2019-02-10 04:55:40,413 DEBUG [AIF]:
SELECT a.partitionkey, a.catkey, a.start\_periodkey, b.perioddesc, coalesce(a.journal\_flag,'N') JOURNAL\_FLAG, c.last\_updated\_by,
coalesce(a.FILE\_NAME\_STATIC,'') FILE\_NAME\_STATIC, a.FILE\_PATH, a.RULE\_ID, a.application\_id
FROM aif\_bal\_rule\_loads a,
aif\_balance\_rules br,
tpovperiodadaptor b,
aif\_processes c
WHERE a.loadid = 625
AND a.start\_periodkey=b.periodkey
AND a.loadid =c.process\_id
AND br.rule\_id = a.rule\_id
AND b.INTSYSTEMKEY = 'xxxx'
2019-02-10 04:55:40,416 DEBUG [AIF]: FileData.py: Importing Text data for load id: 625
2019-02-10 04:55:40,507 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH:IMPGROUPFILETYPE::625;25:1:24:Entity Currency:/u03/inbox/data:EPM_EPM
2019-02-10 04:55:40,514 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8
2019-02-10 04:55:40,514 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start
2019-02-10 04:55:40,514 DEBUG [AIF]: EPMFDM-140274:Message - SELECT pp.PERIODKEY,
pp.PERIODTARGET,
pp.GL_PERIOD_NAME,
en.FILE_ENTITY_NAME,
en.ENTITY_NAME_ORDER,
br.MULTI_PERIOD_FILE_FLAG,
pp.TRANS_ENTITY_NAME,
pp.GL_PERIOD_YEAR_CHAR,
pp.GL_PERIOD_NUM ,
pp.YEARTARGET
FROM AIF_PROCESS_PERIODS pp,
AIF_BALANCE_RULES br,
AIF_PROCESSES p,
(SELECT DISTINCT entity_name FILE_ENTITY_NAME,
pd.process\_id,
pd.entity\_name\_order
FROM aif_process_details pd
WHERE pd.entity_type = 'PROCESS_BAL_IMP_FILE'
AND pd.target_table_name = 'TDATASEG'
AND pd.status = 'PENDING'
) en
WHERE pp.PROCESS_ID = ?
AND p.process_id = pp.process_id
AND en.process_id = pp.process_id
AND pp.IMP_ENTITY_NAME = en.file_entity_name
AND br.rule_id = p.rule_id
AND en.entity_name_order = pp.GL_EFFECTIVE_PERIOD_NUM
ORDER BY en.entity_name_order
2019-02-10 04:55:40,563 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=NZP:StartPos=1:SourceClName=Amount:ImpFldTargetExp=null
2019-02-10 04:55:40,563 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=xxxx Account:ImpFldTargetExp=null
2019-02-10 04:55:40,563 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=xxxx Legal Entity:ImpFldTargetExp=null
2019-02-10 04:55:40,563 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ICP:ImpFieldText=null:StartPos=1:SourceClName=xxxx Interco:ImpFldTargetExp=null
2019-02-10 04:55:40,563 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=1:SourceClName=xxxx Service line:ImpFldTargetExp=null
2019-02-10 04:55:40,564 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps
2019-02-10 04:55:40,564 INFO [AIF]: EPMFDM-140274:Message - File Name xxxxAccountingFlexfield_2_625.dat
periodKey2018-03-31
2019-02-10 04:55:40,564 INFO [AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM() ESSBASE
2019-02-10 04:55:40,565 DEBUG [AIF]: EPMFDM-140274:Message - HEADER: ["xxxx Service line", "xxxx Future 2", "Scenario", "Amount Type", "Currency Type", "xxxx Account", "Currency", "Ledger", "xxxx Legal Entity", "Balance Amount", "xxxx Cost Center", "xxxx Interco", "xxxx Future 1", "xxxx Geography", "AccountingPeriod"]
2019-02-10 04:55:40,569 DEBUG [AIF]: EPMFDM-140274:Message - FUSION_GL_CLOUD source
2019-02-10 04:55:40,569 DEBUG [AIF]: EPMFDM-140274:Message - select tad.TARGET_DIMENSION_NAME,tad.BALANCE_COLUMN_NAME,substr(tad.BALANCE_COLUMN_NAME,3,2)*1 COLUMN_ORDER
from aif\_processes p,
tpovpartition pt,
tbhvimpgroup ig,
aif\_balance\_rules br,
aif\_target\_appl\_dimensions tad
where p.process\_id = ?
and p.partitionkey = pt.partitionkey
and pt.partimpgroup = coalesce( br.IMPGROUPKEY, ig.IMPGROUPKEY)
and br.rule\_id=p.rule\_id
and ig.IMPSOURCELEDGERID = tad.APPLICATION\_ID
and balance\_column\_name like 'UD%'
order by COLUMN\_ORDER
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DESC1:ImpFieldText=.:StartPos=1:SourceClName=xxxx Service line:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CODE_COMBINATION_ID:ImpFieldText=.:StartPos=1:SourceClName=xxxx Service line:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CODE_COMBINATION_ID:ImpFieldText=null:StartPos=1:SourceClName=xxxx Legal Entity:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DESC1:ImpFieldText=null:StartPos=1:SourceClName=xxxx Legal Entity:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CODE_COMBINATION_ID:ImpFieldText=null:StartPos=1:SourceClName=xxxx Service line:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DESC1:ImpFieldText=null:StartPos=1:SourceClName=xxxx Service line:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CODE_COMBINATION_ID:ImpFieldText=null:StartPos=1:SourceClName=xxxx Geography:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DESC1:ImpFieldText=null:StartPos=1:SourceClName=xxxx Geography:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CODE_COMBINATION_ID:ImpFieldText=null:StartPos=1:SourceClName=xxxx Cost Center:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DESC1:ImpFieldText=null:StartPos=1:SourceClName=xxxx Cost Center:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CODE_COMBINATION_ID:ImpFieldText=null:StartPos=1:SourceClName=xxxx Account:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DESC1:ImpFieldText=null:StartPos=1:SourceClName=xxxx Account:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CODE_COMBINATION_ID:ImpFieldText=null:StartPos=1:SourceClName=xxxx Interco:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DESC1:ImpFieldText=null:StartPos=1:SourceClName=xxxx Interco:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CODE_COMBINATION_ID:ImpFieldText=null:StartPos=1:SourceClName=xxxx Future 1:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DESC1:ImpFieldText=null:StartPos=1:SourceClName=xxxx Future 1:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CODE_COMBINATION_ID:ImpFieldText=null:StartPos=1:SourceClName=xxxx Future 2:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DESC1:ImpFieldText=null:StartPos=1:SourceClName=xxxx Future 2:ImpFldTargetExp=null
2019-02-10 04:55:40,602 DEBUG [AIF]: EPMFDM-140274:Message - select tad.TARGET_DIMENSION_NAME ,
case tad.TARGET\_DIM\_CLASS\_NAME\_ORG when 'LEDGER' THEN 'ATTR7'
WHEN 'BALANCE AMOUNT' THEN 'ATTR9'
WHEN 'AMOUNT TYPE' THEN 'ATTR10'
WHEN 'ACCOUNTINGPERIOD' THEN 'ATTR11'
WHEN 'SCENARIO' THEN 'ATTR6'
WHEN 'CURRENCY TYPE' THEN 'ATTR13'
WHEN 'CURRENCY' THEN 'CURKEY'
ELSE tad.TARGET\_DIM\_CLASS\_NAME\_ORG
END BALANCE\_COLUMN
from aif\_processes p,
tpovpartition pt,
tbhvimpgroup ig,
aif\_balance\_rules br,
aif\_target\_appl\_dimensions tad
where p.process\_id = ?
and p.partitionkey = pt.partitionkey
and pt.partimpgroup = coalesce( br.IMPGROUPKEY, ig.IMPGROUPKEY)
and br.rule\_id=p.rule\_id
and ig.IMPSOURCELEDGERID = tad.APPLICATION\_ID
and tad.target\_dim\_class\_name\_org in ('SCENARIO','BALANCE AMOUNT','AMOUNT TYPE','CURRENCY','CURRENCY TYPE','ACCOUNTINGPERIOD','LEDGER')
order by balance\_column\_name
2019-02-10 04:55:40,603 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR7:ImpFieldText=null:StartPos=1:SourceClName=Ledger:ImpFldTargetExp=null
2019-02-10 04:55:40,604 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR6:ImpFieldText=null:StartPos=1:SourceClName=Scenario:ImpFldTargetExp=null
2019-02-10 04:55:40,604 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR10:ImpFieldText=null:StartPos=1:SourceClName=Amount Type:ImpFldTargetExp=null
2019-02-10 04:55:40,604 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR8:ImpFieldText=null:StartPos=1:SourceClName=Currency:ImpFldTargetExp=null
2019-02-10 04:55:40,604 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CURKEY:ImpFieldText=Entity Currency:StartPos=1:SourceClName=Currency:ImpFldTargetExp=null
2019-02-10 04:55:40,604 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR13:ImpFieldText=null:StartPos=1:SourceClName=Currency Type:ImpFldTargetExp=null
2019-02-10 04:55:40,604 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR11:ImpFieldText="Mar-17-18":StartPos=1:SourceClName=AccountingPeriod:ImpFldTargetExp=null
2019-02-10 04:55:40,604 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR9:ImpFieldText=null:StartPos=1:SourceClName=Balance Amount:ImpFldTargetExp=null
2019-02-10 04:55:40,604 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR12:ImpFieldText=FUSIONGL:StartPos=1:SourceClName=xxxx Legal Entity:ImpFldTargetExp=null
2019-02-10 04:55:40,677 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 625
PARTITIONKEY: 25
IMPORT GROUP: xxxx
FILE TYPE: DELIMITED
DELIMITER: ,
SOURCE FILE: xxxxAccountingFlexfield_2_625.dat
PROCESSING CODES:
-----------------------------------------------------------------------------------
BLANK............. Line is blank or empty.
NN................ Non-Numeric, Amount field contains non numeric characters.
TC................ Type Conversion, Amount field could not be converted to a number.
ZP................ Zero Suppress, Amount field contains a 0 value and zero suppress is ON.
SKIP FIELD.............. SKIP field value was found
NULL ACCOUNT VALUE.............. Account Field is null
SKIP FROM SCRIPT.............. Skipped through Script
HEADER ROW.............. Header Row
ERROR_INVALID_PERIOD.............. Invalid period specified in the file.
Rows Loaded: 90
Rows Rejected: 0
2019-02-10 04:55:40,679 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- Start
2019-02-10 04:55:40,680 INFO [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy
2019-02-10 04:55:40,681 INFO [AIF]: EPMFDM-140274:Message - Start archiving file:
2019-02-10 04:55:40,681 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 62520180331
2019-02-10 04:55:40,681 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: xxxxAccountingFlexfield_2_625
Extension: dat
2019-02-10 04:55:40,682 INFO [AIF]: EPMFDM-140274:Message - Archive file name: 62520180331.dat
2019-02-10 04:55:40,683 INFO [AIF]: EPMFDM-140274:Message - Deleting the source file: xxxxAccountingFlexfield_2_625.dat
2019-02-10 04:55:40,683 INFO [AIF]: EPMFDM-140274:Message - File not deleted: /u03/inbox/data/xxxxAccountingFlexfield_2_625.dat
2019-02-10 04:55:40,686 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveDocKey:xxxxAccountingFlexfield_2_625-xxxx@xxxx.com-20190210_045540-1
2019-02-10 04:55:40,690 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- End
2019-02-10 04:55:40,690 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - End
2019-02-10 04:55:40,690 INFO [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 176
2019-02-10 04:55:40,694 DEBUG [AIF]: FileData.importData - END
2019-02-10 04:55:40,789 DEBUG [AIF]: CommData.postImportData - START
2019-02-10 04:55:40,789 DEBUG [AIF]: CommData.updateTDATASEG_T - START
2019-02-10 04:55:40,789 DEBUG [AIF]:
SELECT pp.PERIODKEY
FROM AIF\_PROCESS\_PERIODS pp
,( SELECT entity\_name FILE\_ENTITY\_NAME, pd.process\_id, pd.entity\_name\_order
FROM aif\_process\_details pd
WHERE pd.entity\_type = 'PROCESS\_BAL\_IMP\_FILE' AND pd.target\_table\_name = 'TDATASEG' AND pd.status = 'FAILED'
) en
WHERE pp.PROCESS\_ID = 625
AND en.process\_id = pp.process\_id
AND pp.IMP\_ENTITY\_NAME = en.file\_entity\_name
order by en.entity\_name\_order
2019-02-10 04:55:40,791 INFO [AIF]:
Import Data from Source for Period 'Mar-18'
2019-02-10 04:55:40,791 DEBUG [AIF]: CommData.updateWorkflow - START
2019-02-10 04:55:40,791 DEBUG [AIF]:
SELECT tlp.PROCESSSTATUS, tlps.PROCESSSTATUSDESC, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK\_FLAG
FROM TLOGPROCESS tlp, TLOGPROCESSSTATES tlps
WHERE tlp.PARTITIONKEY = 25 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2018-03-31' AND tlp.RULE\_ID = 24 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS
2019-02-10 04:55:40,793 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME=CURRENT\_TIMESTAMP
,PROCESSSTATUS=0,PROCESSIMP=0,PROCESSVAL=0,PROCESSEXP=0,PROCESSENTLOAD=0,PROCESSENTVAL=0,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0
,PROCESSIMPNOTE=NULL,PROCESSVALNOTE=NULL,PROCESSEXPNOTE=NULL,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL
WHERE PARTITIONKEY=25 AND CATKEY=1 AND PERIODKEY='2018-03-31' AND RULE\_ID=24
2019-02-10 04:55:40,795 DEBUG [AIF]: CommData.updateWorkflow - END
2019-02-10 04:55:40,796 DEBUG [AIF]: CommData.updateTDATASEG_T - END
2019-02-10 04:55:40,796 DEBUG [AIF]: CommData.postImportData - END
2019-02-10 04:55:40,826 DEBUG [AIF]: LogicGroup.createLogicAccounts - START
2019-02-10 04:55:40,826 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START
2019-02-10 04:55:40,827 DEBUG [AIF]:
select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE
from AIF\_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp
where prs.PROCESS\_ID=625 and prs.PARTITIONKEY=part.PARTITIONKEY
and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY
2019-02-10 04:55:40,828 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END
2019-02-10 04:55:40,828 DEBUG [AIF]: Logic group Logic Grp xxxx is found.
2019-02-10 04:55:40,828 DEBUG [AIF]:
select litm.CALCGROUPKEY LOGICGROUP, litm.CALCSTMTACCOUNT LOGICACCOUNT, litm.CALCSTMTWHERECLAUSETYPE WHERECLAUSETYPE,
litm.CALCSTMTWHERECLAUSEVALUE WHERECLAUSEVALUE, litm.CALCSTMTMATHOPERATOR MATHOPERATOR,
litm.CALCSTMTEXPORTACCOUNT EXPORTACCOUNT, litm.CALCSTMTMATHVALUE MATHVALUE, litm.INCLUDECALCULATED INCLUDECALCULATED
from TBHVLOGICITEM litm
where litm.CALCGROUPKEY='Logic Grp xxxx'
order by litm.CALCSTMTSEQUENCE
2019-02-10 04:55:40,830 DEBUG [AIF]: Simple logic account processing
2019-02-10 04:55:40,831 DEBUG [AIF]:
select BALANCE\_COLUMN\_NAME from AIF\_TARGET\_APPL\_DIMENSIONS
where APPLICATION\_ID=14 and BALANCE\_COLUMN\_NAME is not null
and BALANCE\_COLUMN\_NAME NOT IN ('ENTITY', 'ACCOUNT')
2019-02-10 04:55:40,832 DEBUG [AIF]:
INSERT INTO TDATASEG\_T (
LOADID, PARTITIONKEY, CATKEY, RULE\_ID, PERIODKEY
,ACCOUNT, ENTITY, VALID\_FLAG, CURKEY, CALCACCTTYPE, ATTR13
,AMOUNT, AMOUNTX
,ICP,UD2,UD3,UD4,UD5,UD6,UD7,UD1,DATAVIEW,JOURNALID
,DATAKEY
)
SELECT
LOADID, PARTITIONKEY, CATKEY, RULE\_ID, PERIODKEY
,ACCOUNT, ENTITY, VALID\_FLAG, CURKEY, CALCACCTTYPE, ATTR13
,AMOUNT, AMOUNTX
,ICP,UD2,UD3,UD4,UD5,UD6,UD7,UD1,DATAVIEW,JOURNALID
,TDATASEG\_DATAKEY\_S.NEXTVAL AS DATAKEY
FROM (
SELECT LOADID, PARTITIONKEY, CATKEY, RULE\_ID, PERIODKEY
,'L\_TB\_Check' AS ACCOUNT, ENTITY, 'Y' AS VALID\_FLAG, CURKEY, -1 AS CALCACCTTYPE, 'L\_TB\_Check' AS ATTR13
,SUM(AMOUNT) AMOUNT, SUM(AMOUNTX) AMOUNTX
,ICP,UD2,UD3,UD4,UD5,UD6,UD7,UD1,DATAVIEW,JOURNALID
FROM TDATASEG\_T
WHERE LOADID=625 AND (1=1)
GROUP BY LOADID, PARTITIONKEY, CATKEY, RULE\_ID, PERIODKEY, CURKEY
,ENTITY,ICP,UD2,UD3,UD4,UD5,UD6,UD7,UD1,DATAVIEW,JOURNALID
) LOGIC\_ACCOUNT
2019-02-10 04:55:40,835 DEBUG [AIF]: Inserted 10 rows for logic account L_TB_Check
2019-02-10 04:55:40,837 DEBUG [AIF]: LogicGroup.createLogicAccounts - END
2019-02-10 04:55:40,867 DEBUG [AIF]: CommData.mapData - START
2019-02-10 04:55:40,867 DEBUG [AIF]: CommData.insertTransProcessDetails - START
2019-02-10 04:55:40,867 DEBUG [AIF]:
INSERT INTO AIF\_PROCESS\_DETAILS (
PROCESS\_ID, ENTITY\_TYPE, ENTITY\_ID, ENTITY\_NAME, ENTITY\_NAME\_ORDER, TARGET\_TABLE\_NAME, EXECUTION\_START\_TIME
,EXECUTION\_END\_TIME, RECORDS\_PROCESSED, STATUS, LAST\_UPDATED\_BY, LAST\_UPDATE\_DATE
)
SELECT PROCESS\_ID, ENTITY\_TYPE, ENTITY\_ID, ENTITY\_NAME, ENTITY\_NAME\_ORDER, 'TDATASEG' TARGET\_TABLE\_NAME, CURRENT\_TIMESTAMP EXECUTION\_START\_TIME
,NULL EXECUTION\_END\_TIME, 0 RECORDS\_PROCESSED, 'PENDING' STATUS, ['xxxx@xxxx.com](mailto:'xxxx@xxxx.com)' LAST\_UPDATED\_BY, CURRENT\_TIMESTAMP LAST\_UPDATE\_DATE
FROM (
SELECT PROCESS\_ID, TRANS\_ENTITY\_TYPE ENTITY\_TYPE, MIN(TRANS\_ENTITY\_ID) ENTITY\_ID, TRANS\_ENTITY\_NAME ENTITY\_NAME
,MIN(COALESCE(SOURCE\_LEDGER\_ID,0) \* 100000000 + GL\_EFFECTIVE\_PERIOD\_NUM) ENTITY\_NAME\_ORDER
FROM AIF\_PROCESS\_PERIODS
WHERE PROCESS\_ID = 625
AND PRIOR\_PERIOD\_FLAG = 'N'
GROUP BY PROCESS\_ID, TRANS\_ENTITY\_TYPE, TRANS\_ENTITY\_NAME
) q
ORDER BY ENTITY\_NAME\_ORDER
2019-02-10 04:55:40,870 DEBUG [AIF]: CommData.insertTransProcessDetails - END
2019-02-10 04:55:40,870 DEBUG [AIF]:
DELETE FROM TDATAMAP\_T
WHERE LOADID \< 625
AND EXISTS ( SELECT 1 FROM AIF\_PROCESSES p WHERE p.RULE\_ID = 24 AND p.PROCESS\_ID = TDATAMAP\_T.LOADID )
2019-02-10 04:55:40,873 DEBUG [AIF]:
SELECT COUNT(\*) FROM TDATASEG\_T
WHERE LOADID \< 625
AND EXISTS ( SELECT 1 FROM AIF\_PROCESSES p WHERE p.RULE\_ID = 24 AND p.PROCESS\_ID = TDATASEG\_T.LOADID )
2019-02-10 04:55:40,874 DEBUG [AIF]: intermediateCommit: True, skipRegularSql: False
2019-02-10 04:55:40,876 INFO [AIF]: Executing delete statement:
2019-02-10 04:55:40,876 DEBUG [AIF]:
DELETE FROM TDATASEG\_T
WHERE LOADID \< 625
AND EXISTS ( SELECT 1 FROM AIF\_PROCESSES p WHERE p.RULE\_ID = 24 AND p.PROCESS\_ID = TDATASEG\_T.LOADID )
2019-02-10 04:55:40,879 INFO [AIF]: Successfully executed delete statement
2019-02-10 04:55:40,880 DEBUG [AIF]:
DELETE FROM AIF\_PROCESS\_PERIODS
WHERE PROCESS\_ID \< 625
AND EXISTS ( SELECT 1 FROM AIF\_PROCESSES p WHERE p.RULE\_ID = 24 AND p.PROCESS\_ID = AIF\_PROCESS\_PERIODS.PROCESS\_ID )
2019-02-10 04:55:40,883 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START
2019-02-10 04:55:40,883 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START
2019-02-10 04:55:40,883 DEBUG [AIF]:
SELECT COALESCE(part\_parent.PARTITIONKEY, part.PARTITIONKEY) PARTITIONKEY, COALESCE(part\_parent.PARTNAME, part.PARTNAME) PARTNAME
FROM TPOVPARTITION part
LEFT OUTER JOIN TPOVPARTITION part\_parent
ON part\_parent.PARTITIONKEY = part.PARTPARENTKEY
WHERE part.PARTITIONKEY = 25
2019-02-10 04:55:40,884 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END
2019-02-10 04:55:40,885 INFO [AIF]: Processing Mappings from Parent Location: CCPL
2019-02-10 04:55:40,885 DEBUG [AIF]:
INSERT INTO TDATAMAP\_T (
LOADID, DATAKEY, PARTITIONKEY, DIMNAME, SRCKEY, SRCDESC, TARGKEY
,WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM\_GENERATED\_FLAG, RULE\_ID
)
SELECT 625, DATAKEY, 25 PARTITIONKEY, DIMNAME, SRCKEY, SRCDESC, CASE WHEN TARGKEY = '\<BLANK>' THEN ' ' ELSE TARGKEY END
,WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM\_GENERATED\_FLAG, RULE\_ID
FROM TDATAMAP
WHERE PARTITIONKEY = 20
AND ( RULE\_ID IS NULL OR RULE\_ID = 24 )
2019-02-10 04:55:40,891 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 54
2019-02-10 04:55:40,893 DEBUG [AIF]: CommMap.loadTDATAMAP_T - END
2019-02-10 04:55:40,893 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START
2019-02-10 04:55:40,893 DEBUG [AIF]:
SELECT DIMNAME, SRCKEY, TARGKEY, WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, DATAKEY, MAPPING\_TYPE
,CASE WHEN (RULE\_ID IS NOT NULL) THEN 'Y' ELSE 'N' END IS\_RULE\_MAP
FROM (
SELECT DISTINCT tdm.DIMNAME, tdm.RULE\_ID, NULL SRCKEY, NULL TARGKEY, tdm.WHERECLAUSETYPE, tdm.WHERECLAUSEVALUE, NULL CHANGESIGN
,1 SEQUENCE, COALESCE(tdm.SYSTEM\_GENERATED\_FLAG,'N') SYSTEM\_GENERATED\_FLAG, NULL DATAKEY
,CASE WHEN tdm.WHERECLAUSETYPE IS NULL THEN 1 ELSE 3 END MAPPING\_TYPE, COALESCE(atad.CALC\_SEQ,9999999999) CALC\_SEQ
FROM TDATAMAP\_T tdm
INNER JOIN AIF\_TARGET\_APPL\_DIMENSIONS atad ON atad.BALANCE\_COLUMN\_NAME = tdm.DIMNAME
WHERE tdm.LOADID = 625
AND atad.APPLICATION\_ID = 14
AND tdm.PARTITIONKEY = 25
AND tdm.TDATAMAPTYPE = 'ERP'
AND (tdm.RULE\_ID IS NULL OR tdm.RULE\_ID = 24)
AND tdm.WHERECLAUSETYPE IS NULL
UNION ALL
SELECT tdm.DIMNAME, tdm.RULE\_ID, tdm.SRCKEY, tdm.TARGKEY, tdm.WHERECLAUSETYPE, tdm.WHERECLAUSEVALUE, tdm.CHANGESIGN
,CASE WHEN (tdm.WHERECLAUSETYPE = 'BETWEEN') THEN 2 WHEN (tdm.WHERECLAUSETYPE = 'IN') THEN 3
WHEN (tdm.WHERECLAUSETYPE = 'MULTIDIM') THEN 4 WHEN (tdm.WHERECLAUSETYPE = 'LIKE') THEN 5
ELSE 0 END SEQUENCE
,COALESCE(tdm.SYSTEM\_GENERATED\_FLAG,'N') SYSTEM\_GENERATED\_FLAG, tdm.DATAKEY
,CASE WHEN tdm.WHERECLAUSETYPE IS NULL THEN 1 ELSE 3 END MAPPING\_TYPE, COALESCE(atad.CALC\_SEQ,9999999999) CALC\_SEQ
FROM TDATAMAP\_T tdm
INNER JOIN TPOVPARTITION tpp ON tpp.PARTITIONKEY = tdm.PARTITIONKEY
INNER JOIN AIF\_TARGET\_APPL\_DIMENSIONS atad ON atad.BALANCE\_COLUMN\_NAME = tdm.DIMNAME
WHERE tdm.LOADID = 625
AND atad.APPLICATION\_ID = 14
AND tdm.PARTITIONKEY = 25
AND tdm.TDATAMAPTYPE = 'ERP'
AND (tdm.RULE\_ID IS NULL OR tdm.RULE\_ID = 24)
AND tdm.WHERECLAUSETYPE IN ('BETWEEN','IN','MULTIDIM','LIKE')
) q
ORDER BY CALC\_SEQ, DIMNAME, SEQUENCE, RULE\_ID, SYSTEM\_GENERATED\_FLAG, SRCKEY
2019-02-10 04:55:40,901 DEBUG [AIF]:
SELECT DIMNAME, WHERECLAUSETYPE, WHERECLAUSEVALUE
FROM (
SELECT DISTINCT tdm.DIMNAME
,CASE WHEN tdm.WHERECLAUSETYPE IS NULL THEN NULL ELSE tdm.SRCKEY END SRCKEY
,tdm.WHERECLAUSETYPE
,CASE WHEN tdm.WHERECLAUSEVALUE = '\<BLANK>' THEN ' ' ELSE tdm.WHERECLAUSEVALUE END WHERECLAUSEVALUE
,CASE WHEN (tdm.WHERECLAUSETYPE IS NULL) THEN 1
WHEN (tdm.WHERECLAUSETYPE = 'BETWEEN') THEN 2
WHEN (tdm.WHERECLAUSETYPE = 'IN') THEN 3
WHEN (tdm.WHERECLAUSETYPE = 'LIKE' ) THEN 4
ELSE 0
END SEQUENCE
FROM TDATAMAP\_T tdm
WHERE tdm.LOADID = 625
AND tdm.PARTITIONKEY = 25
AND tdm.TDATAMAPTYPE = 'MULTIDIM'
AND tdm.TARGKEY = '343'
AND (tdm.WHERECLAUSETYPE IS NULL OR tdm.WHERECLAUSETYPE = '' OR tdm.WHERECLAUSETYPE IN ('BETWEEN','IN','LIKE'))
) q
ORDER BY DIMNAME, SEQUENCE, SRCKEY
2019-02-10 04:55:40,901 DEBUG [AIF]: multiDimSQL: [625, 25L, '343']
2019-02-10 04:55:40,903 DEBUG [AIF]: multiDimSQL: [625, 25L, '341']
2019-02-10 04:55:40,905 DEBUG [AIF]: multiDimSQL: [625, 25L, '293']
2019-02-10 04:55:40,907 DEBUG [AIF]: multiDimSQL: [625, 25L, '288']
2019-02-10 04:55:40,908 DEBUG [AIF]: multiDimSQL: [625, 25L, '276']
2019-02-10 04:55:40,910 DEBUG [AIF]: multiDimSQL: [625, 25L, '271']
2019-02-10 04:55:40,912 DEBUG [AIF]: multiDimSQL: [625, 25L, '284']
2019-02-10 04:55:40,914 DEBUG [AIF]: multiDimSQL: [625, 25L, '274']
2019-02-10 04:55:40,915 DEBUG [AIF]: multiDimSQL: [625, 25L, '295']
2019-02-10 04:55:40,917 DEBUG [AIF]: multiDimSQL: [625, 25L, '286']
2019-02-10 04:55:40,918 DEBUG [AIF]: multiDimSQL: [625, 25L, '280']
2019-02-10 04:55:40,920 DEBUG [AIF]: multiDimSQL: [625, 25L, '291']
2019-02-10 04:55:40,922 INFO [AIF]:
Map Data for Period 'Mar-18'
2019-02-10 04:55:40,922 DEBUG [AIF]: Comm.updateProcessDetail - START
2019-02-10 04:55:40,923 DEBUG [AIF]:
UPDATE AIF\_PROCESS\_DETAILS
SET STATUS = 'RUNNING'
,RECORDS\_PROCESSED = CASE WHEN RECORDS\_PROCESSED IS NULL THEN 0 ELSE RECORDS\_PROCESSED END + NULL
,EXECUTION\_END\_TIME = CURRENT\_TIMESTAMP
,LAST\_UPDATED\_BY = CASE WHEN (['xxxx@xxxx.com](mailto:'xxxx@xxxx.com)' IS NULL) THEN LAST\_UPDATED\_BY ELSE ['xxxx@xxxx.com](mailto:'xxxx@xxxx.com)' END
,LAST\_UPDATE\_DATE = CURRENT\_TIMESTAMP
WHERE PROCESS\_ID = 625 AND ENTITY\_TYPE = 'PROCESS\_BAL\_TRANS' AND ENTITY\_NAME = 'Mar-18'
2019-02-10 04:55:40,926 DEBUG [AIF]: Comm.updateProcessDetail - END
2019-02-10 04:55:40,926 DEBUG [AIF]:
SELECT COUNT(\*) ROW\_COUNT
FROM TDATASEG\_T
WHERE LOADID = 625
AND (PARTITIONKEY = 25 AND CATKEY = 1 AND PERIODKEY = '2018-03-31' AND RULE\_ID = 24 AND VALID\_FLAG = 'Y')
2019-02-10 04:55:40,927 INFO [AIF]:
Processing Mappings for Column 'ACCOUNT'
2019-02-10 04:55:40,928 DEBUG [AIF]:
UPDATE TDATASEG\_T
SET (ACCOUNTX ,ACCOUNTR, AMOUNTX, CHANGESIGN, VALID\_FLAG) = (
SELECT tdm.TARGKEY
,tdm.DATAKEY
,AMOUNTX \* CASE tdm.CHANGESIGN WHEN 1 THEN -1 ELSE 1 END
,CASE tdm.CHANGESIGN
WHEN 1 THEN CASE TDATASEG\_T.CHANGESIGN
WHEN 1 THEN 0
WHEN 0 THEN 1
ELSE TDATASEG\_T.CHANGESIGN
END
ELSE TDATASEG\_T.CHANGESIGN
END
,CASE tdm.TARGKEY WHEN 'IGNORE' THEN 'I' ELSE TDATASEG\_T.VALID\_FLAG END
FROM TDATAMAP\_T tdm
WHERE tdm.LOADID = TDATASEG\_T.LOADID
AND tdm.PARTITIONKEY = TDATASEG\_T.PARTITIONKEY
AND tdm.DIMNAME = 'ACCOUNT'
AND tdm.WHERECLAUSETYPE IS NULL
AND tdm.SRCKEY = TDATASEG\_T.ACCOUNT
AND tdm.RULE\_ID IS NULL
AND tdm.TDATAMAPTYPE \<> 'MULTIDIM'
)
,ACCOUNTF = 1
WHERE LOADID = 625
AND PARTITIONKEY = 25
AND CATKEY = 1
AND (ACCOUNTX IS NULL OR ACCOUNTX = '')
AND EXISTS ( SELECT 1
FROM TDATAMAP\_T tdm
WHERE tdm.LOADID = TDATASEG\_T.LOADID
AND tdm.PARTITIONKEY = TDATASEG\_T.PARTITIONKEY
AND tdm.DIMNAME = 'ACCOUNT'
AND tdm.WHERECLAUSETYPE IS NULL
AND tdm.SRCKEY = TDATASEG\_T.ACCOUNT
AND tdm.RULE\_ID IS NULL
AND tdm.TDATAMAPTYPE \<> 'MULTIDIM' )
AND PERIODKEY = '2018-03-31'
2019-02-10 04:55:40,929 INFO [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0
2019-02-10 04:55:40,931 DEBUG [AIF]:
UPDATE TDATASEG\_T
SET ACCOUNTX = '5'||SUBSTR(ACCOUNT,1+1,LENGTH(ACCOUNT)-1)
,ACCOUNTR = 249
,ACCOUNTF = 3
WHERE LOADID = 625
AND PARTITIONKEY = 25
AND CATKEY = 1
AND (ACCOUNTX IS NULL OR ACCOUNTX = '')
AND (ACCOUNT LIKE '5%')
AND PERIODKEY = '2018-03-31'
2019-02-10 04:55:40,935 INFO [AIF]: Data Rows Updated by Location Mapping 'Current Assets' (LIKE): 13
2019-02-10 04:55:40,938 DEBUG [AIF]:
UPDATE TDATASEG\_T
SET ACCOUNTX = '3'||SUBSTR(ACCOUNT,1+1,LENGTH(ACCOUNT)-1)
,ACCOUNTR = 247
,ACCOUNTF = 3
,AMOUNTX = -AMOUNTX
,CHANGESIGN = CASE CHANGESIGN WHEN 0 THEN 1 ELSE 0 END
WHERE LOADID = 625
AND PARTITIONKEY = 25
AND CATKEY = 1
AND (ACCOUNTX IS NULL OR ACCOUNTX = '')
AND (ACCOUNT LIKE '3%')
AND PERIODKEY = '2018-03-31'
2019-02-10 04:55:40,939 INFO [AIF]: Data Rows Updated by Location Mapping 'Current Liabilities' (LIKE): 17
2019-02-10 04:55:40,942 DEBUG [AIF]:
UPDATE TDATASEG\_T
SET ACCOUNTX = '1'||SUBSTR(ACCOUNT,1+1,LENGTH(ACCOUNT)-1)
,ACCOUNTR = 245
,ACCOUNTF = 3
,AMOUNTX = -AMOUNTX
,CHANGESIGN = CASE CHANGESIGN WHEN 0 THEN 1 ELSE 0 END
WHERE LOADID = 625
AND PARTITIONKEY = 25
AND CATKEY = 1
AND (ACCOUNTX IS NULL OR ACCOUNTX = '')
AND (ACCOUNT LIKE '1%')
AND PERIODKEY = '2018-03-31'
2019-02-10 04:55:40,943 INFO [AIF]: Data Rows Updated by Location Mapping 'Equity' (LIKE): 0
2019-02-10 04:55:40,944 DEBUG [AIF]:
UPDATE TDATASEG\_T
SET ACCOUNTX = '7'||SUBSTR(ACCOUNT,1+1,LENGTH(ACCOUNT)-1)
,ACCOUNTR = 251
,ACCOUNTF = 3
WHERE LOADID = 625
AND PARTITIONKEY = 25
AND CATKEY = 1
AND (ACCOUNTX IS NULL OR ACCOUNTX = '')
AND (ACCOUNT LIKE '7%')
AND PERIODKEY = '2018-03-31'
2019-02-10 04:55:40,947 INFO [AIF]: Data Rows Updated by Location Mapping 'Expenses' (LIKE): 53
2019-02-10 04:55:40,949 DEBUG [AIF]:
UPDATE TDATASEG\_T
SET ACCOUNTX = '4'||SUBSTR(ACCOUNT,1+1,LENGTH(ACCOUNT)-1)
,ACCOUNTR = 248
,ACCOUNTF = 3
WHERE LOADID = 625
AND PARTITIONKEY = 25
AND CATKEY = 1
AND (ACCOUNTX IS NULL OR ACCOUNTX = '')
AND (ACCOUNT LIKE '4%')
AND PERIODKEY = '2018-03-31'
2019-02-10 04:55:40,950 INFO [AIF]: Data Rows Updated by Location Mapping 'Non Current Assets' (LIKE): 0
2019-02-10 04:55:40,952 DEBUG [AIF]:
UPDATE TDATASEG\_T
SET ACCOUNTX = '2'||SUBSTR(ACCOUNT,1+1,LENGTH(ACCOUNT)-1)
,ACCOUNTR = 246
,ACCOUNTF = 3
,AMOUNTX = -AMOUNTX
,CHANGESIGN = CASE CHANGESIGN WHEN 0 THEN 1 ELSE 0 END
WHERE LOADID = 625
AND PARTITIONKEY = 25
AND CATKEY = 1
AND (ACCOUNTX IS NULL OR ACCOUNTX = '')
AND (ACCOUNT LIKE '2%')
AND PERIODKEY = '2018-03-31'
2019-02-10 04:55:40,953 INFO [AIF]: Data Rows Updated by Location Mapping 'Non Current Liabilities' (LIKE): 0
2019-02-10 04:55:40,954 DEBUG [AIF]:
UPDATE TDATASEG\_T
SET ACCOUNTX = '6'||SUBSTR(ACCOUNT,1+1,LENGTH(ACCOUNT)-1)
,ACCOUNTR = 250
,ACCOUNTF = 3
,AMOUNTX = -AMOUNTX
,CHANGESIGN = CASE CHANGESIGN WHEN 0 THEN 1 ELSE 0 END
WHERE LOADID = 625
AND PARTITIONKEY = 25
AND CATKEY = 1
AND (ACCOUNTX IS NULL OR ACCOUNTX = '')
AND (ACCOUNT LIKE '6%')
AND PERIODKEY = '2018-03-31'
2019-02-10 04:55:40,956 INFO [AIF]: Data Rows Updated by Location Mapping 'Revenue' (LIKE): 7
2019-02-10 04:55:40,957 INFO [AIF]:
Processing Mappings for Column 'ENTITY'
2019-02-10 04:55:40,958 DEBUG [AIF]:
UPDATE TDATASEG\_T
SET (ENTITYX ,ENTITYR, AMOUNTX, CHANGESIGN, VALID\_FLAG) = (
SELECT tdm.TARGKEY
,tdm.DATAKEY
,AMOUNTX \* CASE tdm.CHANGESIGN WHEN 1 THEN -1 ELSE 1 END
,CASE tdm.CHANGESIGN
WHEN 1 THEN CASE TDATASEG\_T.CHANGESIGN
WHEN 1 THEN 0
WHEN 0 THEN 1
E