Forum Stats

  • 3,854,607 Users
  • 2,264,390 Discussions
  • 7,905,742 Comments

Discussions

FDMEE - Import Fail (Root Folder)

AbanoubZaki
AbanoubZaki Member Posts: 144 Red Ribbon
edited Oct 24, 2019 10:10AM in Financial Data Management

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?

AbanoubZaki

Best Answer

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Oct 23, 2019 4:56AM Answer ✓

    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

    AbanoubZakiAbanoubZaki

Answers

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited 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
    AbanoubZaki Member Posts: 144 Red Ribbon
    edited Oct 22, 2019 3:50PM

    Hello John,

    But I am not using ODI !!

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited 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

    pastedImage_0.png

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

  • AbanoubZaki
    AbanoubZaki Member Posts: 144 Red Ribbon
    edited 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 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

  • user6692921
    user6692921 Member Posts: 179 Silver Badge
    edited Oct 23, 2019 4:06AM

    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.

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Oct 23, 2019 4:56AM Answer ✓

    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

    AbanoubZakiAbanoubZaki
  • AbanoubZaki
    AbanoubZaki Member Posts: 144 Red Ribbon
    edited Oct 23, 2019 5:12AM

    Could you please guide me, how to solve it?

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Oct 23, 2019 5:20AM

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

    pastedImage_0.pngpastedImage_1.png

    AbanoubZaki
  • AbanoubZaki
    AbanoubZaki Member Posts: 144 Red Ribbon
    edited Oct 23, 2019 5:23AM

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

    but still the issue

  • AbanoubZaki
    AbanoubZaki Member Posts: 144 Red Ribbon
    edited Oct 23, 2019 6:20AM

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