9 Replies Latest reply on Nov 7, 2017 11:55 AM by SK0412

    FDMEE Data Load failing during import process

    3231061

      Hi Team,

       

      We are facing some issue in FDMEE JE loads during import process. This issue is not consistent jobs are failing randomly with no exact reason. This is happening only for HFM. Planning JE load is getting successful.

       

      Any help would be highly appreciated. Please find the below log.

       

      Thanks,

      Kiran

       

      2017-11-01 21:45:03,006 INFO  [AIF]: FDMEE Process Start, Process ID: 22,751

      2017-11-01 21:45:03,006 INFO  [AIF]: FDMEE Logging Level: 5

      2017-11-01 21:45:03,006 INFO  [AIF]: FDMEE Log File: \\HYM01\FDMEE\PRD1HFM\outbox\logs\PRD1HFM_22751.log

      2017-11-01 21:45:03,006 INFO  [AIF]: User:App

      2017-11-01 21:45:03,006 INFO  [AIF]: Location:JE_DW_HFM (Partitionkey:139)

      2017-11-01 21:45:03,006 INFO  [AIF]: Period Name:Oct-17 (Period Key:10/31/17 12:00 AM)

      2017-11-01 21:45:03,006 INFO  [AIF]: Category Name:Actual (Category key:1)

      2017-11-01 21:45:03,006 INFO  [AIF]: Rule Name:JE_DW_HFM (Rule ID:177)

      2017-11-01 21:45:05,908 INFO  [AIF]: FDM Version: 11.1.2.3.700

      2017-11-01 21:45:05,908 INFO  [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

      [Oracle JRockit(R) (Oracle Corporation)]

      2017-11-01 21:45:05,908 INFO  [AIF]: Java Platform: java1.6.0_37

      2017-11-01 21:45:05,908 INFO  [AIF]: Log File Encoding: UTF-8

      2017-11-01 21:45:10,120 INFO  [AIF]: -------START IMPORT STEP-------

      2017-11-01 21:45:10,307 DEBUG [AIF]: CommData.preImportData - START

      2017-11-01 21:45:10,322 DEBUG [AIF]: CommData.getRuleInfo - START

      2017-11-01 21:45:10,322 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 = 22751

             

      2017-11-01 21:45:10,338 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 = 6

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

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

           

            ORDER BY adim.BALANCE_COLUMN_NAME

           

      2017-11-01 21:45:10,338 DEBUG [AIF]: {'APPLICATION_ID': 6L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'JE_DW_HFM', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\FDM1', 'CATKEY': 1L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'OTHERS', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'PRD1HFM', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 3L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': None, 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'AppAdmin', 'DIMNAME_MAP': {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': 20L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', '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'ICP', 'DIMENSION_ID': 23L}, 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': 19L}, 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': 22L}, 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': 17L}, u'UD1': {'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'UD1', 'DIMENSION_ID': 21L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 139L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': u'SNAPSHOT', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': None, 'IMPGROUPFILETYPE': u'ODI', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 177L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'Y', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://HYPPRDAPPFDM01:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 6L, 'IMPTARGETSOURCESYSTEMID': 0L}

      2017-11-01 21:45:10,338 DEBUG [AIF]: CommData.getRuleInfo - END

      2017-11-01 21:45:10,369 DEBUG [AIF]: CommData.insertPeriods - START

      2017-11-01 21:45:10,369 DEBUG [AIF]: CommData.getLedgerListAndMap - START

      2017-11-01 21:45:10,385 DEBUG [AIF]: CommData.getLedgerSQL - START

      2017-11-01 21:45:10,385 DEBUG [AIF]: CommData.getLedgerSQL - END

      2017-11-01 21:45:10,385 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 = 177

               

      2017-11-01 21:45:10,385 DEBUG [AIF]: CommData.getLedgerListAndMap - END

      2017-11-01 21:45:10,385 DEBUG [AIF]: doAppPeriodMappingsExist - PRD1HFM: Y

      2017-11-01 21:45:10,385 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

      2017-11-01 21:45:10,385 DEBUG [AIF]:

              INSERT INTO AIF_PROCESS_PERIODS (

                PROCESS_ID

                ,PERIODKEY

                ,PERIOD_ID

                ,ADJUSTMENT_PERIOD_FLAG

                ,GL_PERIOD_YEAR

                ,GL_PERIOD_NUM

                ,GL_PERIOD_NAME

                ,GL_PERIOD_CODE

                ,GL_EFFECTIVE_PERIOD_NUM

                ,YEARTARGET

                ,PERIODTARGET

                ,IMP_ENTITY_TYPE

                ,IMP_ENTITY_ID

                ,IMP_ENTITY_NAME

                ,TRANS_ENTITY_TYPE

                ,TRANS_ENTITY_ID

                ,TRANS_ENTITY_NAME

                ,PRIOR_PERIOD_FLAG

                ,SOURCE_LEDGER_ID

              )

             

                      SELECT DISTINCT brl.LOADID PROCESS_ID

                      ,pp.PERIODKEY PERIODKEY

                      ,prd.PERIOD_ID

                      ,COALESCE(prd.ADJUSTMENT_PERIOD_FLAG, 'N') ADJUSTMENT_PERIOD_FLAG

                      ,COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) GL_PERIOD_YEAR

                      ,COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0) GL_PERIOD_NUM

                      ,COALESCE(prd.PERIOD_NAME, ppsrc.GL_PERIOD_NAME,'0') GL_PERIOD_NAME

                      ,COALESCE(prd.PERIOD_CODE, CAST(COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0) AS VARCHAR(38)),'0') GL_PERIOD_CODE

                      ,(COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) * 10000 + COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0)) GL_EFFECTIVE_PERIOD_NUM

                      ,pp.YEARTARGET YEARTARGET

                      ,pp.PERIODTARGET PERIODTARGET

                      ,'PROCESS_BAL_IMP' IMP_ENTITY_TYPE

                      ,(COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) * 10000 + COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0)) IMP_ENTITY_ID

                      ,COALESCE(prd.PERIOD_NAME, ppsrc.GL_PERIOD_NAME,'0')+' ('+pp.PERIODDESC+')' IMP_ENTITY_NAME

                      ,'PROCESS_BAL_TRANS' TRANS_ENTITY_TYPE

                      ,(COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) * 10000 + COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0)) TRANS_ENTITY_ID

                      ,pp.PERIODDESC TRANS_ENTITY_NAME

                      ,'N' PRIOR_PERIOD_FLAG

                      ,0 SOURCE_LEDGER_ID

                      FROM (

                        AIF_BAL_RULE_LOADS brl

                        INNER JOIN TPOVCATEGORY pc

                          ON pc.CATKEY = brl.CATKEY

                     

                        INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp

                          ON pp.PERIODFREQ = pc.CATFREQ

                          AND pp.PERIODKEY >= brl.START_PERIODKEY

                          AND pp.PERIODKEY <= brl.END_PERIODKEY

                          AND pp.INTSYSTEMKEY = 'PRD1HFM'

                      )

                      INNER JOIN TPOVPERIODSOURCE ppsrc

                        ON ppsrc.PERIODKEY = pp.PERIODKEY

                        AND ppsrc.MAPPING_TYPE = 'EXPLICIT'

                        AND ppsrc.SOURCE_SYSTEM_ID = 3

                        AND ppsrc.CALENDAR_ID IN ('GLAUTO')

                      LEFT OUTER JOIN AIF_GL_PERIODS_STG prd

                        ON prd.PERIOD_ID = ppsrc.PERIOD_ID

                        AND prd.SOURCE_SYSTEM_ID = ppsrc.SOURCE_SYSTEM_ID

                        AND prd.CALENDAR_ID = ppsrc.CALENDAR_ID

                       

                        AND prd.ADJUSTMENT_PERIOD_FLAG = 'N'

                      WHERE brl.LOADID = 22751

                      ORDER BY pp.PERIODKEY

                      ,GL_EFFECTIVE_PERIOD_NUM

                     

      2017-11-01 21:45:10,385 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', 'PROCESS_BAL_TRANS', 0L, u'PRD1HFM', u'EXPLICIT', 3L, u'GLAUTO', 'N', 22751]

      2017-11-01 21:45:10,400 DEBUG [AIF]: CommData.insertPeriods - END

      2017-11-01 21:45:10,400 DEBUG [AIF]: CommData.getPovList - START

      2017-11-01 21:45:10,400 DEBUG [AIF]:

              SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY

              ,COALESCE(pp.PERIODDESC, CONVERT(VARCHAR,pprd.PERIODKEY,120)) PERIODDESC

              ,brl.RULE_ID, br.RULE_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

              FROM AIF_BAL_RULE_LOADS brl

              INNER JOIN AIF_BALANCE_RULES br

                ON br.RULE_ID = brl.RULE_ID

              INNER JOIN TPOVPARTITION part

                ON part.PARTITIONKEY = brl.PARTITIONKEY

              INNER JOIN TPOVCATEGORY cat

                ON cat.CATKEY = brl.CATKEY

              INNER JOIN AIF_PROCESS_PERIODS pprd

                ON pprd.PROCESS_ID = brl.LOADID

             

                LEFT OUTER JOIN TPOVPERIODADAPTOR pp

                  ON pp.PERIODKEY = pprd.PERIODKEY

                  AND pp.INTSYSTEMKEY = 'PRD1HFM'

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

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

           

      2017-11-01 21:45:10,400 DEBUG [AIF]: CommData.getPovList - END

      2017-11-01 21:45:10,400 DEBUG [AIF]: CommData.insertImportProcessDetails - START

      2017-11-01 21:45:10,416 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

                ,'AppAdmin' 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 = 22751

                ) q

                ORDER BY ENTITY_NAME_ORDER

               

      2017-11-01 21:45:10,416 DEBUG [AIF]: CommData.insertImportProcessDetails - END

      2017-11-01 21:45:10,416 DEBUG [AIF]: Comm.doScriptInit - START

      2017-11-01 21:45:10,510 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\FDM1\FinancialDataQuality, INBOXDIR=\\HYPPRDAPPFDM01\FDMEE\PRD1HFM\inbox, LOCNAME=JE_DW_HFM, SOURCENAME=DATA_WAREHOUSE, APPID=6, SOURCEID=3, APPROOTDIR=\\HYPM01\FDMEE\PRD1HFM, IMPORTFORMAT=DB_HFM, SCRIPTSDIR=\\HYPM01\FDMEE\PRD1HFM\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=177, CATNAME=Actual, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\FDM1, LOADID=22751, PERIODNAME=Oct-17, IMPORTMODE=SNAPSHOT, SOURCETYPE=OTHERS, PERIODKEY=2017-10-31, EXPORTFLAG=Y, TARGETAPPDB=null, TARGETAPPNAME=PRD1HFM, LOCKEY=139, RULENAME=JE_DW_HFM, OUTBOXDIR=\\HYPM01\FDMEE\PRD1HFM\outbox, MULTIPERIODLOAD=N, EXPORTMODE=Replace, CATKEY=1, USERNAME=App, FILEDIR=null, IMPORTFLAG=Y, USERLOCALE=en}

      2017-11-01 21:45:10,525 DEBUG [AIF]: The executeEventScript is set to: YES

      2017-11-01 21:45:10,525 DEBUG [AIF]: The AppRootFolder is set to: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM

      2017-11-01 21:45:10,525 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

      2017-11-01 21:45:10,525 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB

      2017-11-01 21:45:10,525 DEBUG [AIF]: Comm.doScriptInit - END

      2017-11-01 21:45:10,525 DEBUG [AIF]: Comm.executeScript - START

      2017-11-01 21:45:10,525 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM/data/scripts/event/BefImport.py

      2017-11-01 21:45:10,541 DEBUG [AIF]: Comm.executeVBScript - START

      2017-11-01 21:45:10,541 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

      2017-11-01 21:45:10,541 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\data\scripts\event\BefImport.vbs

      2017-11-01 21:45:10,541 DEBUG [AIF]: Comm.executeVBScript - END

      2017-11-01 21:45:10,541 DEBUG [AIF]: Comm.executeScript - END

      2017-11-01 21:45:10,541 DEBUG [AIF]: CommData.preImportData - END

      2017-11-01 21:45:19,183 DEBUG [AIF]:

      ERP GL Balances Print Variables

      ===============================

      p_sql_db_type: SQLSERVER

      p_adp_project_code: AIF_OI

      p_adp_scenario_name: DB_HFM

      p_prd_entity_name: 10 (Oct-17)

      p_prd_periodkey: 2017-10-31 00:00:00

       

       

      2017-11-01 21:45:22,506 DEBUG [AIF]: Comm.updateProcessDetail - START

      2017-11-01 21:45:22,522 DEBUG [AIF]:

          UPDATE AIF_PROCESS_DETAILS

          SET STATUS = 'SUCCESS'

          ,RECORDS_PROCESSED = CASE

            WHEN RECORDS_PROCESSED IS NULL THEN 0

            ELSE RECORDS_PROCESSED

          END + 0

          ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

          ,LAST_UPDATED_BY = CASE

            WHEN ('AppAdmin' IS NULL) THEN LAST_UPDATED_BY

            ELSE 'AppAdmin'

          END

          ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

          WHERE PROCESS_ID = 22751

          AND ENTITY_TYPE = 'PROCESS_BAL_IMP'

          AND ENTITY_NAME = '10 (Oct-17)'

         

      2017-11-01 21:45:22,522 DEBUG [AIF]: Comm.updateProcessDetail - END

      2017-11-01 21:45:22,818 DEBUG [AIF]: CommData.postImportData - START

      2017-11-01 21:45:22,818 DEBUG [AIF]: CommData.getRuleInfo - START

      2017-11-01 21:45:22,818 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 LIKE 'FILE%' 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

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

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

             

      2017-11-01 21:45:22,834 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 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 = 6

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

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

           

            ORDER BY adim.BALANCE_COLUMN_NAME

           

      2017-11-01 21:45:22,834 DEBUG [AIF]: {'APPLICATION_ID': 6L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'JE_DW_HFM', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\FDM1', 'CATKEY': 1L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'OTHERS', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'PRD1HFM', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 3L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': None, 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3'], 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'AppAdmin', 'DIMNAME_MAP': {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': 20L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', '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'ICP', 'DIMENSION_ID': 23L}, 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': 19L}, 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': 22L}, 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': 17L}, u'UD1': {'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'UD1', 'DIMENSION_ID': 21L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 139L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': u'SNAPSHOT', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': None, 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 177L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'Y', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://HYPPRDAPPFDM01:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI'}

      2017-11-01 21:45:22,834 DEBUG [AIF]: CommData.getRuleInfo - END

      2017-11-01 21:45:22,849 DEBUG [AIF]: CommData.updateTDATASEG_T - START

      2017-11-01 21:45:22,849 DEBUG [AIF]: CommData.getLedgerListAndMap - START

      2017-11-01 21:45:22,849 DEBUG [AIF]: CommData.getLedgerSQL - START

      2017-11-01 21:45:22,849 DEBUG [AIF]: CommData.getLedgerSQL - END

      2017-11-01 21:45:22,849 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 = 177

               

      2017-11-01 21:45:22,849 DEBUG [AIF]: CommData.getLedgerListAndMap - END

      2017-11-01 21:45:22,865 DEBUG [AIF]: CommData.getPovList - START

      2017-11-01 21:45:22,865 DEBUG [AIF]: commAppPeriodMappingExists: Y

      2017-11-01 21:45:22,865 DEBUG [AIF]:

              SELECT DISTINCT brl.PARTITIONKEY

              ,part.PARTNAME

              ,brl.CATKEY

              ,cat.CATNAME

              ,pprd.PERIODKEY

              ,COALESCE(pp.PERIODDESC, CONVERT(VARCHAR,pprd.PERIODKEY,120)) PERIODDESC

              ,brl.RULE_ID

              ,br.RULE_NAME

              ,CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

              FROM AIF_BAL_RULE_LOADS brl

              INNER JOIN AIF_BALANCE_RULES br

                ON br.RULE_ID = brl.RULE_ID

              INNER JOIN TPOVPARTITION part

                ON part.PARTITIONKEY = brl.PARTITIONKEY

              INNER JOIN TPOVCATEGORY cat

                ON cat.CATKEY = brl.CATKEY

              INNER JOIN AIF_PROCESS_PERIODS pprd

                ON pprd.PROCESS_ID = brl.LOADID

             

                LEFT OUTER JOIN TPOVPERIODADAPTOR pp

                  ON pp.PERIODKEY = pprd.PERIODKEY

                  AND pp.INTSYSTEMKEY = 'PRD1HFM'

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

              ORDER BY brl.PARTITIONKEY

              ,brl.CATKEY

              ,pprd.PERIODKEY

              ,brl.RULE_ID

           

      2017-11-01 21:45:22,865 DEBUG [AIF]: CommData.getPovList - END

      2017-11-01 21:45:22,865 INFO  [AIF]:

      Import Data from Source for Period 'Oct-17'

      2017-11-01 21:45:22,880 DEBUG [AIF]: CommData.updateWorkflow - START

      2017-11-01 21:45:22,880 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 = 139

          AND tlp.CATKEY = 1

          AND tlp.PERIODKEY = '2017-10-31'

          AND tlp.RULE_ID = 177

          AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

         

      2017-11-01 21:45:22,880 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 = 139

              AND CATKEY = 1

              AND PERIODKEY = '2017-10-31'

              AND RULE_ID = 177

             

      2017-11-01 21:45:22,896 DEBUG [AIF]: CommData.updateWorkflow - END

      2017-11-01 21:45:22,896 DEBUG [AIF]:

                  SELECT adim.BALANCE_COLUMN_NAME DIMNAME

                  ,dim.TARGET_DIMENSION_CLASS_NAME

                  FROM TPOVPARTITION tpp

                  INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                    ON adim.APPLICATION_ID = tpp.PARTTARGETAPPLICATIONID

                    AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                   

                  INNER JOIN AIF_DIMENSIONS dim

                    ON dim.DIMENSION_ID = adim.DIMENSION_ID

                  WHERE tpp.PARTITIONKEY = 139

                  AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                  ORDER BY adim.BALANCE_COLUMN_NAME

                 

      2017-11-01 21:45:22,896 DEBUG [AIF]: 

                  UPDATE TDATASEG_T

                 

                  SET AMOUNTX = AMOUNT

                 

                    ,ACCOUNTX = NULL

                    ,ENTITYX = NULL

                    ,ICPX = NULL

                    ,UD1X = NULL

                    ,UD2X = NULL

                    ,UD3X = NULL

                  WHERE TDATASEG_T.LOADID = 22751

                  AND TDATASEG_T.PARTITIONKEY = 139

                  AND TDATASEG_T.CATKEY = 1

                  AND TDATASEG_T.PERIODKEY = '2017-10-31'

                 

      2017-11-01 21:45:22,896 INFO  [AIF]: Generic Data Rows Imported from Source: 0

      2017-11-01 21:45:22,896 INFO  [AIF]: Total Data Rows Imported from Source: 0

      2017-11-01 21:45:22,896 DEBUG [AIF]: CommData.updateTDATASEG_T - END

      2017-11-01 21:45:22,912 DEBUG [AIF]: Comm.doScriptInit - START

      2017-11-01 21:45:23,099 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\FDM1\FinancialDataQuality, INBOXDIR=\\HYPPRDAPPFDM01\FDMEE\PRD1HFM\inbox, LOCNAME=JE_DW_HFM, SOURCENAME=DATA_WAREHOUSE, APPID=6, SOURCEID=3, APPROOTDIR=\\HYPPRDAPPFDM01\FDMEE\PRD1HFM, IMPORTFORMAT=DB_HFM, SCRIPTSDIR=\\HYPPRDAPPFDM01\FDMEE\PRD1HFM\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=177, CATNAME=Actual, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\FDM1, LOADID=22751, PERIODNAME=Oct-17, IMPORTMODE=SNAPSHOT, SOURCETYPE=OTHERS, PERIODKEY=2017-10-31, EXPORTFLAG=Y, TARGETAPPDB=null, TARGETAPPNAME=PRD1HFM, LOCKEY=139, RULENAME=JE_DW_HFM, OUTBOXDIR=\\HYPPRDAPPFDM01\FDMEE\PRD1HFM\outbox, MULTIPERIODLOAD=N, EXPORTMODE=Replace, CATKEY=1, USERNAME=AppAdmin, FILEDIR=null, IMPORTFLAG=Y, USERLOCALE=en}

      2017-11-01 21:45:23,099 DEBUG [AIF]: The EpmOracleHome is set to: D:\Oracle\Middleware\EPMSystem11R1

      2017-11-01 21:45:23,099 DEBUG [AIF]: The EpmOracleInstance is set to: D:\Oracle\Middleware\user_projects\FDM1

      2017-11-01 21:45:23,099 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

      2017-11-01 21:45:23,099 DEBUG [AIF]: The executeEventScript is set to: YES

      2017-11-01 21:45:23,099 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB

      2017-11-01 21:45:23,099 DEBUG [AIF]: The AppRootFolder is set to: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM

      2017-11-01 21:45:23,099 DEBUG [AIF]: Comm.doScriptInit - END

      2017-11-01 21:45:23,099 DEBUG [AIF]: Comm.executeScript - START

      2017-11-01 21:45:23,099 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM/data/scripts/event/AftImport.py

      2017-11-01 21:45:23,099 DEBUG [AIF]: Comm.executeVBScript - START

      2017-11-01 21:45:23,099 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

      2017-11-01 21:45:23,099 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\data\scripts\event\AftImport.vbs

      2017-11-01 21:45:23,099 DEBUG [AIF]: Comm.executeVBScript - END

      2017-11-01 21:45:23,099 DEBUG [AIF]: Comm.executeScript - END

      2017-11-01 21:45:23,099 DEBUG [AIF]: CommData.postImportData - END

      2017-11-01 21:45:23,676 DEBUG [AIF]: LogicGroup.createLogicAccounts - START

      2017-11-01 21:45:23,692 DEBUG [AIF]: Comm.executeScript - START

      2017-11-01 21:45:23,692 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM/data/scripts/event/BefProcLogicGrp.py

      2017-11-01 21:45:23,692 DEBUG [AIF]: Comm.executeVBScript - START

      2017-11-01 21:45:23,692 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\data\scripts\event\BefProcLogicGrp.vbs

      2017-11-01 21:45:23,692 DEBUG [AIF]: Comm.executeVBScript - END

      2017-11-01 21:45:23,692 DEBUG [AIF]: Comm.executeScript - END

      2017-11-01 21:45:23,692 DEBUG [AIF]: CommData.getRuleInfo - START

      2017-11-01 21:45:23,692 DEBUG [AIF]: CommData.getRuleInfo - START

      2017-11-01 21:45:23,692 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 = 22751

             

      2017-11-01 21:45:23,692 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 = 6

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

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

           

            ORDER BY adim.BALANCE_COLUMN_NAME

           

      2017-11-01 21:45:23,692 DEBUG [AIF]: {'APPLICATION_ID': 6L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'JE_DW_HFM', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\FDM1', 'CATKEY': 1L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'OTHERS', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'PRD1HFM', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 3L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': None, 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'AppAdmin', 'DIMNAME_MAP': {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': 20L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', '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'ICP', 'DIMENSION_ID': 23L}, 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': 19L}, 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': 22L}, 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': 17L}, u'UD1': {'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'UD1', 'DIMENSION_ID': 21L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 139L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': u'SNAPSHOT', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': None, 'IMPGROUPFILETYPE': u'ODI', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 177L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'Y', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://HYPPRDAPPFDM01:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 6L, 'IMPTARGETSOURCESYSTEMID': 0L}

      2017-11-01 21:45:23,692 DEBUG [AIF]: CommData.getRuleInfo - END

      2017-11-01 21:45:23,692 DEBUG [AIF]:

              select part.PARTLOGICGROUP

              ,lgrp.CALCGROUPTYPE

              from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp

              where prs.PROCESS_ID=22751 and prs.PARTITIONKEY=part.PARTITIONKEY

              and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY 

             

      2017-11-01 21:45:23,692 DEBUG [AIF]: CommData.getRuleInfo - END

      2017-11-01 21:45:23,692 DEBUG [AIF]: Comm.executeScript - START

      2017-11-01 21:45:23,707 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM/data/scripts/event/AftProcLogicGrp.py

      2017-11-01 21:45:23,707 DEBUG [AIF]: Comm.executeVBScript - START

      2017-11-01 21:45:23,707 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\data\scripts\event\AftProcLogicGrp.vbs

      2017-11-01 21:45:23,707 DEBUG [AIF]: Comm.executeVBScript - END

      2017-11-01 21:45:23,707 DEBUG [AIF]: Comm.executeScript - END

      2017-11-01 21:45:23,707 DEBUG [AIF]: LogicGroup.createLogicAccounts - END

      2017-11-01 21:45:23,770 DEBUG [AIF]: CommData.mapData - START

      2017-11-01 21:45:23,770 DEBUG [AIF]: Comm.executeScript - START

      2017-11-01 21:45:23,770 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM/data/scripts/event/BefProcMap.py

      2017-11-01 21:45:23,770 DEBUG [AIF]: Comm.executeVBScript - START

      2017-11-01 21:45:23,770 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\data\scripts\event\BefProcMap.vbs

      2017-11-01 21:45:23,770 DEBUG [AIF]: Comm.executeVBScript - END

      2017-11-01 21:45:23,770 DEBUG [AIF]: Comm.executeScript - END

      2017-11-01 21:45:23,770 DEBUG [AIF]: CommData.insertTransProcessDetails - START

      2017-11-01 21:45:23,770 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

                ,'AppAdmin' LAST_UPDATED_BY

                ,CURRENT_TIMESTAMP LAST_UPDATE_DATE

                FROM (

                  SELECT PROCESS_ID

                  ,TRANS_ENTITY_TYPE ENTITY_TYPE

                  ,MIN(TRANS_ENTITY_ID) ENTITY_ID

                  ,TRANS_ENTITY_NAME ENTITY_NAME

                  ,MIN(COALESCE(SOURCE_LEDGER_ID,0) * 100000000 + GL_EFFECTIVE_PERIOD_NUM) ENTITY_NAME_ORDER

                  FROM AIF_PROCESS_PERIODS

                  WHERE PROCESS_ID = 22751

                  AND PRIOR_PERIOD_FLAG = 'N'

                  GROUP BY PROCESS_ID

                  ,TRANS_ENTITY_TYPE

                  ,TRANS_ENTITY_NAME

                ) q

                ORDER BY ENTITY_NAME_ORDER

               

      2017-11-01 21:45:23,770 DEBUG [AIF]: CommData.insertTransProcessDetails - END

      2017-11-01 21:45:23,785 DEBUG [AIF]:

              DELETE FROM TDATAMAP_T

              WHERE LOADID < 22751

              AND EXISTS (

                SELECT 1

                FROM AIF_PROCESSES p

                WHERE p.RULE_ID = 177

                AND p.PROCESS_ID = TDATAMAP_T.LOADID

              )

             

      2017-11-01 21:45:24,300 DEBUG [AIF]:

              DELETE FROM TDATASEG_T

              WHERE LOADID < 22751

              AND EXISTS (

                SELECT 1

                FROM AIF_PROCESSES p

                WHERE p.RULE_ID = 177

                AND p.PROCESS_ID = TDATASEG_T.LOADID

              )

             

      2017-11-01 21:45:24,581 DEBUG [AIF]:

              DELETE FROM AIF_PROCESS_PERIODS

              WHERE PROCESS_ID < 22751

              AND EXISTS (

                SELECT 1

                FROM AIF_PROCESSES p

                WHERE p.RULE_ID = 177

                AND p.PROCESS_ID = AIF_PROCESS_PERIODS.PROCESS_ID

              )

             

      2017-11-01 21:45:24,612 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START

      2017-11-01 21:45:24,612 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START

      2017-11-01 21:45:24,612 DEBUG [AIF]:

              SELECT COALESCE(part_parent.PARTITIONKEY, part.PARTITIONKEY) PARTITIONKEY

              ,COALESCE(part_parent.PARTNAME, part.PARTNAME) PARTNAME

              FROM TPOVPARTITION part

              LEFT OUTER JOIN TPOVPARTITION part_parent

                ON part_parent.PARTITIONKEY = part.PARTPARENTKEY

              WHERE part.PARTITIONKEY = 139

             

      2017-11-01 21:45:24,612 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END

      2017-11-01 21:45:24,628 INFO  [AIF]: Processing Mappings from Parent Location: DM_JE_HFM

      2017-11-01 21:45:24,628 DEBUG [AIF]:

              INSERT INTO TDATAMAP_T (

                LOADID

                ,DATAKEY

                ,PARTITIONKEY

                ,DIMNAME

                ,SRCKEY

                ,SRCDESC

                ,TARGKEY

                ,WHERECLAUSETYPE

                ,WHERECLAUSEVALUE

                ,CHANGESIGN

                ,SEQUENCE

                ,VBSCRIPT

                ,TDATAMAPTYPE

                ,SYSTEM_GENERATED_FLAG

                ,RULE_ID

              )

              SELECT 22751

              ,DATAKEY

              ,139 PARTITIONKEY

              ,DIMNAME

              ,SRCKEY

              ,SRCDESC

              ,CASE WHEN (TDATAMAPTYPE = 'EPM' AND TARGKEY = '<BLANK>') THEN ' ' ELSE TARGKEY END

              ,WHERECLAUSETYPE

              ,CASE WHEN (TDATAMAPTYPE = 'EPM' AND WHERECLAUSEVALUE = '<BLANK>') THEN ' ' ELSE WHERECLAUSEVALUE END       

              ,CHANGESIGN

              ,SEQUENCE

              ,VBSCRIPT

              ,TDATAMAPTYPE

              ,SYSTEM_GENERATED_FLAG

              ,RULE_ID

              FROM TDATAMAP tdm

              WHERE PARTITIONKEY = 3

              AND (RULE_ID IS NULL OR RULE_ID = 177)

              AND (

                TDATAMAPTYPE = 'ERP'

                OR (

                  TDATAMAPTYPE = 'MULTIDIM'

                  AND EXISTS (

                    SELECT 1

                    FROM TDATAMAP multidim

                    WHERE multidim.PARTITIONKEY = tdm.PARTITIONKEY

                    AND multidim.TDATAMAPTYPE = 'ERP'

                    AND multidim.DATAKEY = tdm.TARGKEY

                  )

                )

              )

             

      2017-11-01 21:45:24,643 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 184

      2017-11-01 21:45:24,643 DEBUG [AIF]: CommData.targetMemberFilter - START

      2017-11-01 21:45:24,659 DEBUG [AIF]:

              DELETE FROM AIF_TARGET_APPL_DIM_MEMS

              WHERE APPLICATION_ID = 6

              AND CREATED_BY_RULE_ID = 177   

             

      2017-11-01 21:45:24,659 DEBUG [AIF]:

              INSERT INTO AIF_TARGET_APPL_DIM_MEMS (

                APPLICATION_ID, DIMENSION_ID, MEMBER_NAME, CREATED_BY_RULE_ID

                ,VALID_FOR_PLAN1, VALID_FOR_PLAN2, VALID_FOR_PLAN3, VALID_FOR_PLAN4, VALID_FOR_PLAN5, VALID_FOR_PLAN6

              )

              SELECT DISTINCT adim.APPLICATION_ID, adim.DIMENSION_ID, tdmt.TARGKEY MEMBER_NAME, 177 CREATED_BY_RULE_ID

              ,adim.VALID_FOR_PLAN1, adim.VALID_FOR_PLAN2, adim.VALID_FOR_PLAN3, adim.VALID_FOR_PLAN4, adim.VALID_FOR_PLAN5, adim.VALID_FOR_PLAN6

              FROM TDATAMAP_T tdmt

              ,AIF_TARGET_APPL_DIMENSIONS adim

              ,AIF_DIMENSIONS dim 

              WHERE tdmt.LOADID = 22751

              AND (

                tdmt.WHERECLAUSETYPE IS NULL

                OR tdmt.WHERECLAUSETYPE = 'BETWEEN'

                OR (tdmt.WHERECLAUSETYPE = 'LIKE' AND CHARINDEX('*', tdmt.TARGKEY, 1) = 0)

              )

              AND adim.APPLICATION_ID = 6

              AND adim.BALANCE_COLUMN_NAME = tdmt.DIMNAME

              AND dim.DIMENSION_ID = adim.DIMENSION_ID

             

      2017-11-01 21:45:27,233 DEBUG [AIF]: CommData.targetMemberFilter - END

      2017-11-01 21:45:27,295 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START

      2017-11-01 21:45:27,295 DEBUG [AIF]:

              SELECT DIMNAME, SRCKEY, TARGKEY, WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE,

                     DATAKEY, MAPPING_TYPE, CASE WHEN (RULE_ID IS NOT NULL) THEN 'Y' ELSE 'N' END IS_RULE_MAP

              FROM (

                SELECT DISTINCT tdm.DIMNAME

                ,tdm.RULE_ID

                ,NULL SRCKEY

                ,NULL TARGKEY

                ,tdm.WHERECLAUSETYPE

                ,tdm.WHERECLAUSEVALUE

                ,NULL CHANGESIGN

                ,1 SEQUENCE

                ,COALESCE(tdm.SYSTEM_GENERATED_FLAG,'N') SYSTEM_GENERATED_FLAG     

                ,NULL DATAKEY

                ,CASE

                  WHEN tdm.WHERECLAUSETYPE IS NULL THEN 1

                  ELSE 3

                END MAPPING_TYPE

                ,COALESCE(atad.CALC_SEQ,9999999999) CALC_SEQ

                FROM TDATAMAP_T tdm

                  INNER JOIN AIF_TARGET_APPL_DIMENSIONS atad ON atad.BALANCE_COLUMN_NAME = tdm.DIMNAME

                WHERE tdm.LOADID = 22751

                AND atad.APPLICATION_ID = 6

                AND tdm.PARTITIONKEY = 139

                AND tdm.TDATAMAPTYPE = 'ERP'

                AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 177)

                AND tdm.WHERECLAUSETYPE IS NULL

                UNION ALL

                SELECT tdm.DIMNAME

                ,tdm.RULE_ID

                ,tdm.SRCKEY

                ,tdm.TARGKEY

                ,tdm.WHERECLAUSETYPE

                ,tdm.WHERECLAUSEVALUE

                ,tdm.CHANGESIGN

                ,CASE tpp.PARTSEQMAP

                  WHEN 0 THEN CASE

                    WHEN (tdm.WHERECLAUSETYPE = 'BETWEEN') THEN 2

                    WHEN (tdm.WHERECLAUSETYPE = 'IN') THEN 3

                    WHEN (tdm.WHERECLAUSETYPE = 'MULTIDIM') THEN 4

                    WHEN (tdm.WHERECLAUSETYPE = 'LIKE') THEN 5

                    ELSE 0

                  END     

                  ELSE tdm.SEQUENCE

                END SEQUENCE

                ,COALESCE(tdm.SYSTEM_GENERATED_FLAG,'N') SYSTEM_GENERATED_FLAG

                ,tdm.DATAKEY

                ,CASE

                  WHEN tdm.WHERECLAUSETYPE IS NULL THEN 1

                  ELSE 3

                END MAPPING_TYPE

                ,COALESCE(atad.CALC_SEQ,9999999999) CALC_SEQ

                FROM TDATAMAP_T tdm

                  INNER JOIN TPOVPARTITION tpp ON tpp.PARTITIONKEY = tdm.PARTITIONKEY

                  INNER JOIN AIF_TARGET_APPL_DIMENSIONS atad ON atad.BALANCE_COLUMN_NAME = tdm.DIMNAME

                WHERE tdm.LOADID = 22751

                AND atad.APPLICATION_ID = 6

                AND tdm.PARTITIONKEY = 139

                AND tdm.TDATAMAPTYPE = 'ERP'

                AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 177)

                AND tdm.WHERECLAUSETYPE IN ('BETWEEN','IN','MULTIDIM','LIKE')

              ) q

              ORDER BY CALC_SEQ

              ,DIMNAME

              ,SEQUENCE

              ,RULE_ID

              ,SYSTEM_GENERATED_FLAG

              ,SRCKEY

         

      2017-11-01 21:45:27,748 INFO  [AIF]:

      Map Data for Period 'Oct-17'

      2017-11-01 21:45:27,748 DEBUG [AIF]: Comm.updateProcessDetail - START

      2017-11-01 21:45:27,748 DEBUG [AIF]:

          UPDATE AIF_PROCESS_DETAILS

          SET STATUS = 'RUNNING'

          ,RECORDS_PROCESSED = CASE

            WHEN RECORDS_PROCESSED IS NULL THEN 0

            ELSE RECORDS_PROCESSED

          END + NULL

          ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

          ,LAST_UPDATED_BY = CASE

            WHEN ('AppAdmin' IS NULL) THEN LAST_UPDATED_BY

            ELSE 'AppAdmin'

          END

          ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

          WHERE PROCESS_ID = 22751

          AND ENTITY_TYPE = 'PROCESS_BAL_TRANS'

          AND ENTITY_NAME = 'Oct-17'

         

      2017-11-01 21:45:27,748 DEBUG [AIF]: Comm.updateProcessDetail - END

      2017-11-01 21:45:27,763 DEBUG [AIF]:

            SELECT COUNT(*) ROW_COUNT

            FROM TDATASEG_T

            WHERE LOADID = 22751

           

            AND (

             

            PARTITIONKEY = 139

            AND CATKEY = 1

            AND PERIODKEY = '2017-10-31'

            AND RULE_ID = 177

              AND VALID_FLAG = 'Y'

            )

      2017-11-01 21:45:27,763 WARN  [AIF]: Warning: No records exist for Period 'Oct-17'

      2017-11-01 21:45:27,763 DEBUG [AIF]: Comm.updateProcessDetail - START

      2017-11-01 21:45:27,763 DEBUG [AIF]:

          UPDATE AIF_PROCESS_DETAILS

          SET STATUS = 'WARNING'

          ,RECORDS_PROCESSED = CASE

            WHEN RECORDS_PROCESSED IS NULL THEN 0

            ELSE RECORDS_PROCESSED

          END + NULL

          ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

          ,LAST_UPDATED_BY = CASE

            WHEN ('AppAdmin' IS NULL) THEN LAST_UPDATED_BY

            ELSE 'AppAdmin'

          END

          ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

          WHERE PROCESS_ID = 22751

          AND ENTITY_TYPE = 'PROCESS_BAL_TRANS'

          AND ENTITY_NAME = 'Oct-17'

         

      2017-11-01 21:45:27,763 DEBUG [AIF]: Comm.updateProcessDetail - END

      2017-11-01 21:45:27,779 DEBUG [AIF]: CommData.updateWorkflow - START

      2017-11-01 21:45:27,779 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME = CURRENT_TIMESTAMP

              ,PROCESSSTATUS = 2

                ,PROCESSIMP = 0

                ,BLNWCDIRTY = 0

                ,BLNLOGICDIRTY = 0

                ,BLNVALDIRTY = 0

                ,PROCESSIMPNOTE = 'Import Error'

              WHERE PARTITIONKEY = 139 AND CATKEY = 1 AND PERIODKEY = '2017-10-31' AND RULE_ID = 177

             

      2017-11-01 21:45:27,779 DEBUG [AIF]: CommData.updateWorkflow - END

      2017-11-01 21:45:27,779 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END

      2017-11-01 21:45:27,779 DEBUG [AIF]:

            UPDATE TDATASEG_T

            SET ATTR14 = DATAKEY

            WHERE LOADID = 22751 AND PARTITIONKEY = 139 AND CATKEY = 1 AND PERIODKEY = '2017-10-31'

           

      2017-11-01 21:45:27,794 DEBUG [AIF]: CommData.updateYtdAmounts - START

      2017-11-01 21:45:27,794 DEBUG [AIF]: CommData.getLedgerListAndMap - START

      2017-11-01 21:45:27,794 DEBUG [AIF]: CommData.getLedgerSQL - START

      2017-11-01 21:45:27,794 DEBUG [AIF]: CommData.getLedgerSQL - END

      2017-11-01 21:45:27,794 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 = 177

               

      2017-11-01 21:45:27,810 DEBUG [AIF]: CommData.getLedgerListAndMap - END

      2017-11-01 21:45:27,810 DEBUG [AIF]:

                  SELECT brl.PARTITIONKEY

                  ,brl.CATKEY

                  ,pprd.YEARTARGET

                  ,pprd.PERIODTARGET

                  ,pprd.SOURCE_LEDGER_ID

                  FROM AIF_BAL_RULE_LOADS brl

                  ,AIF_PROCESS_PERIODS pprd

                  WHERE brl.LOADID = 22751

                  AND pprd.PROCESS_ID = brl.LOADID

                  AND pprd.PRIOR_PERIOD_FLAG = 'N'

                  GROUP BY brl.PARTITIONKEY

                  ,brl.CATKEY

                  ,pprd.YEARTARGET

                  ,pprd.PERIODTARGET

                  ,pprd.SOURCE_LEDGER_ID

                  HAVING COUNT(*) > 1

                 

      2017-11-01 21:45:27,810 DEBUG [AIF]: CommData.updateYtdAmounts - END

      2017-11-01 21:45:27,826 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START

      2017-11-01 21:45:27,826 INFO  [AIF]:

      Stage Data for Period 'Oct-17'

      2017-11-01 21:45:27,826 DEBUG [AIF]:

              DELETE FROM TDATAMAPSEG

              WHERE PARTITIONKEY = 139

              AND CATKEY = 1

              AND PERIODKEY = '2017-10-31'

              AND (

                TDATAMAPTYPE = 'ERP'

                OR (

                  TDATAMAPTYPE = 'MULTIDIM'

                  AND EXISTS (

                    SELECT 1

                    FROM TDATAMAPSEG parent

                    WHERE parent.PARTITIONKEY = TDATAMAPSEG.PARTITIONKEY

                    AND parent.DATAKEY = TDATAMAPSEG.TARGKEY

                    AND parent.CATKEY = TDATAMAPSEG.CATKEY

                    AND parent.PERIODKEY = TDATAMAPSEG.PERIODKEY

                    AND parent.TDATAMAPTYPE = 'ERP'

                  )

                )

              )

             

      2017-11-01 21:45:27,841 INFO  [AIF]: Number of Rows deleted from TDATAMAPSEG: 184

      2017-11-01 21:45:27,841 DEBUG [AIF]:

              INSERT INTO TDATAMAPSEG (

                     DATAKEY, PARTITIONKEY, CATKEY, PERIODKEY, DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,

                     WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG

              )

              SELECT DATAKEY, PARTITIONKEY, 1, '2017-10-31', DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,

                     WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG

              FROM TDATAMAP_T

              WHERE LOADID = 22751

             

      2017-11-01 21:45:27,841 INFO  [AIF]: Number of Rows inserted into TDATAMAPSEG: 184

      2017-11-01 21:45:27,841 DEBUG [AIF]:

              DELETE FROM TDATAMAP_T

              WHERE LOADID = 22751

             

      2017-11-01 21:45:27,857 INFO  [AIF]: Number of Rows deleted from TDATAMAP_T: 184

      2017-11-01 21:45:27,857 DEBUG [AIF]:

                  DELETE FROM TDATASEG

                  WHERE LOADID < 22751

                  AND PARTITIONKEY = 139

                  AND CATKEY = 1

                  AND RULE_ID = 177

                  AND PERIODKEY = '2017-10-31'

                 

      2017-11-01 21:45:29,323 INFO  [AIF]: Number of Rows deleted from TDATASEG: 21105

      2017-11-01 21:45:29,323 DEBUG [AIF]:

                  DELETE FROM TDATAMEMOITEMS

                  WHERE PARTITIONKEY = 139

                  AND PERIODKEY = '2017-10-31'

                  AND CATKEY = 1

                  AND RULE_ID = 177

                  AND NOT EXISTS (SELECT 1

                                  FROM TDATASEG

                                  WHERE TDATASEG.DATAKEY = TDATAMEMOITEMS.DATAKEY)

                 

      2017-11-01 21:45:29,323 INFO  [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

      2017-11-01 21:45:29,323 DEBUG [AIF]:

                  DELETE FROM TDATAARCHIVE

                  WHERE PARTITIONKEY = 139

                  AND PERIODKEY = '2017-10-31'

                  AND CATKEY = 1

                  AND RULE_ID = 177

                  AND ARCHIVEPROCTYPEID = 1

                  AND NOT EXISTS ( SELECT 1

                                   FROM TDATAMEMOITEMS

                                   WHERE TDATAMEMOITEMS.MEMOITEMSD1 = TDATAARCHIVE.ARCHIVEID

                                   OR TDATAMEMOITEMS.MEMOITEMSD2 = TDATAARCHIVE.ARCHIVEID                         

                                   OR TDATAMEMOITEMS.MEMOITEMSD3 = TDATAARCHIVE.ARCHIVEID                         

                                   OR TDATAMEMOITEMS.MEMOITEMSD4 = TDATAARCHIVE.ARCHIVEID                         

                                   OR TDATAMEMOITEMS.MEMOITEMSD5 = TDATAARCHIVE.ARCHIVEID                         

                                   OR TDATAMEMOITEMS.MEMOITEMSD6 = TDATAARCHIVE.ARCHIVEID                         

                                   OR TDATAMEMOITEMS.MEMOITEMSD7 = TDATAARCHIVE.ARCHIVEID                         

                                   OR TDATAMEMOITEMS.MEMOITEMSD8 = TDATAARCHIVE.ARCHIVEID                         

                                   OR TDATAMEMOITEMS.MEMOITEMSD9 = TDATAARCHIVE.ARCHIVEID                         

                                   OR TDATAMEMOITEMS.MEMOITEMSD10 = TDATAARCHIVE.ARCHIVEID )

                 

      2017-11-01 21:45:29,339 INFO  [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

      2017-11-01 21:45:29,339 DEBUG [AIF]:

                INSERT INTO TDATASEG (

                DATAKEY, PARTITIONKEY, CATKEY, PERIODKEY,CURKEY

                ,DATAVIEW, CALCACCTTYPE, CHANGESIGN, JOURNALID

                ,AMOUNT, AMOUNTX, AMOUNT_PTD, AMOUNT_YTD

                ,DESC1, DESC2

                ,ACCOUNT, ACCOUNTX, ACCOUNTR, ACCOUNTF, ENTITY, ENTITYX, ENTITYR, ENTITYF, ICP, ICPX, ICPR, ICPF

                ,UD1, UD1X, UD1R, UD1F, UD2, UD2X, UD2R, UD2F, UD3, UD3X, UD3R, UD3F, UD4, UD4X, UD4R, UD4F

                ,UD5, UD5X, UD5R, UD5F, UD6, UD6X, UD6R, UD6F, UD7, UD7X, UD7R, UD7F, UD8, UD8X, UD8R, UD8F

                ,UD9, UD9X, UD9R, UD9F, UD10, UD10X, UD10R, UD10F, UD11, UD11X, UD11R, UD11F, UD12, UD12X, UD12R, UD12F

                ,UD13, UD13X, UD13R, UD13F, UD14, UD14X, UD14R, UD14F, UD15, UD15X, UD15R, UD15F, UD16, UD16X, UD16R, UD16F

                ,UD17, UD17X, UD17R, UD17F, UD18, UD18X, UD18R, UD18F, UD19, UD19X, UD19R, UD19F, UD20, UD20X, UD20R, UD20F

                ,ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ATTR6, ATTR7, ATTR8, ATTR9, ATTR10, ATTR11, ATTR12, ATTR13, ATTR14

                ,ARCHIVEID, HASMEMOITEM, STATICDATAKEY, LOADID, RULE_ID, CODE_COMBINATION_ID,STAT_BALANCE_FLAG, VALID_FLAG

                 )

                SELECT

                DATAKEY, PARTITIONKEY, CATKEY, PERIODKEY,CURKEY

                ,DATAVIEW, CALCACCTTYPE, CHANGESIGN, JOURNALID

                ,AMOUNT, AMOUNTX, AMOUNT_PTD, AMOUNT_YTD

                ,DESC1, DESC2

                ,ACCOUNT, ACCOUNTX, ACCOUNTR, ACCOUNTF, ENTITY, ENTITYX, ENTITYR, ENTITYF, ICP, ICPX, ICPR, ICPF

                ,UD1, UD1X, UD1R, UD1F, UD2, UD2X, UD2R, UD2F, UD3, UD3X, UD3R, UD3F, UD4, UD4X, UD4R, UD4F

                ,UD5, UD5X, UD5R, UD5F, UD6, UD6X, UD6R, UD6F, UD7, UD7X, UD7R, UD7F, UD8, UD8X, UD8R, UD8F

                ,UD9, UD9X, UD9R, UD9F, UD10, UD10X, UD10R, UD10F, UD11, UD11X, UD11R, UD11F, UD12, UD12X, UD12R, UD12F

                ,UD13, UD13X, UD13R, UD13F, UD14, UD14X, UD14R, UD14F, UD15, UD15X, UD15R, UD15F, UD16, UD16X, UD16R, UD16F

                ,UD17, UD17X, UD17R, UD17F, UD18, UD18X, UD18R, UD18F, UD19, UD19X, UD19R, UD19F, UD20, UD20X, UD20R, UD20F

                ,ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ATTR6, ATTR7, ATTR8, ATTR9, ATTR10, ATTR11, ATTR12, ATTR13, ATTR14

                ,ARCHIVEID, HASMEMOITEM, STATICDATAKEY, LOADID, RULE_ID, CODE_COMBINATION_ID,STAT_BALANCE_FLAG, VALID_FLAG

               

                FROM TDATASEG_T

                WHERE LOADID = 22751

                AND PARTITIONKEY = 139

                AND CATKEY = 1

                AND PERIODKEY = '2017-10-31'

               

      2017-11-01 21:45:29,339 INFO  [AIF]: Number of Rows inserted into TDATASEG: 0

      2017-11-01 21:45:29,339 DEBUG [AIF]:

              DELETE FROM TDATASEG_T

              WHERE LOADID = 22751

              AND PARTITIONKEY = 139

              AND CATKEY = 1

              AND PERIODKEY = '2017-10-31'

             

      2017-11-01 21:45:29,339 INFO  [AIF]: Number of Rows deleted from TDATASEG_T: 0

      2017-11-01 21:45:29,339 DEBUG [AIF]: CommData.updateWorkflow - START

      2017-11-01 21:45:29,339 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME = CURRENT_TIMESTAMP

              ,PROCESSSTATUS = 2

                ,PROCESSIMP = 0

                ,BLNWCDIRTY = 0

                ,BLNLOGICDIRTY = 0

                ,BLNVALDIRTY = 0

                ,PROCESSIMPNOTE = 'Import Error'

              WHERE PARTITIONKEY = 139 AND CATKEY = 1 AND PERIODKEY = '2017-10-31' AND RULE_ID = 177

             

      2017-11-01 21:45:29,354 DEBUG [AIF]: CommData.updateWorkflow - END

      2017-11-01 21:45:29,354 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END

      2017-11-01 21:45:29,354 DEBUG [AIF]: Comm.executeScript - START

      2017-11-01 21:45:29,354 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM/data/scripts/event/AftProcMap.py

      2017-11-01 21:45:29,354 DEBUG [AIF]: Comm.executeVBScript - START

      2017-11-01 21:45:29,354 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\data\scripts\event\AftProcMap.vbs

      2017-11-01 21:45:29,354 DEBUG [AIF]: Comm.executeVBScript - END

      2017-11-01 21:45:29,354 DEBUG [AIF]: Comm.executeScript - END

      2017-11-01 21:45:29,354 DEBUG [AIF]: CommData.mapData - END

      2017-11-01 21:45:29,401 INFO  [AIF]: -------END IMPORT STEP-------

      2017-11-01 21:45:29,448 INFO  [AIF]: -------START VALIDATE STEP-------

      2017-11-01 21:45:29,542 DEBUG [AIF]: CommData.validateData - START

      2017-11-01 21:45:29,542 DEBUG [AIF]: Comm.executeScript - START

      2017-11-01 21:45:29,542 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM/data/scripts/event/BefValidate.py

      2017-11-01 21:45:29,542 DEBUG [AIF]: Comm.executeVBScript - START

      2017-11-01 21:45:29,542 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\data\scripts\event\BefValidate.vbs

      2017-11-01 21:45:29,542 DEBUG [AIF]: Comm.executeVBScript - END

      2017-11-01 21:45:29,542 DEBUG [AIF]: Comm.executeScript - END

      2017-11-01 21:45:29,557 DEBUG [AIF]: CommMap.validateData - START

      2017-11-01 21:45:29,557 WARN  [AIF]: Warning: The Import step has not been completed for period Oct-17

      2017-11-01 21:45:29,557 DEBUG [AIF]: CommMap.validateData - END

      2017-11-01 21:45:29,557 WARN  [AIF]: Warning: The Import step has not been completed for period Oct-17

      2017-11-01 21:45:29,557 DEBUG [AIF]: Comm.executeScript - START

      2017-11-01 21:45:29,573 INFO  [AIF]: Executing the following script: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM/data/scripts/event/AftValidate.py

      2017-11-01 21:45:29,620 DEBUG [AIF]: Comm.executeVBScript - START

      2017-11-01 21:45:29,620 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\data\scripts\event\AftValidate.vbs

      2017-11-01 21:45:29,620 DEBUG [AIF]: Comm.executeVBScript - END

      2017-11-01 21:45:29,620 DEBUG [AIF]: Comm.executeScript - END

      2017-11-01 21:45:29,620 DEBUG [AIF]: CommData.validateData - END

      2017-11-01 21:45:29,713 INFO  [AIF]: -------END VALIDATE STEP-------

      2017-11-01 21:45:29,978 INFO  [AIF]: -------START EXPORT STEP-------

      2017-11-01 21:45:30,088 DEBUG [AIF]: CommData.exportData - START

      2017-11-01 21:45:30,088 DEBUG [AIF]: Comm.executeScript - START

      2017-11-01 21:45:30,088 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM/data/scripts/event/BefExportToDat.py

      2017-11-01 21:45:30,088 DEBUG [AIF]: Comm.executeVBScript - START

      2017-11-01 21:45:30,088 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\data\scripts\event\BefExportToDat.vbs

      2017-11-01 21:45:30,088 DEBUG [AIF]: Comm.executeVBScript - END

      2017-11-01 21:45:30,088 DEBUG [AIF]: Comm.executeScript - END

      2017-11-01 21:45:30,103 WARN  [AIF]: Warning: The Validate step has not been completed for period Oct-17

      2017-11-01 21:45:30,103 DEBUG [AIF]: Comm.executeVBScript - START

      2017-11-01 21:45:30,103 DEBUG [AIF]: Comm.getGlobalUserForAppAccess - START

      2017-11-01 21:45:30,103 DEBUG [AIF]:

          SELECT property_value

          FROM   aif_target_appl_properties

          WHERE  application_id = '6' and property_type = 'GLOBAL_USER_FOR_APP_ACCESS'

         

      2017-11-01 21:45:30,103 DEBUG [AIF]: GlobalUserForAppAccess from Profile:

      2017-11-01 21:45:30,119 DEBUG [AIF]: Resolved user name for application access: AppAdmin

      2017-11-01 21:45:30,119 DEBUG [AIF]: Comm.getGlobalUserForAppAccess - END

      2017-11-01 21:45:30,119 INFO  [AIF]: Executing the following script: D:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\bin\HFM_EXPORT.vbs

      2017-11-01 21:45:30,119 DEBUG [AIF]: The command to be executed is:

      cscript D:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\bin\HFM_EXPORT.vbs "22751" "****" "D%3A%5COracle%5CMiddleware%5Cuser_projects%5CFDM1" "%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35" "SQLOLEDB"

      Microsoft (R) Windows Script Host Version 5.8

      Copyright (C) Microsoft Corporation. All rights reserved.

       

       

      Adapter created.

      Adapter Initialized successfully.

      Connected to PRD1HFM

      POV-DataValue: <Entity Currency>

      Filename = \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\Outbox\PRD1HFM_22751.dat

      ***Export data and journals***

      PageSize = 100000

      Total RecordCount = 0

      Page 1: Recordcount = 0

      No data to export

      Protection is on

      Disconnected from PRD1HFM

      2017-11-01 21:45:38,418 DEBUG [AIF]: Comm.executeVBScript - END

      2017-11-01 21:45:38,418 DEBUG [AIF]: Comm.executeScript - START

      2017-11-01 21:45:38,418 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM/data/scripts/event/AftExportToDat.py

      2017-11-01 21:45:38,418 DEBUG [AIF]: Comm.executeVBScript - START

      2017-11-01 21:45:38,418 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\data\scripts\event\AftExportToDat.vbs

      2017-11-01 21:45:38,418 DEBUG [AIF]: Comm.executeVBScript - END

      2017-11-01 21:45:38,434 DEBUG [AIF]: Comm.executeScript - END

      2017-11-01 21:45:38,434 DEBUG [AIF]: CommData.exportData - END

      2017-11-01 21:45:38,590 DEBUG [AIF]: HfmData.loadData - START

      2017-11-01 21:45:38,590 DEBUG [AIF]: Comm.executeScript - START

      2017-11-01 21:45:38,605 INFO  [AIF]: Executing the following script: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM/data/scripts/event/BefLoad.py

      2017-11-01 21:45:38,636 INFO  [AIF]: Previous load file: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\outbox/PRD1HFM_22740.dat.bak

      2017-11-01 21:45:38,636 INFO  [AIF]: Current load file to modify: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\outbox/PRD1HFM_22751.dat

      2017-11-01 21:45:38,636 INFO  [AIF]: Creation of temporary file: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\outbox/PRD1HFM_22751_TEMP.dat

      2017-11-01 21:45:38,636 INFO  [AIF]: Begin: Reading Previous load file, Replacing data with NODATA and saving the changes in the temporary file

      2017-11-01 21:45:40,025 INFO  [AIF]: Finished: Reading Previous load file, Replacing data with NODATA and saving the changes in the temporary file

      2017-11-01 21:45:40,025 INFO  [AIF]: Begin: Reading current load file and importing all these lines into the temporary file

      2017-11-01 21:45:40,025 INFO  [AIF]: Finished: Reading current load file and importing all these lines into the temporary file

      2017-11-01 21:45:40,025 INFO  [AIF]: Renamed current load id file as xxx.dat.bak

      2017-11-01 21:45:40,025 INFO  [AIF]: Renamed temp as current load file

      2017-11-01 21:45:40,025 DEBUG [AIF]: Comm.executeVBScript - START

      2017-11-01 21:45:40,025 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\data\scripts\event\BefLoad.vbs

      2017-11-01 21:45:40,025 DEBUG [AIF]: Comm.executeVBScript - END

      2017-11-01 21:45:40,025 DEBUG [AIF]: Comm.executeScript - END

      2017-11-01 21:45:40,025 DEBUG [AIF]: CommData.getRuleInfo - START

      2017-11-01 21:45:40,025 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 = 22751

             

      2017-11-01 21:45:40,040 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 = 6

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

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

           

            ORDER BY adim.BALANCE_COLUMN_NAME

           

      2017-11-01 21:45:40,040 DEBUG [AIF]: {'APPLICATION_ID': 6L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'JE_DW_HFM', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\FDM1', 'CATKEY': 1L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'OTHERS', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'PRD1HFM', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 3L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': None, 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'AppAdmin', 'DIMNAME_MAP': {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': 20L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', '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'ICP', 'DIMENSION_ID': 23L}, 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': 19L}, 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': 22L}, 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': 17L}, u'UD1': {'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'UD1', 'DIMENSION_ID': 21L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 139L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': u'SNAPSHOT', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': None, 'IMPGROUPFILETYPE': u'ODI', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 177L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'Y', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://HYPPRDAPPFDM01:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 6L, 'IMPTARGETSOURCESYSTEMID': 0L}

      2017-11-01 21:45:40,040 DEBUG [AIF]: CommData.getRuleInfo - END

      2017-11-01 21:45:40,040 DEBUG [AIF]: CommData.getPovList - START

      2017-11-01 21:45:40,040 DEBUG [AIF]:

              SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY

              ,COALESCE(pp.PERIODDESC, CONVERT(VARCHAR,pprd.PERIODKEY,120)) PERIODDESC

              ,brl.RULE_ID, br.RULE_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

              FROM AIF_BAL_RULE_LOADS brl

              INNER JOIN AIF_BALANCE_RULES br

                ON br.RULE_ID = brl.RULE_ID

              INNER JOIN TPOVPARTITION part

                ON part.PARTITIONKEY = brl.PARTITIONKEY

              INNER JOIN TPOVCATEGORY cat

                ON cat.CATKEY = brl.CATKEY

              INNER JOIN AIF_PROCESS_PERIODS pprd

                ON pprd.PROCESS_ID = brl.LOADID

             

                LEFT OUTER JOIN TPOVPERIODADAPTOR pp

                  ON pp.PERIODKEY = pprd.PERIODKEY

                  AND pp.INTSYSTEMKEY = 'PRD1HFM'

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

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

           

      2017-11-01 21:45:40,056 DEBUG [AIF]: CommData.getPovList - END

      2017-11-01 21:45:40,056 DEBUG [AIF]: CommData.updateWorkflow - START

      2017-11-01 21:45:40,056 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 = 139

          AND tlp.CATKEY = 1

          AND tlp.PERIODKEY = '2017-10-31'

          AND tlp.RULE_ID = 177

          AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

         

      2017-11-01 21:45:40,056 FATAL [AIF]: Error in CommData.updateWorkflow

      Traceback (most recent call last):

        File "<string>", line 2496, in updateWorkflow

      RuntimeError: The Current Process Status 'Import Error' is Invalid (JE_DW_HFM ,Actual, Oct-17, JE_DW_HFM)

       

       

      2017-11-01 21:45:40,056 FATAL [AIF]: Error in HfmData.loadData

      Traceback (most recent call last):

        File "<string>", line 34, in loadData

        File "<string>", line 2496, in updateWorkflow

      RuntimeError: The Current Process Status 'Import Error' is Invalid (JE_DW_HFM ,Actual, Oct-17, JE_DW_HFM)

       

       

      2017-11-01 21:45:40,056 DEBUG [AIF]: CommData.updateWorkflow - START

      2017-11-01 21:45:40,056 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME = CURRENT_TIMESTAMP

              ,PROCESSSTATUS = 32

                ,PROCESSENTLOAD = 0

                ,PROCESSENTLOADNOTE = 'Load Error'

              WHERE PARTITIONKEY = 139 AND CATKEY = 1 AND PERIODKEY = '2017-10-31' AND RULE_ID = 177

             

      2017-11-01 21:45:40,072 DEBUG [AIF]: CommData.updateWorkflow - END

      2017-11-01 21:45:40,072 DEBUG [AIF]: Comm.executeScript - START

      2017-11-01 21:45:40,087 INFO  [AIF]: Executing the following script: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM/data/scripts/event/AftLoad.py

      2017-11-01 21:45:40,118 DEBUG [AIF]: Comm.executeVBScript - START

      2017-11-01 21:45:40,118 DEBUG [AIF]: The following script does not exist: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM\data\scripts\event\AftLoad.vbs

      2017-11-01 21:45:40,118 DEBUG [AIF]: Comm.executeVBScript - END

      2017-11-01 21:45:40,118 DEBUG [AIF]: Comm.executeScript - END

      2017-11-01 21:45:40,118 DEBUG [AIF]:

          SELECT COALESCE(usr.PROFILE_OPTION_VALUE, app.PROFILE_OPTION_VALUE, site.PROFILE_OPTION_VALUE) PROFILE_OPTION_VALUE

          FROM AIF_PROFILE_OPTIONS po

          LEFT OUTER JOIN AIF_PROFILE_OPTION_VALUES site

            ON site.PROFILE_OPTION_NAME = po.PROFILE_OPTION_NAME

            AND site.LEVEL_ID = 1000

            AND site.LEVEL_VALUE = 0

            AND site.LEVEL_ID <= po.MAX_LEVEL_ID

          LEFT OUTER JOIN AIF_PROFILE_OPTION_VALUES app

            ON app.PROFILE_OPTION_NAME = po.PROFILE_OPTION_NAME

            AND app.LEVEL_ID = 1005

            AND app.LEVEL_VALUE = 6

            AND app.LEVEL_ID <= po.MAX_LEVEL_ID

          LEFT OUTER JOIN AIF_PROFILE_OPTION_VALUES usr

            ON usr.PROFILE_OPTION_NAME = po.PROFILE_OPTION_NAME

            AND usr.LEVEL_ID = 1010

            AND usr.LEVEL_VALUE = NULL

            AND usr.LEVEL_ID <= po.MAX_LEVEL_ID

          WHERE po.PROFILE_OPTION_NAME = 'PROFILE_APP_ROOT_DIRECTORY'

         

      2017-11-01 21:45:40,134 DEBUG [AIF]: HFM logFile : \\HYPPRDAPPFDM01\FDMEE\PRD1HFM/outbox/logs/PRD1HFM_22751_HFM.log

      2017-11-01 21:45:40,134 DEBUG [AIF]: HFM Log File not found: \\HYPPRDAPPFDM01\FDMEE\PRD1HFM/outbox/logs/PRD1HFM_22751_HFM.log

      2017-11-01 21:45:40,259 DEBUG [AIF]: Comm.finalizeProcess - START

      2017-11-01 21:45:40,259 DEBUG [AIF]: CommData.updateRuleStatus - START

      2017-11-01 21:45:40,259 DEBUG [AIF]:

          UPDATE AIF_BALANCE_RULES

          SET STATUS = CASE 'FAILED'

            WHEN 'SUCCESS' THEN

              CASE (

                SELECT COUNT(*)

                FROM AIF_PROCESS_DETAILS pd

                WHERE pd.PROCESS_ID = 22751

                AND pd.STATUS IN ('FAILED','WARNING')

              )

              WHEN 0 THEN 'SUCCESS'

              ELSE (

                SELECT MIN(pd.STATUS)

                FROM AIF_PROCESS_DETAILS pd

                WHERE pd.PROCESS_ID = 22751

                AND pd.STATUS IN ('FAILED','WARNING')

              )

              END

            ELSE 'FAILED'

          END

          WHERE RULE_ID = 177

         

      2017-11-01 21:45:40,274 DEBUG [AIF]: CommData.updateRuleStatus - END

      2017-11-01 21:45:40,274 FATAL [AIF]: Error in HFM Load Data

      2017-11-01 21:45:40,274 DEBUG [AIF]: Comm.updateProcess - START

      2017-11-01 21:45:40,274 DEBUG [AIF]: Comm.updateProcess - END

      2017-11-01 21:45:40,290 DEBUG [AIF]: The fdmAPI connection has been closed.

      2017-11-01 21:45:40,290 INFO  [AIF]: FDMEE Process End, Process ID: 22751