10 Replies Latest reply on Oct 23, 2019 10:20 AM by AbanoubZaki

    FDMEE - Import Fail (Root Folder)

    AbanoubZaki

      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?

        • 1. Re: FDMEE - Import Fail
          JohnGoodwin

          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

          • 2. Re: FDMEE - Import Fail
            AbanoubZaki

            Hello John,

             

            But I am not using ODI !!

            • 3. Re: FDMEE - Import Fail
              JohnGoodwin

              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.

              • 4. Re: FDMEE - Import Fail
                AbanoubZaki

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

                          ,0

                          ,0

                          ,0

                          ,0

                          ,0

                          ,0

                          ,0

                          ,0

                          ,NULL

                          ,NULL

                          ,NULL

                          ,NULL

                          ,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}

                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

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

                • 5. Re: FDMEE - Import Fail
                  user6692921

                  It can't find the import file:

                   

                  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)

                   

                  It is looking for the folder Home\racle\Middleware\user_projects.... I think you have a problem on your system settings | application root.

                  • 6. Re: FDMEE - Import Fail
                    JohnGoodwin

                    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

                    1 person found this helpful
                    • 7. Re: FDMEE - Import Fail
                      AbanoubZaki

                      Could you please guide me, how to solve it?

                      • 8. Re: FDMEE - Import Fail
                        JohnGoodwin

                        Check what is defined for the application root folder, at system and application level setting

                         

                        • 9. Re: FDMEE - Import Fail
                          AbanoubZaki

                          I have already checked them and pressed "Create Application Folders".

                          but still the issue

                          • 10. Re: FDMEE - Import Fail
                            AbanoubZaki

                            JohnGoodwin I have check them, but the same issue there? what troubleshooting processes shall i proceed with?