Hello Experts,
I’m facing an Error Invalid Period when trying to writeback data from
EPBCS to Oracle Fusion Cloud on the import step. I can see the period in the
fix statement of the export in the error log, but then it’s missing in the
error section where it says Error_Invalid_Period. Can you provide guidance on
why this is occurring?
My period mapping is the following. I believe it’s setup correctly.
Error Log:
2017-10-25 14:53:48,470 INFO
[AIF]: FDMEE Process: 217, Log Level: 5
2017-10-25 14:53:48,470 INFO
[AIF]: Location : Forecast
(Partitionkey:11)
2017-10-25 14:53:48,470 INFO
[AIF]: Period Name : February
2016 (Period Key:2/29/16 12:00 AM)
2017-10-25 14:53:48,470 INFO
[AIF]: Category Name: FORECAST (Category key:3)
2017-10-25 14:53:48,470 INFO
[AIF]: Rule Name :
Test_Forecast (Rule ID:20)
2017-10-25 14:53:51,294 INFO
[AIF]: FDM Version: 11.1.2.4.220
2017-10-25 14:53:51,294 INFO
[AIF]: Log File Encoding: UTF-8
2017-10-25 14:53:52,309 INFO
[AIF]: -------START IMPORT STEP-------
2017-10-25 14:53:52,579 DEBUG [AIF]: CommData.preImportData - START
2017-10-25 14:53:52,579 DEBUG [AIF]: CommData.getRuleInfo - START
2017-10-25 14:53:52,586 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 =
5
LEFT OUTER JOIN
TBHVIMPITEMERPI tiie
ON tiie.IMPGROUPKEY =
tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME AND
tiie.IMPMAPTYPE = 'ERP'
WHERE tpp.PARTITIONKEY = 11
AND
adim.BALANCE_COLUMN_NAME IS NOT NULL
AND
adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
ORDER BY
adim.BALANCE_COLUMN_NAME
2017-10-25 14:53:52,591 DEBUG [AIF]: {'TARGET_SOURCE_SYSTEM_TYPE':
u'FUSION_GL_CLOUD', 'EXPORT_TO_TARGET_FLAG': u'N', 'PLAN_NUMBER': 0L,
'TARGET_APPLICATION_SUB_TYPE': u'FUSION', 'JOURNAL_FLAG': None, 'DIMNAME_MAP':
{u'UD2': {'DIMNAME': u'UD2', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'},
u'UD1': {'DIMNAME': u'UD1', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, 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'Generic'}, u'UD5':
{'DIMNAME': u'UD5', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD11':
{'DIMNAME': u'UD11', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD8':
{'DIMNAME': u'UD8', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD10':
{'DIMNAME': u'UD10', 'TARGET_DIMENSION_CLASS_NAME': u'Currency'}, u'UD7':
{'DIMNAME': u'UD7', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD9':
{'DIMNAME': u'UD9', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'ENTITY':
{'DIMNAME': u'ENTITY', 'TARGET_DIMENSION_CLASS_NAME': u'Entity'}, u'UD15':
{'DIMNAME': u'UD15', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD14':
{'DIMNAME': u'UD14', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD13':
{'DIMNAME': u'UD13', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD12':
{'DIMNAME': u'UD12', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}}, 'CATKEY': 3L,
'SOURCE_TGT_APP_NAME': u'CorpPlan', 'APPLICATION_ID': 5L,
'SOURCE_DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'DIMNAME_LIST': [u'ENTITY',
u'UD1', u'UD10', u'UD11', u'UD12', u'UD13', u'UD14', u'UD15', u'UD2', u'UD3',
u'UD4', u'UD5', u'UD6', u'UD7', u'UD8', u'UD9'], 'TARGET_APPLICATION_TYPE':
u'ESSBASE', 'CALENDAR_ID': None, 'PARTITIONKEY': 11L, 'EXECUTION_MODE':
u'REPLACE', 'LEDGER_GROUP_CODE': u'NONE', 'PS_LEDGER': None, 'PARTVALGROUP':
u'[NONE]', 'WEB_SERVICE_URL':
u'http://us2pbcsr1703017.usdc2.oraclecloud.com:9000/aif',
'IMPORT_FROM_SOURCE_FLAG': u'Y', 'IS_INCREMENTAL_LOAD': False,
'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'SOURCE_APPLICATION_TYPE': u'HPL',
'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'KK_FLAG': u'N', 'LAST_UPDATED_BY':
u'dylan.j.leiker@accenture.com', 'SOURCE_SYSTEM_ID': 0L, 'CHECK_FLAG': u'N',
'RULE_ID': 20L, 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'INCLUDE_ZERO_BALANCE_FLAG':
u'N', 'SOURCE_APP_NAME': u'CorpPlan', 'IMPGROUPKEY': u'Forecast', 'SOURCE_SYSTEM_TYPE':
u'EPM', 'IMPGROUPFILETYPE': u'EPM_EPM', 'LEDGER_GROUP': None,
'SOURCE_ADAPTER_FLAG': u'N', 'RECALCULATE_FLAG': u'Y', 'DATA_LOAD_METHOD':
u'FUSION_GL_CLOUD', 'SOURCE_APPLICATION_ID': u'3', 'PLAN_TYPE': None,
'IMPTARGETSOURCESYSTEMID': 7L, 'TARGET_APPLICATION_NAME': u'HEARST'}
2017-10-25 14:53:52,595 DEBUG [AIF]: {u'Intercompany': {'BCN': u'UD8',
'DCN': u'Generic'}, u'Account': {'BCN': u'UD3', 'DCN': u'Generic'}, u'Company':
{'BCN': u'UD1', 'DCN': u'Generic'}, u'AccountingPeriod': {'BCN': u'UD11', 'DCN':
u'Generic'}, u'Ledger': {'BCN': u'ENTITY', 'DCN': u'Entity'}, u'Channel':
{'BCN': u'UD6', 'DCN': u'Generic'}, u'Product': {'BCN': u'UD5', 'DCN':
u'Generic'}, u'Scenario': {'BCN': u'UD15', 'DCN': u'Generic'}, u'Cost Center':
{'BCN': u'UD4', 'DCN': u'Generic'}, u'Balance Amount': {'BCN': u'UD13', 'DCN':
u'Generic'}, u'Amount Type': {'BCN': u'UD12', 'DCN': u'Generic'}, u'Currency':
{'BCN': u'UD10', 'DCN': u'Currency'}, u'Future': {'BCN': u'UD9', 'DCN':
u'Generic'}, u'LOB': {'BCN': u'UD2', 'DCN': u'Generic'}, u'Location': {'BCN':
u'UD7', 'DCN': u'Generic'}, u'Currency Type': {'BCN': u'UD14', 'DCN':
u'Generic'}}
2017-10-25 14:53:52,599 DEBUG [AIF]: {u'UD2': {'IMPFLDSOURCECOLNAME':
u'LOB'}, u'UD1': {'IMPFLDSOURCECOLNAME': u'Entity'}, u'UD4': {'IMPFLDSOURCECOLNAME':
u'Cost_Center'}, u'UD3': {'IMPFLDSOURCECOLNAME': u'Account'}, u'UD6':
{'IMPFLDSOURCECOLNAME': u'Channel'}, u'UD5': {'IMPFLDSOURCECOLNAME':
u'Product'}, u'UD8': {'IMPFLDSOURCECOLNAME': u'Partner'}, u'UD7':
{'IMPFLDSOURCECOLNAME': u'Location'}, u'SRCPERIOD': {'IMPFLDSOURCECOLNAME':
u'Period'}, u'ENTITY': {'IMPFLDSOURCECOLNAME': u'Entity'}, u'AMOUNT':
{'IMPFLDSOURCECOLNAME': u'Amount'}}
2017-10-25 14:53:52,599 DEBUG [AIF]: CommData.getRuleInfo - END
2017-10-25 14:53:52,599 DEBUG [AIF]: CommData.insertEpmPeriods - START
2017-10-25 14:53:52,601 DEBUG [AIF]: doAppPeriodMappingsExist - HEARST:
Y
2017-10-25 14:53:52,603 DEBUG [AIF]: doAppPeriodMappingsExist -
CorpPlan: Y
2017-10-25 14:53:52,603 DEBUG [AIF]: Period mapping section: DEFAULT
2017-10-25 14:53:52,604 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
,'CorpPlan\_217.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
= 'HEARST'
)
INNER JOIN
TPOVPERIODADAPTOR_FLAT_V spp
ON spp.PERIODFREQ =
pc.CATFREQ
AND spp.PERIODKEY
> tpp.PRIORPERIODKEY
AND spp.PERIODKEY
<= tpp.PERIODKEY
AND spp.INTSYSTEMKEY
= 'CorpPlan'
WHERE brl.LOADID = 217
ORDER BY tpp.PERIODKEY,
spp.PERIODKEY
2017-10-25 14:53:52,604 DEBUG [AIF]: periodSQL - periodParams:
[u'CorpPlan_217.dat', u'HEARST', u'CorpPlan', 217]
2017-10-25 14:53:52,607 DEBUG [AIF]: insertRowCount: 1
2017-10-25 14:53:52,609 DEBUG [AIF]: CommData.insertEpmPeriods - END
2017-10-25 14:53:52,610 DEBUG [AIF]: CommData.updateBalRuleLoadParams -
START
2017-10-25 14:53:52,616 DEBUG [AIF]: yearDimensionName=Years,
yearFilter="2016"
2017-10-25 14:53:52,616 DEBUG [AIF]: periodDimensionName=Period,
periodFilter="Feb"
2017-10-25 14:53:52,640 DEBUG [AIF]: CommData.updateBalRuleLoadParams -
END
2017-10-25 14:53:52,640 DEBUG [AIF]: CommData.getPovList - START
2017-10-25 14:53:52,640 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 = 'HEARST'
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 = 217
ORDER BY
brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID
2017-10-25 14:53:52,642 DEBUG [AIF]: CommData.getPovList - END
2017-10-25 14:53:52,642 DEBUG [AIF]: Comm.doScriptInit - START
2017-10-25 14:53:52,708 DEBUG [AIF]: fdmContext: {PERIODKEY=2016-02-29,
CATKEY=3, EXPORTFLAG=N, SOURCEID=0, TARGETAPPNAME=HEARST, USERLOCALE=en,
IMPORTFLAG=Y, SCRIPTSDIR=/u03/inbox/data/scripts, SOURCENAME=EPM,
PERIODNAME=February 2016,
BATCHSCRIPTDIR=/u02/user_projects/instance0/FinancialDataQuality,
LOCNAME=Forecast, USERNAME=dylan.j.leiker@accenture.com, APPROOTDIR=/u03/inbox,
EPMORACLEHOME=/u02/Oracle/Middleware/EPMSystem11R1, TARGETAPPTYPE=ESSBASE,
OUTBOXDIR=/u03/inbox/outbox, TARGETAPPDB=db, FILEDIR=inbox, APPID=5,
MULTIPERIODLOAD=N, LOADID=217, RULEID=20, IMPORTMODE=REPLACE, SOURCETYPE=EPM,
CATNAME=FORECAST, RULENAME=Test_Forecast, LOCKEY=11, EXPORTMODE=null,
INBOXDIR=/u03/inbox/inbox, EPMORACLEINSTANCEHOME=/u02/user_projects/instance0,
IMPORTFORMAT=Forecast}
2017-10-25 14:53:52,716 DEBUG [AIF]: The executeEventScript is set to:
NO
2017-10-25 14:53:52,716 DEBUG [AIF]: The AppRootFolder is set to:
/u03/inbox
2017-10-25 14:53:52,716 DEBUG [AIF]: The JavaHome is set to:
%EPM_ORACLE_HOME%/../jdk160_35
2017-10-25 14:53:52,716 DEBUG [AIF]: The OleDatabaseProvider is set to:
ORAOLEDB.ORACLE
2017-10-25 14:53:52,716 DEBUG [AIF]: Comm.doScriptInit - END
2017-10-25 14:53:52,716 DEBUG [AIF]: CommData.preImportData - END
2017-10-25 14:53:52,807 DEBUG [AIF]: CommData.extractDataFromSource -
START
2017-10-25 14:53:52,807 DEBUG [AIF]: AIFUtil.callOdiServlet - START
2017-10-25 14:53:52,828 INFO [AIF]:
EssbaseService.extractData - START
2017-10-25 14:53:52,882 DEBUG [AIF]: appId:5, appType:HPL,
mcFlag:false, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL,
textDataLoad:N, isFccsLoad:false, isJournalLoad:false
2017-10-25 14:53:52,882 DEBUG [AIF]: LOAD_METHOD:ESSFILE,
LOAD_TYPE:DATA, EXPORT_MODE:STORE_DATA, CREATE_DRILL_REGION:false,
PURGE_DATA_FILE:false, EXPORT_FILE_DELIMITER:,, BATCH_SIZE:10000
2017-10-25 14:53:52,978 INFO
[AIF]: cloudServiceType: PBCSE, Resolved user name for application access:
epm_default_cloud_admin
2017-10-25 14:53:52,978 DEBUG [AIF]: We need to connect to Essbase
server.
2017-10-25 14:53:53,362 DEBUG [AIF]: Extracting data from
CorpPlan:BalSheet...
2017-10-25 14:53:53,432 INFO
[AIF]: Extract Script (Calc): SET DataExportOptions
{
DATAEXPORTCOLFORMAT ON;
DATAEXPORTDIMHEADER ON;
DATAEXPORTDRYRUN OFF;
DataExportRelationalFile OFF;
DataExportNonExistingBlocks OFF;
DataExportLevel ALL;
DATAEXPORTCOLHEADER "Period";
DATAEXPORTOVERWRITEFILE ON;
DataExportDynamicCalc OFF;
};
FIX
(@Relative("A10000",0),@Relative("Currency",0),@Relative("E000",0),"Feb","PM1",@Relative("Version",0),"2016",@Relative("C00",0),@Relative("All
Cost_Center",0),@Relative("L000",0),@Relative("LL001",0),@Relative("All_Partner",0),@Relative("P000000",0))
DATAEXPORT "File" ","
"/u03/inbox/data/CorpPlan_BalSheet_217.txt" "#";
ENDFIX
2017-10-25 14:54:08,121 INFO
[AIF]: EssbaseService.extractData - END (true)
2017-10-25 14:54:08,136 DEBUG [AIF]: AIFUtil.callOdiServlet - END
2017-10-25 14:54:08,138 DEBUG [AIF]: CommData.extractDataFromSource -
END
2017-10-25 14:54:08,186 DEBUG [AIF]:
CommData.insertImportProcessDetails - START
2017-10-25 14:54:08,186 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,
'dylan.j.leiker@accenture.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 =
217
) q
ORDER BY
ENTITY_NAME_ORDER
2017-10-25 14:54:08,191 DEBUG [AIF]:
CommData.insertImportProcessDetails - END
2017-10-25 14:54:08,237 DEBUG [AIF]: FileData.importData - START
2017-10-25 14:54:08,237 DEBUG [AIF]: Importing data for load id: 217
2017-10-25 14:54:08,238 DEBUG [AIF]: CommData.getRuleInfo - START
2017-10-25 14:54:08,244 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 =
5
LEFT OUTER JOIN
TBHVIMPITEMERPI tiie
ON tiie.IMPGROUPKEY =
tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME AND
tiie.IMPMAPTYPE = 'ERP'
WHERE tpp.PARTITIONKEY = 11
AND adim.BALANCE\_COLUMN\_NAME
IS NOT NULL
AND
adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
ORDER BY
adim.BALANCE_COLUMN_NAME
2017-10-25 14:54:08,249 DEBUG [AIF]: {'TARGET_SOURCE_SYSTEM_TYPE':
u'FUSION_GL_CLOUD', 'EXPORT_TO_TARGET_FLAG': u'N', 'PLAN_NUMBER': 0L,
'TARGET_APPLICATION_SUB_TYPE': u'FUSION', 'JOURNAL_FLAG': None, 'DIMNAME_MAP':
{u'UD2': {'DIMNAME': u'UD2', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'},
u'UD1': {'DIMNAME': u'UD1', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, 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'Generic'}, u'UD5':
{'DIMNAME': u'UD5', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD11':
{'DIMNAME': u'UD11', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD8':
{'DIMNAME': u'UD8', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD10':
{'DIMNAME': u'UD10', 'TARGET_DIMENSION_CLASS_NAME': u'Currency'}, u'UD7':
{'DIMNAME': u'UD7', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD9':
{'DIMNAME': u'UD9', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'ENTITY':
{'DIMNAME': u'ENTITY', 'TARGET_DIMENSION_CLASS_NAME': u'Entity'}, u'UD15':
{'DIMNAME': u'UD15', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD14':
{'DIMNAME': u'UD14', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD13':
{'DIMNAME': u'UD13', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD12':
{'DIMNAME': u'UD12', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}}, 'CATKEY': 3L,
'SOURCE_TGT_APP_NAME': u'CorpPlan', 'APPLICATION_ID': 5L,
'SOURCE_DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'DIMNAME_LIST': [u'ENTITY',
u'UD1', u'UD10', u'UD11', u'UD12', u'UD13', u'UD14', u'UD15', u'UD2', u'UD3',
u'UD4', u'UD5', u'UD6', u'UD7', u'UD8', u'UD9'], 'TARGET_APPLICATION_TYPE':
u'ESSBASE', 'CALENDAR_ID': None, 'PARTITIONKEY': 11L, 'EXECUTION_MODE':
u'REPLACE', 'LEDGER_GROUP_CODE': u'NONE', 'PS_LEDGER': None, 'PARTVALGROUP':
u'[NONE]', 'WEB_SERVICE_URL':
u'http://us2pbcsr1703017.usdc2.oraclecloud.com:9000/aif',
'IMPORT_FROM_SOURCE_FLAG': u'Y', 'IS_INCREMENTAL_LOAD': False,
'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'SOURCE_APPLICATION_TYPE': u'HPL',
'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'KK_FLAG': u'N', 'LAST_UPDATED_BY':
u'dylan.j.leiker@accenture.com', 'SOURCE_SYSTEM_ID': 0L, 'CHECK_FLAG': u'N',
'RULE_ID': 20L, 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'INCLUDE_ZERO_BALANCE_FLAG':
u'N', 'SOURCE_APP_NAME': u'CorpPlan', 'IMPGROUPKEY': u'Forecast',
'SOURCE_SYSTEM_TYPE': u'EPM', 'IMPGROUPFILETYPE': u'EPM_EPM', 'LEDGER_GROUP': None,
'SOURCE_ADAPTER_FLAG': u'N', 'RECALCULATE_FLAG': u'Y', 'DATA_LOAD_METHOD':
u'FUSION_GL_CLOUD', 'SOURCE_APPLICATION_ID': u'3', 'PLAN_TYPE': None,
'IMPTARGETSOURCESYSTEMID': 7L, 'TARGET_APPLICATION_NAME': u'HEARST'}
2017-10-25 14:54:08,253 DEBUG [AIF]: {u'Intercompany': {'BCN': u'UD8',
'DCN': u'Generic'}, u'Account': {'BCN': u'UD3', 'DCN': u'Generic'}, u'Company':
{'BCN': u'UD1', 'DCN': u'Generic'}, u'AccountingPeriod': {'BCN': u'UD11',
'DCN': u'Generic'}, u'Ledger': {'BCN': u'ENTITY', 'DCN': u'Entity'},
u'Channel': {'BCN': u'UD6', 'DCN': u'Generic'}, u'Product': {'BCN': u'UD5',
'DCN': u'Generic'}, u'Scenario': {'BCN': u'UD15', 'DCN': u'Generic'}, u'Cost
Center': {'BCN': u'UD4', 'DCN': u'Generic'}, u'Balance Amount': {'BCN':
u'UD13', 'DCN': u'Generic'}, u'Amount Type': {'BCN': u'UD12', 'DCN':
u'Generic'}, u'Currency': {'BCN': u'UD10', 'DCN': u'Currency'}, u'Future':
{'BCN': u'UD9', 'DCN': u'Generic'}, u'LOB': {'BCN': u'UD2', 'DCN': u'Generic'},
u'Location': {'BCN': u'UD7', 'DCN': u'Generic'}, u'Currency Type': {'BCN':
u'UD14', 'DCN': u'Generic'}}
2017-10-25 14:54:08,257 DEBUG [AIF]: {u'UD2': {'IMPFLDSOURCECOLNAME':
u'LOB'}, u'UD1': {'IMPFLDSOURCECOLNAME': u'Entity'}, u'UD4':
{'IMPFLDSOURCECOLNAME': u'Cost_Center'}, u'UD3': {'IMPFLDSOURCECOLNAME':
u'Account'}, u'UD6': {'IMPFLDSOURCECOLNAME': u'Channel'}, u'UD5':
{'IMPFLDSOURCECOLNAME': u'Product'}, u'UD8': {'IMPFLDSOURCECOLNAME':
u'Partner'}, u'UD7': {'IMPFLDSOURCECOLNAME': u'Location'}, u'SRCPERIOD':
{'IMPFLDSOURCECOLNAME': u'Period'}, u'ENTITY': {'IMPFLDSOURCECOLNAME':
u'Entity'}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': u'Amount'}}
2017-10-25 14:54:08,257 DEBUG [AIF]: CommData.getRuleInfo - END
2017-10-25 14:54:08,257 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 = 217
AND
a.start_periodkey=b.periodkey
AND a.loadid =c.process\_id
AND br.rule\_id =
a.rule_id
AND b.INTSYSTEMKEY =
'HEARST'
2017-10-25 14:54:08,261 DEBUG [AIF]: FileData.py: Importing Text data
for load id: 217
2017-10-25 14:54:08,363 INFO
[AIF]: EPMFDM-140274:Message -
LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH:IMPGROUPFILETYPE::217;11:3:20:[NONE]:/u03/inbox/data:EPM_EPM
2017-10-25 14:54:08,370 INFO
[AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8
2017-10-25 14:54:08,370 INFO
[AIF]: EPMFDM-140274:Message - ImportTextData - Start
2017-10-25 14:54:08,370 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
2017-10-25 14:54:08,442 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=SRCPERIOD:ImpFieldText=null:StartPos=1:SourceClName=Period
2017-10-25 14:54:08,442 DEBUG [AIF]: EPMFDM-140274:Message -
ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=1:SourceClName=Amount
2017-10-25 14:54:08,442 DEBUG [AIF]: EPMFDM-140274:Message -
ImpFieldName=UD3:ImpFieldText=null:StartPos=1:SourceClName=Account
2017-10-25 14:54:08,442 DEBUG [AIF]: EPMFDM-140274:Message -
ImpFieldName=UD6:ImpFieldText=null:StartPos=1:SourceClName=Channel
2017-10-25 14:54:08,442 DEBUG [AIF]: EPMFDM-140274:Message -
ImpFieldName=UD1:ImpFieldText=null:StartPos=1:SourceClName=Entity
2017-10-25 14:54:08,442 DEBUG [AIF]: EPMFDM-140274:Message -
ImpFieldName=UD4:ImpFieldText=null:StartPos=1:SourceClName=Cost_Center
2017-10-25 14:54:08,442 DEBUG [AIF]: EPMFDM-140274:Message -
ImpFieldName=UD8:ImpFieldText=null:StartPos=1:SourceClName=Partner
2017-10-25 14:54:08,442 DEBUG [AIF]: EPMFDM-140274:Message -
ImpFieldName=UD2:ImpFieldText=null:StartPos=1:SourceClName=LOB
2017-10-25 14:54:08,442 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD7:ImpFieldText=null:StartPos=1:SourceClName=Location
2017-10-25 14:54:08,442 DEBUG [AIF]: EPMFDM-140274:Message -
ImpFieldName=UD5:ImpFieldText=null:StartPos=1:SourceClName=Product
2017-10-25 14:54:08,444 DEBUG [AIF]: EPMFDM-140274:Message -
ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=Entity
2017-10-25 14:54:08,446 INFO
[AIF]: EPMFDM-140274:Message - Initialize error maps
2017-10-25 14:54:08,446 INFO
[AIF]: EPMFDM-140274:Message - File Name CorpPlan_217.dat
periodKey2016-02-29
2017-10-25 14:54:08,446 INFO
[AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM()
HPL
2017-10-25 14:54:08,446 DEBUG [AIF]: BOM exists
2017-10-25 14:54:08,446 DEBUG [AIF]: After removing BOM
["Years","Scenario","Version","Currency","Entity","Cost_Center","LOB","Channel","Location","Partner","Product","Account","Period"]
2017-10-25 14:54:08,446 DEBUG [AIF]: EPMFDM-140274:Message - HEADER:
["Years", "Scenario", "Version",
"Currency", "Entity", "Cost_Center",
"LOB", "Channel", "Location",
"Partner", "Product", "Account",
"Period"]
2017-10-25 14:54:08,453 DEBUG [AIF]: EPMFDM-140274:Message -
ImpFieldName=CURKEY:ImpFieldText=null:StartPos=1:SourceClName=Currency
2017-10-25 14:54:08,566 INFO
[AIF]: EPMFDM-140274:Message -
PROCESS ID: 217
PARTITIONKEY: 11
IMPORT GROUP: Forecast
FILE TYPE: DELIMITED
DELIMITER: ,
SOURCE FILE: CorpPlan_217.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.
[ERROR_INVALID_PERIOD]
"FY16","PM1","Final","USD","EE5012","CC00000000","LB5006","CH000","LL0000","IC0000","PD5600771","AA17222",-1075
2017-10-25 14:54:08,837 INFO
[AIF]: EPMFDM-140274:Message - Rows Loaded: 0
Rows Rejected: 3762
2017-10-25 14:54:08,837 DEBUG [AIF]: EPMFDM-140274:Message - Script-
archiveDataFile- Start
2017-10-25 14:54:08,840 INFO
[AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy
2017-10-25 14:54:08,840 INFO
[AIF]: EPMFDM-140274:Message - Start archiving file:
2017-10-25 14:54:08,840 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId:
21720160229
2017-10-25 14:54:08,840 DEBUG [AIF]: EPMFDM-140274:Message - Archive-
SourceFileName: CorpPlan_217
Extension: dat
2017-10-25 14:54:08,842 INFO
[AIF]: EPMFDM-140274:Message - Archive file name: 21720160229.dat
2017-10-25 14:54:08,851 INFO
[AIF]: EPMFDM-140274:Message - Deleting the source file:
CorpPlan_217.dat
2017-10-25 14:54:08,851 INFO
[AIF]: EPMFDM-140274:Message - File not deleted:
/u03/inbox/data/CorpPlan_217.dat
2017-10-25 14:54:08,853 DEBUG [AIF]: EPMFDM-140274:Message -
ArchiveDocKey:CorpPlan_217-dylan.j.leiker@accenture.com-20171025_145408-1
2017-10-25 14:54:08,858 DEBUG [AIF]: EPMFDM-140274:Message - Script-
archiveDataFile- End
2017-10-25 14:54:08,861 DEBUG [AIF]: EPMFDM-140274:Message - Script-
updateMultiPeriodProcessDetail- Start
2017-10-25 14:54:08,863 WARN
[AIF]: 0 records imported for the period:February 2016
2017-10-25 14:54:08,867 DEBUG [AIF]: EPMFDM-140274:Message - Script-
updateMultiPeriodProcessDetail- End
2017-10-25 14:54:08,867 DEBUG [AIF]: EPMFDM-140274:Message - Script-
archiveDataFile- Start
2017-10-25 14:54:08,869 INFO
[AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy
2017-10-25 14:54:08,869 INFO
[AIF]: EPMFDM-140274:Message - Start archiving file:
2017-10-25 14:54:08,869 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId:
21720160229
2017-10-25 14:54:08,869 DEBUG [AIF]: EPMFDM-140274:Message - Archive-
SourceFileName: CorpPlan_217
Extension: dat
2017-10-25 14:54:08,871 INFO
[AIF]: EPMFDM-140274:Message - Archive file name: 21720160229.dat
2017-10-25 14:54:08,879 INFO
[AIF]: EPMFDM-140274:Message - Deleting the source file: CorpPlan_217.dat
2017-10-25 14:54:08,879 INFO
[AIF]: EPMFDM-140274:Message - File not deleted:
/u03/inbox/data/CorpPlan_217.dat
2017-10-25 14:54:08,881 DEBUG [AIF]: EPMFDM-140274:Message -
ArchiveDocKey:CorpPlan_217-dylan.j.leiker@accenture.com-20171025_145408-2
2017-10-25 14:54:08,886 DEBUG [AIF]: EPMFDM-140274:Message - Script-
archiveDataFile- End
2017-10-25 14:54:08,889 INFO
[AIF]: EPMFDM-140274:Message - ImportTextData - End
2017-10-25 14:54:08,889 INFO
[AIF]: EPMFDM-140274:Message - Total time taken for the import in ms =
519
2017-10-25 14:54:08,894 DEBUG [AIF]: FileData.importData - END
2017-10-25 14:54:09,035 DEBUG [AIF]: CommData.postImportData - START
2017-10-25 14:54:09,035 DEBUG [AIF]: CommData.updateTDATASEG_T - START
2017-10-25 14:54:09,035 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 = 217
AND en.process\_id = pp.process\_id
AND pp.IMP\_ENTITY\_NAME
= en.file_entity_name
order by
en.entity_name_order
2017-10-25 14:54:09,037 INFO
[AIF]:
Import Data from Source for Period 'February 2016'
2017-10-25 14:54:09,037 DEBUG [AIF]: CommData.updateWorkflow - START
2017-10-25 14:54:09,038 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 = 11
AND tlp.CATKEY = 3 AND tlp.PERIODKEY = '2016-02-29' AND tlp.RULE_ID = 20 AND
tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS
2017-10-25 14:54:09,040 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=11 AND
CATKEY=3 AND PERIODKEY='2016-02-29' AND RULE_ID=20
2017-10-25 14:54:09,045 DEBUG [AIF]: CommData.updateWorkflow - END
2017-10-25 14:54:09,045 DEBUG [AIF]:
SELECT
adim.BALANCE_COLUMN_NAME DIMNAME, dim.TARGET_DIMENSION_CLASS_NAME
FROM TPOVPARTITION
tpp
INNER JOIN
AIF_TARGET_APPL_DIMENSIONS adim
ON
adim.APPLICATION_ID = tpp.PARTTARGETAPPLICATIONID AND adim.BALANCE_COLUMN_NAME
IS NOT NULL
INNER JOIN AIF\_DIMENSIONS
dim
ON dim.DIMENSION\_ID
= adim.DIMENSION_ID
WHERE
tpp.PARTITIONKEY = 11
AND
dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
ORDER BY
adim.BALANCE_COLUMN_NAME
2017-10-25 14:54:09,050 DEBUG [AIF]:
UPDATE TDATASEG\_T
SET AMOUNTX = AMOUNT,
DATAX = NULL
,ENTITYX = NULL
,UD1X = NULL
,UD10X = NULL
,UD11X = NULL
,UD12X = NULL
,UD13X = NULL
,UD14X = NULL
,UD15X = NULL
,UD2X = NULL
,UD3X = NULL
,UD4X = NULL
,UD5X = NULL
,UD6X = NULL
,UD7X = NULL
,UD8X = NULL
,UD9X = NULL
WHERE
TDATASEG_T.LOADID = 217 AND TDATASEG_T.PARTITIONKEY = 11 AND TDATASEG_T.CATKEY
= 3 AND TDATASEG_T.PERIODKEY = '2016-02-29'
2017-10-25 14:54:09,053 INFO
[AIF]: Generic Data Rows
Imported from Source: 0
2017-10-25 14:54:09,055 INFO
[AIF]: Total Data Rows Imported from Source: 0
2017-10-25 14:54:09,055 DEBUG [AIF]: CommData.updateTDATASEG_T - END
2017-10-25 14:54:09,055 DEBUG [AIF]: CommData.postImportData - END
2017-10-25 14:54:09,102 DEBUG [AIF]: LogicGroup.createLogicAccounts -
START
2017-10-25 14:54:09,102 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START
2017-10-25 14:54:09,102 DEBUG [AIF]:
select
part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE
from AIF\_PROCESSES prs,
TPOVPARTITION part,TBHVLOGICGROUP lgrp
where prs.PROCESS\_ID=217
and prs.PARTITIONKEY=part.PARTITIONKEY
and
part.PARTLOGICGROUP=lgrp.CALCGROUPKEY
2017-10-25 14:54:09,104 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END
2017-10-25 14:54:09,106 DEBUG [AIF]: LogicGroup.createLogicAccounts -
END
2017-10-25 14:54:09,152 DEBUG [AIF]: CommData.mapData - START
2017-10-25 14:54:09,152 DEBUG [AIF]: CommData.insertTransProcessDetails
- START
2017-10-25 14:54:09,153 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, 'dylan.j.leiker@accenture.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 =
217
AND PRIOR\_PERIOD\_FLAG
= 'N'
GROUP BY PROCESS\_ID,
TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME
) q
ORDER BY
ENTITY_NAME_ORDER
2017-10-25 14:54:09,157 DEBUG [AIF]: CommData.insertTransProcessDetails
- END
2017-10-25 14:54:09,157 DEBUG [AIF]:
DELETE FROM TDATAMAP\_T
WHERE LOADID \< 217
AND EXISTS ( SELECT 1
FROM AIF_PROCESSES p WHERE p.RULE_ID = 20 AND p.PROCESS_ID = TDATAMAP_T.LOADID
)
2017-10-25 14:54:09,161 DEBUG [AIF]:
DELETE FROM TDATASEG\_T
WHERE LOADID \< 217
AND EXISTS ( SELECT 1
FROM AIF_PROCESSES p WHERE p.RULE_ID = 20 AND p.PROCESS_ID = TDATASEG_T.LOADID
)
2017-10-25 14:54:09,165 DEBUG [AIF]:
DELETE FROM
AIF_PROCESS_PERIODS
WHERE PROCESS\_ID \< 217
AND EXISTS ( SELECT 1
FROM AIF_PROCESSES p WHERE p.RULE_ID = 20 AND p.PROCESS_ID =
AIF_PROCESS_PERIODS.PROCESS_ID )
2017-10-25 14:54:09,170 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START
2017-10-25 14:54:09,170 DEBUG [AIF]: CommData.getMapPartitionKeyandName
- START
2017-10-25 14:54:09,170 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 =
11
2017-10-25 14:54:09,172 DEBUG [AIF]: CommData.getMapPartitionKeyandName
- END
2017-10-25 14:54:09,172 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 217, DATAKEY, 11
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 = 11
AND ( RULE\_ID IS NULL OR
RULE_ID = 20 )
2017-10-25 14:54:09,174 DEBUG [AIF]: Number of Rows inserted into
TDATAMAP_T: 0
2017-10-25 14:54:09,176 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW
- START
2017-10-25 14:54:09,176 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 = 217
AND atad.APPLICATION\_ID
= 5
AND tdm.PARTITIONKEY =
11
AND tdm.TDATAMAPTYPE =
'ERP'
AND (tdm.RULE\_ID IS
NULL OR tdm.RULE_ID = 20)
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 = 217
AND atad.APPLICATION\_ID
= 5
AND tdm.PARTITIONKEY =
11
AND tdm.TDATAMAPTYPE =
'ERP'
AND (tdm.RULE\_ID IS
NULL OR tdm.RULE_ID = 20)
AND tdm.WHERECLAUSETYPE
IN ('BETWEEN','IN','MULTIDIM','LIKE')
) q
ORDER BY CALC\_SEQ,
DIMNAME, SEQUENCE, RULE_ID, SYSTEM_GENERATED_FLAG, SRCKEY
2017-10-25 14:54:09,179 INFO
[AIF]:
Map Data for Period 'February 2016'
2017-10-25 14:54:09,179 DEBUG [AIF]: Comm.updateProcessDetail - START
2017-10-25 14:54:09,179 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 ('dylan.j.leiker@accenture.com' IS NULL) THEN LAST_UPDATED_BY ELSE
'dylan.j.leiker@accenture.com' END
,LAST\_UPDATE\_DATE =
CURRENT_TIMESTAMP
WHERE PROCESS\_ID = 217 AND
ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'February 2016'
2017-10-25 14:54:09,183 DEBUG [AIF]: Comm.updateProcessDetail - END
2017-10-25 14:54:09,183 DEBUG [AIF]:
SELECT COUNT(\*) ROW\_COUNT
FROM TDATASEG\_T
WHERE LOADID = 217
AND (PARTITIONKEY = 11 AND
CATKEY = 3 AND PERIODKEY = '2016-02-29' AND RULE_ID = 20 AND VALID_FLAG = 'Y')
2017-10-25 14:54:09,185 WARN
[AIF]: Warning: No records exist for Period 'February 2016'
2017-10-25 14:54:09,186 DEBUG [AIF]: Comm.updateProcessDetail - START
2017-10-25 14:54:09,186 DEBUG [AIF]:
UPDATE AIF\_PROCESS\_DETAILS
SET STATUS = 'WARNING'
,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 ('dylan.j.leiker@accenture.com' IS NULL) THEN LAST_UPDATED_BY ELSE
'dylan.j.leiker@accenture.com' END
,LAST\_UPDATE\_DATE =
CURRENT_TIMESTAMP
WHERE PROCESS\_ID = 217 AND
ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'February 2016'
2017-10-25 14:54:09,190 DEBUG [AIF]: Comm.updateProcessDetail - END
2017-10-25 14:54:09,190 DEBUG [AIF]: CommData.updateWorkflow - START
2017-10-25 14:54:09,190 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET
PROCESSENDTIME=CURRENT_TIMESTAMP
,PROCESSSTATUS=2,PROCESSIMP=0,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0
,PROCESSIMPNOTE='AIF_WF_IMP_IMPORT_ERR'
WHERE PARTITIONKEY=11 AND
CATKEY=3 AND PERIODKEY='2016-02-29' AND RULE_ID=20
2017-10-25 14:54:09,195 DEBUG [AIF]: CommData.updateWorkflow - END
2017-10-25 14:54:09,195 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW
- END
2017-10-25 14:54:09,195 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG -
START
2017-10-25 14:54:09,195 INFO
[AIF]:
Stage Data for Period 'February 2016'
2017-10-25 14:54:09,195 DEBUG [AIF]:
DELETE FROM TDATAMAPSEG
WHERE PARTITIONKEY = 11
AND CATKEY = 3
AND PERIODKEY =
'2016-02-29'
2017-10-25 14:54:09,197 INFO
[AIF]: Number of Rows deleted from TDATAMAPSEG: 0
2017-10-25 14:54:09,197 DEBUG [AIF]:
INSERT INTO TDATAMAPSEG (
DATAKEY,
PARTITIONKEY, CATKEY, PERIODKEY, DIMNAME, SRCKEY, SRCDESC, TARGKEY,
WHERECLAUSETYPE,
WHERECLAUSEVALUE,
CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG
)
SELECT DATAKEY,
PARTITIONKEY, 3, '2016-02-29', DIMNAME, SRCKEY, SRCDESC, TARGKEY,
WHERECLAUSETYPE,
WHERECLAUSEVALUE,
CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG
FROM TDATAMAP\_T
WHERE LOADID = 217
2017-10-25 14:54:09,199 INFO
[AIF]: Number of Rows inserted into TDATAMAPSEG: 0
2017-10-25 14:54:09,200 DEBUG [AIF]:
DELETE FROM TDATAMAP\_T
WHERE LOADID = 217
2017-10-25 14:54:09,201 INFO
[AIF]: Number of Rows deleted from TDATAMAP_T: 0
2017-10-25 14:54:09,202 DEBUG [AIF]:
DELETE FROM TDATASEG
WHERE LOADID \< 217
AND PARTITIONKEY = 11 AND CATKEY = 3 AND RULE_ID = 20 AND PERIODKEY =
'2016-02-29'
2017-10-25 14:54:09,204 INFO
[AIF]: Number of Rows deleted from TDATASEG: 0
2017-10-25 14:54:09,204 DEBUG [AIF]:
DELETE FROM TDATAMEMOITEMS
WHERE PARTITIONKEY =
11 AND PERIODKEY = '2016-02-29' AND CATKEY = 3 AND RULE_ID = 20
AND NOT EXISTS
(SELECT 1 FROM TDATASEG WHERE TDATASEG.DATAKEY = TDATAMEMOITEMS.DATAKEY)
2017-10-25 14:54:09,206 INFO
[AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0
2017-10-25 14:54:09,206 DEBUG [AIF]:
DELETE FROM
TDATAARCHIVE
WHERE PARTITIONKEY =
11 AND PERIODKEY = '2016-02-29' AND CATKEY = 3 AND RULE_ID = 20
AND ARCHIVEPROCTYPEID
= 1
AND NOT EXISTS (
SELECT 1
FROM
TDATAMEMOITEMS
WHERE TDATAMEMOITEMS.MEMOITEMSD1 = TDATAARCHIVE.ARCHIVEID
OR
TDATAMEMOITEMS.MEMOITEMSD2 = TDATAARCHIVE.ARCHIVEID
OR
TDATAMEMOITEMS.MEMOITEMSD3 = TDATAARCHIVE.ARCHIVEID
OR
TDATAMEMOITEMS.MEMOITEMSD4 = TDATAARCHIVE.ARCHIVEID
OR
TDATAMEMOITEMS.MEMOITEMSD5 = TDATAARCHIVE.ARCHIVEID
OR
TDATAMEMOITEMS.MEMOITEMSD6 = TDATAARCHIVE.ARCHIVEID
OR
TDATAMEMOITEMS.MEMOITEMSD7 = TDATAARCHIVE.ARCHIVEID
OR
TDATAMEMOITEMS.MEMOITEMSD8 = TDATAARCHIVE.ARCHIVEID
OR
TDATAMEMOITEMS.MEMOITEMSD9 = TDATAARCHIVE.ARCHIVEID
OR
TDATAMEMOITEMS.MEMOITEMSD10 = TDATAARCHIVE.ARCHIVEID )
2017-10-25 14:54:09,208 INFO
[AIF]: Number of Rows deleted from TDATAARCHIVE: 0
2017-10-25 14:54:09,209 DEBUG [AIF]:
INSERT INTO TDATASEG (
DATAKEY,
PARTITIONKEY, CATKEY, PERIODKEY,CURKEY, DATAVIEW, CALCACCTTYPE, CHANGESIGN,
JOURNALID
,AMOUNT, AMOUNTX,
AMOUNT_PTD, AMOUNT_YTD, DATA, DATAX, DESC1, DESC2
,ACCOUNT, ACCOUNTX,
ACCOUNTR, ACCOUNTF, ENTITY, ENTITYX, ENTITYR, ENTITYF, ICP, ICPX, ICPR, ICPF
,UD1, UD1X, UD1R,
UD1F, UD2, UD2X, UD2R, UD2F, UD3, UD3X, UD3R, UD3F, UD4, UD4X, UD4R, UD4F
,UD5, UD5X, UD5R, UD5F, UD6, UD6X,
UD6R, UD6F, UD7, UD7X, UD7R, UD7F, UD8, UD8X, UD8R, UD8F
,UD9, UD9X, UD9R,
UD9F, UD10, UD10X, UD10R, UD10F, UD11, UD11X, UD11R, UD11F, UD12, UD12X, UD12R,
UD12F
,UD13, UD13X, UD13R,
UD13F, UD14, UD14X, UD14R, UD14F, UD15, UD15X, UD15R, UD15F, UD16, UD16X,
UD16R, UD16F
,UD17, UD17X, UD17R,
UD17F, UD18, UD18X, UD18R, UD18F, UD19, UD19X, UD19R, UD19F, UD20, UD20X,
UD20R, UD20F
,ATTR1, ATTR2, ATTR3,
ATTR4, ATTR5, ATTR6, ATTR7, ATTR8, ATTR9, ATTR10, ATTR11, ATTR12, ATTR13,
ATTR14
,ARCHIVEID,
HASMEMOITEM, STATICDATAKEY, LOADID, RULE_ID,
CODE_COMBINATION_ID,STAT_BALANCE_FLAG, VALID_FLAG )
SELECT
DATAKEY,
PARTITIONKEY, CATKEY, PERIODKEY,CURKEY, DATAVIEW, CALCACCTTYPE, CHANGESIGN,
JOURNALID
,AMOUNT, AMOUNTX,
AMOUNT_PTD, AMOUNT_YTD, DATA, DATAX, DESC1, DESC2
,ACCOUNT, ACCOUNTX,
ACCOUNTR, ACCOUNTF, ENTITY, ENTITYX, ENTITYR, ENTITYF, ICP, ICPX, ICPR, ICPF
,UD1, UD1X, UD1R,
UD1F, UD2, UD2X, UD2R, UD2F, UD3, UD3X, UD3R, UD3F, UD4, UD4X, UD4R, UD4F
,UD5, UD5X, UD5R,
UD5F, UD6, UD6X, UD6R, UD6F, UD7, UD7X, UD7R, UD7F, UD8, UD8X, UD8R, UD8F
,UD9, UD9X, UD9R,
UD9F, UD10, UD10X, UD10R, UD10F, UD11, UD11X, UD11R, UD11F, UD12, UD12X, UD12R,
UD12F
,UD13, UD13X, UD13R,
UD13F, UD14, UD14X, UD14R, UD14F, UD15, UD15X, UD15R, UD15F, UD16, UD16X,
UD16R, UD16F
,UD17, UD17X, UD17R,
UD17F, UD18, UD18X, UD18R, UD18F, UD19, UD19X, UD19R, UD19F, UD20, UD20X,
UD20R, UD20F
,ATTR1, ATTR2, ATTR3,
ATTR4, ATTR5, ATTR6, ATTR7, ATTR8, ATTR9, ATTR10, ATTR11, ATTR12, ATTR13,
ATTR14
,ARCHIVEID,
HASMEMOITEM, STATICDATAKEY, LOADID, RULE_ID,
CODE_COMBINATION_ID,STAT_BALANCE_FLAG, VALID_FLAG
FROM TDATASEG\_T
WHERE LOADID = 217 AND
PARTITIONKEY = 11 AND CATKEY = 3 AND PERIODKEY = '2016-02-29'
2017-10-25 14:54:09,211 INFO
[AIF]: Number of Rows inserted into TDATASEG: 0
2017-10-25 14:54:09,211 DEBUG [AIF]:
DELETE FROM TDATASEG\_T
WHERE LOADID = 217 AND
PARTITIONKEY = 11 AND CATKEY = 3 AND PERIODKEY = '2016-02-29'
2017-10-25 14:54:09,213 INFO
[AIF]: Number of Rows deleted from TDATASEG_T: 0
2017-10-25 14:54:09,213 DEBUG [AIF]: CommData.updateWorkflow - START
2017-10-25 14:54:09,213 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET
PROCESSENDTIME=CURRENT_TIMESTAMP
,PROCESSSTATUS=2,PROCESSIMP=0,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0
,PROCESSIMPNOTE='Import Error'
WHERE PARTITIONKEY=11 AND
CATKEY=3 AND PERIODKEY='2016-02-29' AND RULE_ID=20
2017-10-25 14:54:09,218 DEBUG [AIF]: CommData.updateWorkflow - END
2017-10-25 14:54:09,219 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG -
END
2017-10-25 14:54:09,219 DEBUG [AIF]: CommData.mapData - END
2017-10-25 14:54:09,263 INFO
[AIF]: -------END IMPORT STEP-------
2017-10-25 14:54:09,305 INFO
[AIF]: -------START VALIDATE STEP-------
2017-10-25 14:54:09,351 DEBUG [AIF]: CommData.validateData - START
2017-10-25 14:54:09,351 DEBUG [AIF]: CommMap.validateData - START
2017-10-25 14:54:09,354 WARN
[AIF]: Warning: The Import step has not been completed for period
February 2016
2017-10-25 14:54:09,354 DEBUG [AIF]: CommMap.validateData - END
2017-10-25 14:54:09,356 WARN
[AIF]: Warning: The Import step has not been completed for period
February 2016
2017-10-25 14:54:09,356 DEBUG [AIF]: CommData.validateData - END
2017-10-25 14:54:09,399 INFO
[AIF]: -------END VALIDATE STEP-------
2017-10-25 14:54:09,724 DEBUG [AIF]: Comm.finalizeProcess - START
2017-10-25 14:54:09,724 DEBUG [AIF]: CommData.updateRuleStatus - START
2017-10-25 14:54:09,725 DEBUG [AIF]:
UPDATE AIF\_BALANCE\_RULES
SET STATUS = CASE 'SUCCESS'
WHEN 'SUCCESS' THEN
CASE ( SELECT COUNT(\*)
FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 217 AND pd.STATUS IN
('FAILED','WARNING') )
WHEN 0 THEN 'SUCCESS'
ELSE ( SELECT
MIN(pd.STATUS) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 217 AND
pd.STATUS IN ('FAILED','WARNING') ) END
ELSE 'SUCCESS' END
WHERE RULE\_ID = 20
2017-10-25 14:54:09,729 DEBUG [AIF]: CommData.updateRuleStatus - END
2017-10-25 14:54:09,729 DEBUG [AIF]: Comm.updateProcess - START
2017-10-25 14:54:09,733 DEBUG [AIF]: Comm.updateProcess - END
2017-10-25 14:54:09,736 DEBUG [AIF]: The fdmAPI connection has been
closed.
2017-10-25 14:54:09,736 INFO
[AIF]: FDMEE Process End, Process ID: 217