FDMEE - Import Fail (Root Folder)

AbanoubZaki · Oct 22, 2019 11:28AM

Hello All,

I have an issue while the import process in fdmee, and the below is the log file:

2019-10-22 17:02:29,474 DEBUG [AIF]: The EpmOracleHome is set to: C:\Oracle\Middleware\EPMSystem11R1

2019-10-22 17:02:29,474 DEBUG [AIF]: The EpmOracleInstance is set to: C:\Oracle\Middleware\user_projects\Fdmee1

2019-10-22 17:02:29,474 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

2019-10-22 17:02:29,474 DEBUG [AIF]: The executeEventScript is set to: YES

2019-10-22 17:02:29,474 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

2019-10-22 17:02:29,474 DEBUG [AIF]: The AppRootFolder is set to: Home

2019-10-22 17:02:29,474 DEBUG [AIF]: Comm.doScriptInit - END

2019-10-22 17:02:29,474 DEBUG [AIF]: Comm.executeScript - START

2019-10-22 17:02:29,474 DEBUG [AIF]: The following script does not exist: Home/data/scripts/event/AftImport.py

2019-10-22 17:02:29,490 DEBUG [AIF]: Comm.executeVBScript - START

2019-10-22 17:02:29,490 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

2019-10-22 17:02:29,490 DEBUG [AIF]: The following script does not exist: Home\data\scripts\event\AftImport.vbs

2019-10-22 17:02:29,490 DEBUG [AIF]: Comm.executeVBScript - END

2019-10-22 17:02:29,490 DEBUG [AIF]: Comm.executeScript - END

2019-10-22 17:02:29,521 FATAL [AIF]: Error in COMM Post Import Data

--------------------------------------------------------------------------------------------------

Any advice?

JohnGoodwin · Oct 23, 2019 4:56AM

There does look like there is something wrong with the root folder because the contexts are incorrect

INBOXDIR=Home\inbox

APPROOTDIR=Home

SCRIPTSDIR=Home\data\scripts

FILEDIR=racle\Middleware\user_projects\domains\EPMSystem\Home\inbox

Cheers

John

JohnGoodwin · Oct 22, 2019 12:55PM

You need to find out more details on why the process failed. What you have provided does not give much to go on.

If there is nothing of use in the process log, download the ODI log from process details. Alternatively go into ODI studio or console and look at the logs for errors.

Cheers

John

AbanoubZaki · Oct 22, 2019 3:50PM

Hello John,

But I am not using ODI !!

JohnGoodwin · Oct 23, 2019 3:35AM

What do you mean you are not using it? FDMEE is built on top of ODI.

You can download the ODI session log from process details

And I said you can also view the logs in ODI studio or console.

AbanoubZaki · Oct 23, 2019 3:41AM

Hello John,

please find the below:

2019-10-22 17:02:22,848 INFO [AIF]: FDMEE Process Start, Process ID: 29

2019-10-22 17:02:22,848 INFO [AIF]: FDMEE Logging Level: 5

2019-10-22 17:02:22,848 INFO [AIF]: FDMEE Log File: Home\outbox\logs\FPnR_29.log

2019-10-22 17:02:22,848 INFO [AIF]: User:admin

2019-10-22 17:02:22,848 INFO [AIF]: Location:DMG_TB (Partitionkey:3)

2019-10-22 17:02:22,848 INFO [AIF]: Period Name:Dec-18 (Period Key:12/31/18 12:00 AM)

2019-10-22 17:02:22,848 INFO [AIF]: Category Name:Actual (Category key:5)

2019-10-22 17:02:22,848 INFO [AIF]: Rule Name:DMG_TB (Rule ID:4)

2019-10-22 17:02:24,845 INFO [AIF]: FDM Version: 11.1.2.4.000

2019-10-22 17:02:24,845 INFO [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

[Oracle JRockit(R) (Oracle Corporation)]

2019-10-22 17:02:24,845 INFO [AIF]: Java Platform: java1.6.0_201

2019-10-22 17:02:24,845 INFO [AIF]: Log File Encoding: UTF-8

2019-10-22 17:02:26,220 INFO [AIF]: -------START IMPORT STEP-------

2019-10-22 17:02:26,282 DEBUG [AIF]: CommData.preImportData - START

2019-10-22 17:02:26,282 DEBUG [AIF]: CommData.getRuleInfo - START

2019-10-22 17:02:26,298 DEBUG [AIF]:

SELECT brl.RULE_ID, br.RULE_NAME, brl.PARTITIONKEY, brl.CATKEY, part.PARTVALGROUP, br.SOURCE_SYSTEM_ID, ss.SOURCE_SYSTEM_TYPE

,CASE

WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'EBS%' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'PS%' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FUSION%' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE = 'FILE' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'N'

ELSE 'Y'

END SOURCE_ADAPTER_FLAG

,app.APPLICATION_ID, app.TARGET_APPLICATION_NAME, app.TARGET_APPLICATION_TYPE, app.DATA_LOAD_METHOD, brl.PLAN_TYPE

,CASE brl.PLAN_TYPE

WHEN 'PLAN1' THEN 1 WHEN 'PLAN2' THEN 2 WHEN 'PLAN3' THEN 3 WHEN 'PLAN4' THEN 4 WHEN 'PLAN5' THEN 5 WHEN 'PLAN6' THEN 6 ELSE 0

END PLAN_NUMBER

,br.INCL_ZERO_BALANCE_FLAG, br.PERIOD_MAPPING_TYPE, br.INCLUDE_ADJ_PERIODS_FLAG, br.BALANCE_TYPE ACTUAL_FLAG

,br.AMOUNT_TYPE, br.BALANCE_SELECTION, br.BALANCE_METHOD_CODE

,COALESCE(br.SIGNAGE_METHOD, 'ABSOLUTE') SIGNAGE_METHOD

,br.CURRENCY_CODE, br.BAL_SEG_VALUE_OPTION_CODE, brl.EXECUTION_MODE

,COALESCE(brl.IMPORT_FROM_SOURCE_FLAG, 'Y') IMPORT_FROM_SOURCE_FLAG

,COALESCE(brl.RECALCULATE_FLAG, 'N') RECALCULATE_FLAG

,COALESCE(brl.EXPORT_TO_TARGET_FLAG, 'N') EXPORT_TO_TARGET_FLAG

,COALESCE(brl.CHECK_FLAG, 'N') CHECK_FLAG

,CASE

WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'NONE'

WHEN (br.LEDGER_GROUP_ID IS NOT NULL) THEN 'MULTI'

WHEN (br.SOURCE_LEDGER_ID IS NOT NULL) THEN 'SINGLE'

ELSE 'NONE'

END LEDGER_GROUP_CODE

,COALESCE(br.BALANCE_AMOUNT_BS, 'YTD') BALANCE_AMOUNT_BS

,COALESCE(br.BALANCE_AMOUNT_IS, 'PERIODIC') BALANCE_AMOUNT_IS

,br.LEDGER_GROUP

,(SELECT brd.DETAIL_CODE FROM AIF_BAL_RULE_DETAILS brd WHERE brd.RULE_ID = br.RULE_ID AND brd.DETAIL_TYPE = 'LEDGER') PS_LEDGER

,CASE lg.LEDGER_TEMPLATE WHEN 'COMMITMENT' THEN 'Y' ELSE 'N' END KK_FLAG

,p.LAST_UPDATED_BY, p.AIF_WEB_SERVICE_URL WEB_SERVICE_URL, p.EPM_ORACLE_INSTANCE

,brl.JOURNAL_FLAG, br.MULTI_PERIOD_FILE_FLAG, br.IMPGROUPKEY, imp.IMPSOURCELEDGERID

,imp.IMPGROUPFILETYPE, imp.IMPTARGETSOURCESYSTEMID, imp.IMPSOURCECOAID, part.PARTTARGETAPPLICATIONID

FROM AIF_PROCESSES p

INNER JOIN AIF_BAL_RULE_LOADS brl

ON brl.LOADID = p.PROCESS_ID

INNER JOIN AIF_BALANCE_RULES br

ON br.RULE_ID = brl.RULE_ID

INNER JOIN AIF_SOURCE_SYSTEMS ss

ON ss.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID

INNER JOIN AIF_TARGET_APPLICATIONS app

ON app.APPLICATION_ID = brl.APPLICATION_ID

INNER JOIN TPOVPARTITION part

ON part.PARTITIONKEY = br.PARTITIONKEY

INNER JOIN TBHVIMPGROUP imp

ON imp.IMPGROUPKEY = part.PARTIMPGROUP

LEFT OUTER JOIN AIF_COA_LEDGERS l

ON l.SOURCE_SYSTEM_ID = p.SOURCE_SYSTEM_ID

AND l.SOURCE_LEDGER_ID = COALESCE(br.SOURCE_LEDGER_ID,imp.IMPSOURCELEDGERID)

LEFT OUTER JOIN AIF_PS_SET_CNTRL_REC_STG scr

ON scr.SOURCE_SYSTEM_ID = l.SOURCE_SYSTEM_ID

AND scr.SETCNTRLVALUE = l.SOURCE_LEDGER_NAME

AND scr.RECNAME = 'LED_GRP_TBL'

LEFT OUTER JOIN AIF_PS_LED_GRP_TBL_STG lg

ON lg.SOURCE_SYSTEM_ID = scr.SOURCE_SYSTEM_ID

AND lg.SETID = scr.SETID

AND lg.LEDGER_GROUP = br.LEDGER_GROUP

WHERE p.PROCESS_ID = 29

2019-10-22 17:02:26,298 DEBUG [AIF]:

SELECT adim.BALANCE_COLUMN_NAME DIMNAME

,adim.DIMENSION_ID

,dim.TARGET_DIMENSION_CLASS_NAME

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID2) COA_SEGMENT_NAME2

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID3) COA_SEGMENT_NAME3

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID4) COA_SEGMENT_NAME4

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID5) COA_SEGMENT_NAME5

,(SELECT DISTINCT CASE mdd.ORPHAN_OPTION_CODE

WHEN 'CHILD' THEN 'N'

WHEN 'ROOT' THEN 'N'

ELSE 'Y'

END DIMENSION_FILTER_FLAG

FROM AIF_MAP_DIM_DETAILS_V mdd

,AIF_MAPPING_RULES mr

WHERE mr.PARTITIONKEY = tpp.PARTITIONKEY

AND mdd.RULE_ID = mr.RULE_ID

AND mdd.DIMENSION_ID = adim.DIMENSION_ID

) DIMENSION_FILTER_FLAG

,tiie.IMPCONCATCHAR

FROM TPOVPARTITION tpp

INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

ON adim.APPLICATION_ID = 8

INNER JOIN AIF_DIMENSIONS dim

ON dim.DIMENSION_ID = adim.DIMENSION_ID

LEFT OUTER JOIN TBHVIMPITEMERPI tiie

ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP

AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME

AND tiie.IMPMAPTYPE = 'ERP'

WHERE tpp.PARTITIONKEY = 3

AND adim.BALANCE_COLUMN_NAME IS NOT NULL

AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

AND (adim.VALID_FOR_PLAN1 = 1 OR dim.TARGET_DIMENSION_CLASS_NAME = 'LOOKUP')

ORDER BY adim.BALANCE_COLUMN_NAME

2019-10-22 17:02:26,298 DEBUG [AIF]: {'APPLICATION_ID': 8L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': u'PLAN1', 'RULE_NAME': u'DMG_TB', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'C:\\Oracle\\Middleware\\user_projects\\Fdmee1', 'CATKEY': 5L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'FPnR', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'DMG_TB', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5', u'UD6'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD6': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD6', 'DIMENSION_ID': 65L}, u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 58L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 66L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 57L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 64L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 62L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 60L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Version', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 63L}}, 'TARGET_APPLICATION_TYPE': u'HPL', 'PARTITIONKEY': 3L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 1L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 4L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://DMGHYPEPMTEST.Daralmimar.local:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 8L, 'IMPTARGETSOURCESYSTEMID': 0L}

2019-10-22 17:02:26,298 DEBUG [AIF]: CommData.getRuleInfo - END

2019-10-22 17:02:26,298 DEBUG [AIF]: CommData.insertFilePeriods - START

2019-10-22 17:02:26,314 DEBUG [AIF]: doAppPeriodMappingsExist - FPnR: N

2019-10-22 17:02:26,314 DEBUG [AIF]:

select PERIODKEY,PERIODDESC,YEARTARGET,PERIODTARGET,FILE_NAME_STATIC,FILE_NAME_SUFFIX_TYPE,FILE_NAME_DATE_FORMAT,GL_EFFECTIVE_PERIOD_NUM

from (

SELECT pp.PERIODKEY

,pp.PERIODDESC

,pp.YEARTARGET YEARTARGET

,pp.PERIODTARGET PERIODTARGET

,brl.FILE_NAME_STATIC

,brl.FILE_NAME_SUFFIX_TYPE

,brl.FILE_NAME_DATE_FORMAT

,coalesce(brp.parameter_id,0) GL_EFFECTIVE_PERIOD_NUM

FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

INNER JOIN TPOVCATEGORY pc

ON pc.CATKEY = brl.CATKEY

INNER JOIN TPOVPERIOD_FLAT_V pp

ON pp.PERIODFREQ = pc.CATFREQ

INNER JOIN AIF_BAL_RULE_LOAD_PARAMS brp

ON brp.loadid = brl.loadid

AND to_date(brp.parameter_value,'yyyy/MM/dd') = pp.periodkey

WHERE brl.LOADID = 29

AND br.rule_id = brl.rule_id

AND br.MULTI_PERIOD_FILE_FLAG in ('T','H')

AND brp.parameter_name like 'AMOUNT%'

UNION

SELECT pp.PERIODKEY

,pp.PERIODDESC

,pp.YEARTARGET YEARTARGET

,pp.PERIODTARGET PERIODTARGET

,brl.FILE_NAME_STATIC

,brl.FILE_NAME_SUFFIX_TYPE

,brl.FILE_NAME_DATE_FORMAT

,0 GL_EFFECTIVE_PERIOD_NUM

FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

INNER JOIN TPOVCATEGORY pc

ON pc.CATKEY = brl.CATKEY

INNER JOIN TPOVPERIOD_FLAT_V pp

ON pp.PERIODFREQ = pc.CATFREQ

AND pp.PERIODKEY >= brl.START_PERIODKEY

AND pp.PERIODKEY <= brl.END_PERIODKEY

WHERE brl.LOADID = 29

AND br.rule_id = brl.rule_id

AND br.MULTI_PERIOD_FILE_FLAG in( 'Y', 'X','E')

) qrslt

UNION

SELECT pp.PERIODKEY

,pp.PERIODDESC

,pp.YEARTARGET YEARTARGET

,pp.PERIODTARGET PERIODTARGET

,brl.FILE_NAME_STATIC

,brl.FILE_NAME_SUFFIX_TYPE

,brl.FILE_NAME_DATE_FORMAT

, 0 GL_EFFECTIVE_PERIOD_NUM

FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

INNER JOIN TPOVCATEGORY pc

ON pc.CATKEY = brl.CATKEY

INNER JOIN TPOVPERIOD_FLAT_V pp

ON pp.PERIODFREQ = pc.CATFREQ

AND pp.PERIODKEY >= brl.START_PERIODKEY

AND pp.PERIODKEY <= brl.END_PERIODKEY

WHERE brl.LOADID = 29

AND (br.MULTI_PERIOD_FILE_FLAG is null or br.MULTI_PERIOD_FILE_FLAG = 'N' )

AND br.rule_id = brl.rule_id

ORDER BY PERIODKEY

2019-10-22 17:02:26,314 INFO [AIF]: File Name: RE Trail Balance.csv

2019-10-22 17:02:26,314 DEBUG [AIF]:

INSERT INTO AIF_PROCESS_PERIODS (

PROCESS_ID

,PERIODKEY

,ADJUSTMENT_PERIOD_FLAG

,GL_PERIOD_YEAR

,GL_PERIOD_CODE

,GL_PERIOD_NAME

,GL_PERIOD_NUM

,GL_EFFECTIVE_PERIOD_NUM

,YEARTARGET

,PERIODTARGET

,IMP_ENTITY_TYPE

,IMP_ENTITY_NAME

,TRANS_ENTITY_TYPE

,TRANS_ENTITY_NAME

,PRIOR_PERIOD_FLAG

) VALUES (29,'2018-12-31','N',0,'0' ,'0',0,1,'FY18','Dec', 'PROCESS_BAL_IMP_FILE','RE Trail Balance.csv','PROCESS_BAL_TRANS','Dec-18','N' )

2019-10-22 17:02:26,314 DEBUG [AIF]: CommData.insertFilePeriods - END

2019-10-22 17:02:26,314 DEBUG [AIF]: CommData.getPovList - START

2019-10-22 17:02:26,314 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 TPOVPERIOD pp

ON pp.PERIODKEY = pprd.PERIODKEY

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 = 29

ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID

2019-10-22 17:02:26,314 DEBUG [AIF]: CommData.getPovList - END

2019-10-22 17:02:26,314 DEBUG [AIF]: CommData.insertImportProcessDetails - START

2019-10-22 17:02:26,314 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

,'admin' 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 = 29

) q

ORDER BY ENTITY_NAME_ORDER

2019-10-22 17:02:26,314 DEBUG [AIF]: CommData.insertImportProcessDetails - END

2019-10-22 17:02:26,329 DEBUG [AIF]: Comm.doScriptInit - START

2019-10-22 17:02:26,454 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=C:\Oracle\Middleware\user_projects\Fdmee1\FinancialDataQuality, INBOXDIR=Home\inbox, LOCNAME=DMG_TB, SOURCENAME=File, APPID=8, SOURCEID=1, APPROOTDIR=Home, IMPORTFORMAT=DMG_TB, SCRIPTSDIR=Home\data\scripts, EPMORACLEHOME=C:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HPL, RULEID=4, CATNAME=Actual, EPMORACLEINSTANCEHOME=C:\Oracle\Middleware\user_projects\Fdmee1, LOADID=29, PERIODNAME=Dec-18, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2018-12-31, EXPORTFLAG=N, TARGETAPPDB=PLAN1, TARGETAPPNAME=FPnR, FILENAME=RE Trail Balance.csv, LOCKEY=3, RULENAME=DMG_TB, OUTBOXDIR=Home\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=5, USERNAME=admin, FILEDIR=racle\Middleware\user_projects\domains\EPMSystem\Home\inbox, IMPORTFLAG=Y, USERLOCALE=null}

2019-10-22 17:02:26,454 DEBUG [AIF]: The EpmOracleHome is set to: C:\Oracle\Middleware\EPMSystem11R1

2019-10-22 17:02:26,454 DEBUG [AIF]: The EpmOracleInstance is set to: C:\Oracle\Middleware\user_projects\Fdmee1

2019-10-22 17:02:26,454 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

2019-10-22 17:02:26,454 DEBUG [AIF]: The executeEventScript is set to: YES

2019-10-22 17:02:26,454 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

2019-10-22 17:02:26,454 DEBUG [AIF]: The AppRootFolder is set to: Home

2019-10-22 17:02:26,454 DEBUG [AIF]: Comm.doScriptInit - END

2019-10-22 17:02:26,454 DEBUG [AIF]: Comm.executeScript - START

2019-10-22 17:02:26,454 DEBUG [AIF]: The following script does not exist: Home/data/scripts/event/BefImport.py

2019-10-22 17:02:26,454 DEBUG [AIF]: Comm.executeVBScript - START

2019-10-22 17:02:26,454 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

2019-10-22 17:02:26,454 DEBUG [AIF]: The following script does not exist: Home\data\scripts\event\BefImport.vbs

2019-10-22 17:02:26,454 DEBUG [AIF]: Comm.executeVBScript - END

2019-10-22 17:02:26,454 DEBUG [AIF]: Comm.executeScript - END

2019-10-22 17:02:26,454 DEBUG [AIF]: CommData.preImportData - END

2019-10-22 17:02:29,193 DEBUG [AIF]: FileData.importData - START

2019-10-22 17:02:29,193 DEBUG [AIF]: Importing data for load id: 29

2019-10-22 17:02:29,193 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,

coalesce(br.MULTI_PERIOD_FILE_FLAG, 'N') MULTI_PERIOD_FILE_FLAG

FROM aif_bal_rule_loads a,

aif_balance_rules br,

tpovperiod b,

aif_processes c

WHERE a.loadid = 29

AND a.start_periodkey=b.periodkey

AND a.loadid =c.process_id

AND br.rule_id = a.rule_id

2019-10-22 17:02:29,193 DEBUG [AIF]: FileData.py: Importing Text data for load id: 29

2019-10-22 17:02:29,256 INFO [AIF]: EPMFDM-140274:Message - Log File Name :Home\outbox\logs\FPnR_29.log

2019-10-22 17:02:29,256 DEBUG [AIF]: EPMFDM-140274:Message - SELECT COALESCE(p.partitionkey,0) PARTITIONKEY,

COALESCE(brl.catkey,0) CATKEY,

COALESCE(p.rule_id,0) RULE_ID,

part.PARTCURRENCYKEY PARTCURRENCYKEY,

dir.FILE_PATH,

p.CLUSTER_NAME,

p.APPLICATION_ID

FROM aif_processes p,

aif_bal_rule_loads brl,

tpovpartition part,

(SELECT COALESCE(

(SELECT PROFILE_OPTION_VALUE

|| '/'

FROM AIF_PROFILE_OPTION_VALUES

WHERE PROFILE_OPTION_NAME = 'PROFILE_APP_ROOT_DIRECTORY'

AND LEVEL_ID = 1005

AND LEVEL_VALUE = brl.APPLICATION_ID

) ,COALESCE(

(SELECT PROFILE_OPTION_VALUE

|| '/'

FROM AIF_PROFILE_OPTION_VALUES

WHERE PROFILE_OPTION_NAME = 'PROFILE_APP_ROOT_DIRECTORY'

AND LEVEL_ID = 1000

) ,'' ) ,'' )

|| COALESCE(brl.FILE_PATH, '') FILE_PATH,

brl.LOADID

FROM AIF_BAL_RULE_LOADS brl

) dir

WHERE p.process_id = ?

AND p.process_id = dir.loadid

AND brl.loadid = p.process_id

AND part.partitionkey = p.partitionkey

2019-10-22 17:02:29,256 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH::29;3:5:4:[NONE]:Home/racle\Middleware\user_projects\domains\EPMSystem\Home\inbox

2019-10-22 17:02:29,256 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8

2019-10-22 17:02:29,256 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start

2019-10-22 17:02:29,256 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

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

AND ((br.MULTI_PERIOD_FILE_FLAG in ( 'Y','T','X','E','H') )

OR

(br.MULTI_PERIOD_FILE_FLAG is null OR br.MULTI_PERIOD_FILE_FLAG = 'N')

)

ORDER BY en.entity_name_order

2019-10-22 17:02:29,256 DEBUG [AIF]: EPMFDM-140274:Message - update aif_process_details set status = ? , records_processed = ?, EXECUTION_END_TIME = CURRENT_TIMESTAMP where process_id = ? and entity_type = ? and entity_name = ?

2019-10-22 17:02:29,256 ERROR [AIF]: EPMFDM-140274:Message - Home\racle\Middleware\user_projects\domains\EPMSystem\Home\inbox\RE Trail Balance.csv (The system cannot find the path specified)

2019-10-22 17:02:29,256 FATAL [AIF]: Error in FileData.importData

Traceback (most recent call last):

File "<string>", line 84, in importData

RuntimeException: java.lang.RuntimeException: EPMFDM-140274:Message - {0}

2019-10-22 17:02:29,303 DEBUG [AIF]: CommData.postImportData - START

2019-10-22 17:02:29,318 DEBUG [AIF]: CommData.getRuleInfo - START

2019-10-22 17:02:29,318 DEBUG [AIF]:

SELECT brl.RULE_ID, br.RULE_NAME, brl.PARTITIONKEY, brl.CATKEY, part.PARTVALGROUP, br.SOURCE_SYSTEM_ID, ss.SOURCE_SYSTEM_TYPE

,CASE

WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'EBS%' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'PS%' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FUSION%' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE = 'FILE' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'N'

ELSE 'Y'

END SOURCE_ADAPTER_FLAG

,app.APPLICATION_ID, app.TARGET_APPLICATION_NAME, app.TARGET_APPLICATION_TYPE, app.DATA_LOAD_METHOD, brl.PLAN_TYPE

,CASE brl.PLAN_TYPE

WHEN 'PLAN1' THEN 1 WHEN 'PLAN2' THEN 2 WHEN 'PLAN3' THEN 3 WHEN 'PLAN4' THEN 4 WHEN 'PLAN5' THEN 5 WHEN 'PLAN6' THEN 6 ELSE 0

END PLAN_NUMBER

,br.INCL_ZERO_BALANCE_FLAG, br.PERIOD_MAPPING_TYPE, br.INCLUDE_ADJ_PERIODS_FLAG, br.BALANCE_TYPE ACTUAL_FLAG

,br.AMOUNT_TYPE, br.BALANCE_SELECTION, br.BALANCE_METHOD_CODE

,COALESCE(br.SIGNAGE_METHOD, 'ABSOLUTE') SIGNAGE_METHOD

,br.CURRENCY_CODE, br.BAL_SEG_VALUE_OPTION_CODE, brl.EXECUTION_MODE

,COALESCE(brl.IMPORT_FROM_SOURCE_FLAG, 'Y') IMPORT_FROM_SOURCE_FLAG

,COALESCE(brl.RECALCULATE_FLAG, 'N') RECALCULATE_FLAG

,COALESCE(brl.EXPORT_TO_TARGET_FLAG, 'N') EXPORT_TO_TARGET_FLAG

,COALESCE(brl.CHECK_FLAG, 'N') CHECK_FLAG

,CASE

WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'NONE'

WHEN (br.LEDGER_GROUP_ID IS NOT NULL) THEN 'MULTI'

WHEN (br.SOURCE_LEDGER_ID IS NOT NULL) THEN 'SINGLE'

ELSE 'NONE'

END LEDGER_GROUP_CODE

,COALESCE(br.BALANCE_AMOUNT_BS, 'YTD') BALANCE_AMOUNT_BS

,COALESCE(br.BALANCE_AMOUNT_IS, 'PERIODIC') BALANCE_AMOUNT_IS

,br.LEDGER_GROUP

,(SELECT brd.DETAIL_CODE FROM AIF_BAL_RULE_DETAILS brd WHERE brd.RULE_ID = br.RULE_ID AND brd.DETAIL_TYPE = 'LEDGER') PS_LEDGER

,CASE lg.LEDGER_TEMPLATE WHEN 'COMMITMENT' THEN 'Y' ELSE 'N' END KK_FLAG

,p.LAST_UPDATED_BY, p.AIF_WEB_SERVICE_URL WEB_SERVICE_URL, p.EPM_ORACLE_INSTANCE

,brl.JOURNAL_FLAG, br.MULTI_PERIOD_FILE_FLAG, br.IMPGROUPKEY, imp.IMPSOURCELEDGERID

,imp.IMPGROUPFILETYPE, imp.IMPTARGETSOURCESYSTEMID, imp.IMPSOURCECOAID, part.PARTTARGETAPPLICATIONID

FROM AIF_PROCESSES p

INNER JOIN AIF_BAL_RULE_LOADS brl

ON brl.LOADID = p.PROCESS_ID

INNER JOIN AIF_BALANCE_RULES br

ON br.RULE_ID = brl.RULE_ID

INNER JOIN AIF_SOURCE_SYSTEMS ss

ON ss.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID

INNER JOIN AIF_TARGET_APPLICATIONS app

ON app.APPLICATION_ID = brl.APPLICATION_ID

INNER JOIN TPOVPARTITION part

ON part.PARTITIONKEY = br.PARTITIONKEY

INNER JOIN TBHVIMPGROUP imp

ON imp.IMPGROUPKEY = part.PARTIMPGROUP

LEFT OUTER JOIN AIF_COA_LEDGERS l

ON l.SOURCE_SYSTEM_ID = p.SOURCE_SYSTEM_ID

AND l.SOURCE_LEDGER_ID = COALESCE(br.SOURCE_LEDGER_ID,imp.IMPSOURCELEDGERID)

LEFT OUTER JOIN AIF_PS_SET_CNTRL_REC_STG scr

ON scr.SOURCE_SYSTEM_ID = l.SOURCE_SYSTEM_ID

AND scr.SETCNTRLVALUE = l.SOURCE_LEDGER_NAME

AND scr.RECNAME = 'LED_GRP_TBL'

LEFT OUTER JOIN AIF_PS_LED_GRP_TBL_STG lg

ON lg.SOURCE_SYSTEM_ID = scr.SOURCE_SYSTEM_ID

AND lg.SETID = scr.SETID

AND lg.LEDGER_GROUP = br.LEDGER_GROUP

WHERE p.PROCESS_ID = 29

2019-10-22 17:02:29,318 DEBUG [AIF]:

SELECT adim.BALANCE_COLUMN_NAME DIMNAME

,adim.DIMENSION_ID

,dim.TARGET_DIMENSION_CLASS_NAME

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID2) COA_SEGMENT_NAME2

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID3) COA_SEGMENT_NAME3

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID4) COA_SEGMENT_NAME4

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID5) COA_SEGMENT_NAME5

,(SELECT DISTINCT CASE mdd.ORPHAN_OPTION_CODE

WHEN 'CHILD' THEN 'N'

WHEN 'ROOT' THEN 'N'

ELSE 'Y'

END DIMENSION_FILTER_FLAG

FROM AIF_MAP_DIM_DETAILS_V mdd

,AIF_MAPPING_RULES mr

WHERE mr.PARTITIONKEY = tpp.PARTITIONKEY

AND mdd.RULE_ID = mr.RULE_ID

AND mdd.DIMENSION_ID = adim.DIMENSION_ID

) DIMENSION_FILTER_FLAG

,tiie.IMPCONCATCHAR

FROM TPOVPARTITION tpp

INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

ON adim.APPLICATION_ID = 8

INNER JOIN AIF_DIMENSIONS dim

ON dim.DIMENSION_ID = adim.DIMENSION_ID

LEFT OUTER JOIN TBHVIMPITEMERPI tiie

ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP

AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME

AND tiie.IMPMAPTYPE = 'ERP'

WHERE tpp.PARTITIONKEY = 3

AND adim.BALANCE_COLUMN_NAME IS NOT NULL

AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

AND (adim.VALID_FOR_PLAN1 = 1 OR dim.TARGET_DIMENSION_CLASS_NAME = 'LOOKUP')

ORDER BY adim.BALANCE_COLUMN_NAME

2019-10-22 17:02:29,334 DEBUG [AIF]: {'APPLICATION_ID': 8L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': u'PLAN1', 'RULE_NAME': u'DMG_TB', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'C:\\Oracle\\Middleware\\user_projects\\Fdmee1', 'CATKEY': 5L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'FPnR', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'DMG_TB', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5', u'UD6'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD6': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD6', 'DIMENSION_ID': 65L}, u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 58L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 66L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 57L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 64L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 62L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 60L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Version', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 63L}}, 'TARGET_APPLICATION_TYPE': u'HPL', 'PARTITIONKEY': 3L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 1L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 4L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://DMGHYPEPMTEST.Daralmimar.local:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 8L, 'IMPTARGETSOURCESYSTEMID': 0L}

2019-10-22 17:02:29,334 DEBUG [AIF]: CommData.getRuleInfo - END

2019-10-22 17:02:29,334 DEBUG [AIF]: CommData.updateTDATASEG_T - START

2019-10-22 17:02:29,334 DEBUG [AIF]: CommData.getLedgerListAndMap - START

2019-10-22 17:02:29,334 DEBUG [AIF]: CommData.getLedgerSQL - START

2019-10-22 17:02:29,334 DEBUG [AIF]: CommData.getLedgerSQL - END

2019-10-22 17:02:29,334 DEBUG [AIF]:

SELECT COALESCE(br.SOURCE_LEDGER_ID,0) SOURCE_LEDGER_ID

,NULL SOURCE_LEDGER_NAME

,NULL SOURCE_COA_ID

,br.CALENDAR_ID

,NULL SETID

,NULL PERIOD_TYPE

,NULL LEDGER_TABLE_NAME

FROM AIF_BALANCE_RULES br

WHERE br.RULE_ID = 4

2019-10-22 17:02:29,334 DEBUG [AIF]: CommData.getLedgerListAndMap - END

2019-10-22 17:02:29,334 DEBUG [AIF]: CommData.getPovList - START

2019-10-22 17:02:29,334 DEBUG [AIF]: doAppPeriodMappingsExist - FPnR: N

2019-10-22 17:02:29,334 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 TPOVPERIOD pp

ON pp.PERIODKEY = pprd.PERIODKEY

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 = 29

ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID

2019-10-22 17:02:29,334 DEBUG [AIF]: CommData.getPovList - END

2019-10-22 17:02:29,334 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 = 29

AND en.process_id = pp.process_id

AND pp.IMP_ENTITY_NAME = en.file_entity_name

order by en.entity_name_order

2019-10-22 17:02:29,349 INFO [AIF]:

Import Data from Source for Period 'Dec-18'

2019-10-22 17:02:29,349 DEBUG [AIF]: CommData.updateWorkflow - START

2019-10-22 17:02:29,349 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 = 3

AND tlp.CATKEY = 5

AND tlp.PERIODKEY = '2018-12-31'

AND tlp.RULE_ID = 4

AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

2019-10-22 17:02:29,349 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 = 3 AND CATKEY = 5 AND PERIODKEY = '2018-12-31' AND RULE_ID = 4

2019-10-22 17:02:29,349 DEBUG [AIF]:

INSERT INTO TLOGPROCESS (

PROCESSENDTIME

,PROCESSSTATUS

,PROCESSIMP

,PROCESSVAL

,PROCESSEXP

,PROCESSENTLOAD

,PROCESSENTVAL

,BLNWCDIRTY

,BLNLOGICDIRTY

,BLNVALDIRTY

,PROCESSIMPNOTE

,PROCESSVALNOTE

,PROCESSEXPNOTE

,PROCESSENTLOADNOTE

,PROCESSENTVALNOTE

,PARTITIONKEY

,CATKEY

,PERIODKEY

,RULE_ID

) VALUES (

CURRENT_TIMESTAMP

,0

,NULL

,3

,5

,'2018-12-31'

,4

)

2019-10-22 17:02:29,349 DEBUG [AIF]: CommData.updateWorkflow - END

2019-10-22 17:02:29,349 FATAL [AIF]: Error in CommData.updateTDATASEG_T

Traceback (most recent call last):

File "<string>", line 1010, in updateTDATASEG_T

Import Error

2019-10-22 17:02:29,349 DEBUG [AIF]: CommData.updateWorkflow - START

2019-10-22 17:02:29,349 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 = 3 AND CATKEY = 5 AND PERIODKEY = '2018-12-31' AND RULE_ID = 4

2019-10-22 17:02:29,349 DEBUG [AIF]: CommData.updateWorkflow - END

2019-10-22 17:02:29,365 DEBUG [AIF]: Comm.doScriptInit - START

2019-10-22 17:02:29,474 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=C:\Oracle\Middleware\user_projects\Fdmee1\FinancialDataQuality, INBOXDIR=Home\inbox, LOCNAME=DMG_TB, SOURCENAME=File, APPID=8, SOURCEID=1, APPROOTDIR=Home, IMPORTFORMAT=DMG_TB, SCRIPTSDIR=Home\data\scripts, EPMORACLEHOME=C:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HPL, RULEID=4, CATNAME=Actual, EPMORACLEINSTANCEHOME=C:\Oracle\Middleware\user_projects\Fdmee1, LOADID=29, PERIODNAME=Dec-18, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2018-12-31, EXPORTFLAG=N, TARGETAPPDB=PLAN1, TARGETAPPNAME=FPnR, FILENAME=RE Trail Balance.csv, LOCKEY=3, RULENAME=DMG_TB, OUTBOXDIR=Home\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=5, USERNAME=admin, FILEDIR=racle\Middleware\user_projects\domains\EPMSystem\Home\inbox, IMPORTFLAG=Y, USERLOCALE=null}