1 Reply Latest reply on Feb 21, 2017 1:41 PM by SH_INT

    FDMEE Import failed

    3390309

      Hi All,

       

      Im getting import failed  and im trying import from ebs system. Pls see the error log. Thanks

       

      2017-02-20 13:17:15,114 INFO  [AIF]: FDMEE Process Start, Process ID: 637

      2017-02-20 13:17:15,114 INFO  [AIF]: FDMEE Logging Level: 5

      2017-02-20 13:17:15,114 INFO  [AIF]: FDMEE Log File: \\Devhap\FDMEE\outbox\logs\TndCON_637.log

      2017-02-20 13:17:15,114 INFO  [AIF]: User:hypadmin

      2017-02-20 13:17:15,115 INFO  [AIF]: Location:Tnd (Partitionkey:36)

      2017-02-20 13:17:15,115 INFO  [AIF]: Period Name:Mar-16 (Period Key:3/31/16 12:00 AM)

      2017-02-20 13:17:15,115 INFO  [AIF]: Category Name:Statutory (Category key:3)

      2017-02-20 13:17:15,115 INFO  [AIF]: Rule Name:Tnd (Rule ID:27)

      2017-02-20 13:17:16,386 INFO  [AIF]: FDM Version: 11.1.2.3.700

      2017-02-20 13:17:16,386 INFO  [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

      [Oracle JRockit(R) (Oracle Corporation)]

      2017-02-20 13:17:16,386 INFO  [AIF]: Java Platform: java1.6.0_37

      2017-02-20 13:17:16,386 INFO  [AIF]: Log File Encoding: UTF-8

      2017-02-20 13:17:18,473 INFO  [AIF]: -------START IMPORT STEP-------

      2017-02-20 13:17:18,512 DEBUG [AIF]: CommData.preImportData - START

      2017-02-20 13:17:18,518 DEBUG [AIF]: CommData.getRuleInfo - START

      2017-02-20 13:17:18,520 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 = 637

             

      2017-02-20 13:17:18,524 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 = 2

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

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

           

            ORDER BY adim.BALANCE_COLUMN_NAME

           

      2017-02-20 13:17:18,527 DEBUG [AIF]: {'APPLICATION_ID': 2L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'Tnd', 'ACTUAL_FLAG': u'A', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 3L, 'BAL_SEG_VALUE_OPTION_CODE': u'ALL', 'INCLUDE_ADJ_PERIODS_FLAG': u'Y', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'EBS_R12', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'rapApp', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 5L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': u'22', 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 101L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'hypadmin', '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': 6L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT3', 'COA_SEGMENT_NAME2': u'SEGMENT2', 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 8L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT1', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 3L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT4', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 5L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 7L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT3', 'COA_SEGMENT_NAME2': u'SEGMENT2', 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 1L}, 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': 4L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 36L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'SINGLE', 'INCLUDE_ZERO_BALANCE_FLAG': u'Z', 'EXECUTION_MODE': u'FULLREFRESH', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'ERPI', 'BALANCE_AMOUNT_IS': u'YTD', 'RULE_ID': 27L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': u'STANDARD', 'SIGNAGE_METHOD': u'SAME', 'WEB_SERVICE_URL': u'http://devhapp.com.kw:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 2L, 'IMPTARGETSOURCESYSTEMID': 0L}

      2017-02-20 13:17:18,527 DEBUG [AIF]: CommData.getRuleInfo - END

      2017-02-20 13:17:18,545 DEBUG [AIF]: CommData.insertPeriods - START

      2017-02-20 13:17:18,547 DEBUG [AIF]: CommData.getLedgerListAndMap - START

      2017-02-20 13:17:18,548 DEBUG [AIF]: CommData.getLedgerSQL - START

      2017-02-20 13:17:18,548 DEBUG [AIF]: CommData.getLedgerSQL - END

      2017-02-20 13:17:18,548 DEBUG [AIF]:

                SELECT l.SOURCE_LEDGER_ID

                ,l.SOURCE_LEDGER_NAME

                ,l.SOURCE_COA_ID

                ,l.CALENDAR_ID

                ,'0' SETID

                ,l.PERIOD_TYPE

                ,NULL LEDGER_TABLE_NAME

                FROM AIF_BALANCE_RULES br

                ,AIF_COA_LEDGERS l

                WHERE br.RULE_ID = 27

                AND l.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID

                AND l.SOURCE_LEDGER_ID = br.SOURCE_LEDGER_ID

               

      2017-02-20 13:17:18,549 DEBUG [AIF]: CommData.getLedgerListAndMap - END

      2017-02-20 13:17:18,551 DEBUG [AIF]: doAppPeriodMappingsExist - tnd: N

      2017-02-20 13:17:18,551 DEBUG [AIF]: Period mapping section: ERPI/DEFAULT

      2017-02-20 13:17:18,551 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

      2017-02-20 13:17:18,552 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,0) GL_PERIOD_YEAR

                      ,COALESCE(prd.PERIOD_NUM,0) GL_PERIOD_NUM

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

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

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

                      ,pp.YEARTARGET YEARTARGET

                      ,pp.PERIODTARGET PERIODTARGET

                      ,'PROCESS_BAL_IMP' IMP_ENTITY_TYPE

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

                      ,COALESCE(prd.PERIOD_NAME,'0') IMP_ENTITY_NAME

                      ,'PROCESS_BAL_TRANS' TRANS_ENTITY_TYPE

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

                      ,pp.PERIODDESC TRANS_ENTITY_NAME

                      ,'N' PRIOR_PERIOD_FLAG

                      ,22 SOURCE_LEDGER_ID

                      FROM (

                        AIF_BAL_RULE_LOADS brl

                        INNER JOIN TPOVCATEGORY pc

                          ON pc.CATKEY = brl.CATKEY

                     

                        INNER JOIN TPOVPERIOD_FLAT_V pp

                          ON pp.PERIODFREQ = pc.CATFREQ

                          AND pp.PERIODKEY >= brl.START_PERIODKEY

                          AND pp.PERIODKEY <= brl.END_PERIODKEY

                      )

                      INNER JOIN AIF_GL_PERIODS_STG prd

                        ON prd.SOURCE_SYSTEM_ID = 5

                        AND prd.CALENDAR_ID IN ('10003')

                       

                AND prd.SETID = '0'

                AND prd.PERIOD_TYPE = '1'

               

                        AND prd.ADJUSTMENT_PERIOD_FLAG = 'N'

                        AND prd.START_DATE > pp.PRIORPERIODKEY

                        AND prd.START_DATE <= pp.PERIODKEY

                      WHERE brl.LOADID = 637

                      ORDER BY pp.PERIODKEY

                      ,GL_EFFECTIVE_PERIOD_NUM

                     

      2017-02-20 13:17:18,552 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', 'PROCESS_BAL_TRANS', 22L, 5L, u'10003', u'0', u'1', 'N', 637]

      2017-02-20 13:17:18,555 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, 'Y') 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') 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

                      ,22 SOURCE_LEDGER_ID

                      FROM (

                        AIF_BAL_RULE_LOADS brl

                        INNER JOIN TPOVCATEGORY pc

                          ON pc.CATKEY = brl.CATKEY

                     

                        INNER JOIN TPOVPERIOD_FLAT_V pp

                          ON pp.PERIODFREQ = pc.CATFREQ

                          AND pp.PERIODKEY >= brl.START_PERIODKEY

                          AND pp.PERIODKEY <= brl.END_PERIODKEY

                      )

                      INNER JOIN TPOVPERIODSOURCE ppsrc

                        ON ppsrc.PERIODKEY = pp.PERIODKEY

                        AND ppsrc.MAPPING_TYPE = 'ADJUSTMENT'

                        AND ppsrc.SOURCE_SYSTEM_ID = 5

                        AND ppsrc.CALENDAR_ID IN ('10003')

                      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.SETID = '0'

                AND prd.PERIOD_TYPE = '1'

               

                        AND prd.ADJUSTMENT_PERIOD_FLAG = 'Y'

                      WHERE brl.LOADID = 637

                      ORDER BY pp.PERIODKEY

                      ,GL_EFFECTIVE_PERIOD_NUM

                     

      2017-02-20 13:17:18,555 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', 'PROCESS_BAL_TRANS', 22L, 'ADJUSTMENT', 5L, u'10003', u'0', u'1', 'Y', 637]

      2017-02-20 13:17:18,557 DEBUG [AIF]: CommData.insertPeriods - END

      2017-02-20 13:17:18,559 DEBUG [AIF]: CommData.getPovList - START

      2017-02-20 13:17:18,560 DEBUG [AIF]:

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

              ,COALESCE(pp.PERIODDESC, TO_CHAR(pprd.PERIODKEY,'YYYY-MM-DD HH24:MI:SS')) PERIODDESC

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

              FROM AIF_BAL_RULE_LOADS brl

              INNER JOIN AIF_BALANCE_RULES br

                ON br.RULE_ID = brl.RULE_ID

              INNER JOIN TPOVPARTITION part

                ON part.PARTITIONKEY = brl.PARTITIONKEY

              INNER JOIN TPOVCATEGORY cat

                ON cat.CATKEY = brl.CATKEY

              INNER JOIN AIF_PROCESS_PERIODS pprd

                ON pprd.PROCESS_ID = brl.LOADID

             

                LEFT OUTER JOIN TPOVPERIOD pp

                  ON pp.PERIODKEY = pprd.PERIODKEY

              LEFT OUTER JOIN TLOGPROCESS tlp

                ON tlp.PARTITIONKEY = brl.PARTITIONKEY

                AND tlp.CATKEY = brl.CATKEY

                AND tlp.PERIODKEY = pprd.PERIODKEY

                AND tlp.RULE_ID = brl.RULE_ID

              WHERE brl.LOADID = 637

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

           

      2017-02-20 13:17:18,560 DEBUG [AIF]: CommData.getPovList - END

      2017-02-20 13:17:18,562 DEBUG [AIF]: CommData.insertImportProcessDetails - START

      2017-02-20 13:17:18,562 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

                ,'AIF_EBS_GL_BALANCES_STG' TARGET_TABLE_NAME

                ,CURRENT_TIMESTAMP EXECUTION_START_TIME

                ,NULL EXECUTION_END_TIME

                ,0 RECORDS_PROCESSED

                ,'PENDING' STATUS

                ,'hypadmin' 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 = 637

                ) q

                ORDER BY ENTITY_NAME_ORDER

               

      2017-02-20 13:17:18,564 DEBUG [AIF]: CommData.insertImportProcessDetails - END

      2017-02-20 13:17:18,570 DEBUG [AIF]: Comm.doScriptInit - START

      2017-02-20 13:17:18,610 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=\\devhap\FDMEE\inbox, LOCNAME=tnd, SOURCENAME=tnd_EBS_SYSTEM, APPID=2, SOURCEID=5, APPROOTDIR=\\tnd-hfm-prd2\FDMEE, IMPORTFORMAT=Tnd_SR, SCRIPTSDIR=\\Tnd-hfm-prd2\FDMEE\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=27, CATNAME=Statutory, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=637, PERIODNAME=Mar-16, IMPORTMODE=FULLREFRESH, SOURCETYPE=EBS_R12, PERIODKEY=2016-03-31, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=TndCON, LOCKEY=36, RULENAME=Tnd_SR, OUTBOXDIR=\\Tnd-hfm-prd2\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=3, USERNAME=hypadmin, FILEDIR=null, IMPORTFLAG=Y, USERLOCALE=en}

      2017-02-20 13:17:18,613 DEBUG [AIF]: The executeEventScript is set to: YES

      2017-02-20 13:17:18,614 DEBUG [AIF]: The AppRootFolder is set to: \\Tnd-hfm-prd2\FDMEE

      2017-02-20 13:17:18,614 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

      2017-02-20 13:17:18,614 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

      2017-02-20 13:17:18,614 DEBUG [AIF]: Comm.doScriptInit - END

      2017-02-20 13:17:18,614 DEBUG [AIF]: Comm.executeScript - START

      2017-02-20 13:17:18,615 DEBUG [AIF]: The following script does not exist: \\Tnd-hfm-prd2\FDMEE/data/scripts/event/BefImport.py

      2017-02-20 13:17:18,618 DEBUG [AIF]: Comm.executeVBScript - START

      2017-02-20 13:17:18,618 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

      2017-02-20 13:17:18,619 DEBUG [AIF]: The following script does not exist: \\Tnd-hfm-prd2\FDMEE\data\scripts\event\BefImport.vbs

      2017-02-20 13:17:18,619 DEBUG [AIF]: Comm.executeVBScript - END

      2017-02-20 13:17:18,619 DEBUG [AIF]: Comm.executeScript - END

      2017-02-20 13:17:18,619 DEBUG [AIF]: CommData.preImportData - END

      2017-02-20 13:17:21,592 DEBUG [AIF]: LKM EBS/FS Extract Type - Load Audit and Full Refresh - START

      2017-02-20 13:17:21,593 DEBUG [AIF]:

              SELECT p.PROCESS_ID

              ,br.RULE_NAME

              ,l.SOURCE_LEDGER_NAME

              FROM AIF_GL_LOAD_AUDIT aud

              ,AIF_PROCESSES p

              ,AIF_BALANCE_RULES br

              ,AIF_COA_LEDGERS l

              WHERE aud.SOURCE_SYSTEM_ID = 5

              AND aud.SOURCE_LEDGER_ID = 22

              AND aud.GL_PERIOD_ID = 2228

              AND aud.BALANCE_TYPE = 'A'

              AND p.PROCESS_ID = aud.LAST_LOADID

              AND p.STATUS = 'RUNNING'

              AND p.PROCESS_ID <> 637

              AND br.RULE_ID = p.RULE_ID

              AND l.SOURCE_SYSTEM_ID = aud.SOURCE_SYSTEM_ID

              AND l.SOURCE_LEDGER_ID = aud.SOURCE_LEDGER_ID

             

      2017-02-20 13:17:21,594 DEBUG [AIF]:

                  SELECT 'Y' VALID_FLAG

                  FROM GL_PERIOD_STATUSES

                  WHERE APPLICATION_ID = 101

                  AND LEDGER_ID = 22

                  AND PERIOD_NAME = 'Mar-2016'

                  AND CLOSING_STATUS IN ('O','C','P')

                 

      2017-02-20 13:17:21,595 DEBUG [AIF]:

                  SELECT 'Y' EXISTS_FLAG

                  FROM GL_TRACK_DELTA_BALANCES

                  WHERE LEDGER_ID = 22

                  AND PROGRAM_CODE = 'FEM'

                  AND PERIOD_NAME = 'Mar-2016'

                  AND ACTUAL_FLAG = 'A'

                  AND EXTRACT_LEVEL_CODE = 'DTL'

                  AND CURRENCY_TYPE_CODE = 'B'

                  AND ENABLED_FLAG = 'Y'

                 

      2017-02-20 13:17:21,596 DEBUG [AIF]:

                SELECT MAX(DELTA_RUN_ID) MAX_DELTA_RUN_ID

                FROM GL_BALANCES_DELTA

                WHERE LEDGER_ID = 22

                AND PERIOD_NAME = 'Mar-2016'

                AND ACTUAL_FLAG = 'A'

               

      2017-02-20 13:17:21,599 DEBUG [AIF]:

              SELECT brl.EXECUTION_MODE

              ,(SELECT CASE COUNT(aud.DELTA_RUN_ID) WHEN 0 THEN 'N' ELSE 'Y' END

                FROM AIF_GL_LOAD_AUDIT aud

                WHERE aud.SOURCE_SYSTEM_ID = 5

                AND aud.SOURCE_LEDGER_ID = 22

                AND aud.GL_PERIOD_ID = 2228

                AND aud.BALANCE_TYPE = 'A'

                AND aud.LAST_LOADID <> brl.LOADID

                AND COALESCE(aud.STATUS, 'SUCCESS') = 'SUCCESS'

              ) GL_LOAD_AUDIT_SUCCESS_FLAG

              ,(SELECT CASE COUNT(aud.DELTA_RUN_ID) WHEN 0 THEN 'N' ELSE 'Y' END

                FROM AIF_GL_LOAD_AUDIT aud

                WHERE aud.SOURCE_SYSTEM_ID = 5

                AND aud.SOURCE_LEDGER_ID = 22

                AND aud.GL_PERIOD_ID = 2228

                AND aud.BALANCE_TYPE = 'A'

                AND aud.LAST_LOADID <> brl.LOADID

                AND aud.STATUS = 'RUNNING'

              ) GL_LOAD_AUDIT_RUNNING_FLAG

              FROM AIF_BAL_RULE_LOADS brl

              WHERE brl.LOADID = 637

             

      2017-02-20 13:17:21,600 DEBUG [AIF]: 

              INSERT INTO AIF_GL_LOAD_AUDIT (

                LAST_LOADID

                ,DELTA_RUN_ID

                ,SOURCE_SYSTEM_ID

                ,SOURCE_LEDGER_ID

                ,GL_PERIOD_ID

                ,BALANCE_TYPE

                ,GL_EXTRACT_TYPE

                ,STATUS

              ) VALUES (

                637

                ,0

                ,5

                ,22

                ,2228

                ,'A'

                ,'FULLREFRESH'

                ,'RUNNING'

              )

             

      2017-02-20 13:17:21,601 DEBUG [AIF]:

                DELETE FROM AIF_EBS_GL_BALANCES_STG

                WHERE SOURCE_SYSTEM_ID = 5

                AND SOURCE_COA_ID = 101

                AND SOURCE_LEDGER_ID = 22

                AND ACTUAL_FLAG = 'A'

                AND PERIOD_NAME = 'Mar-2016'

               

      2017-02-20 13:17:21,911 DEBUG [AIF]: LKM EBS/FS Extract Type - Load Audit and Full Refresh - END

      2017-02-20 13:17:21,939 DEBUG [AIF]:

      EBS/FS GL Load Print Variables

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

      p_process_id: 637

      p_sql_db_type: ORACLE

      p_rule_id: 27

      p_source_system_id: 5

      p_application_id: 2

      p_target_application_type: HFM

       

      p_data_load_method: CLASSIC_VIA_EPMI

      p_bal_balance_method_code: STANDARD

      p_bal_ledger_group_code: SINGLE

      p_bal_amount_type: MONETARY

      p_prd_entity_name: Mar-2016

      p_prd_period_id: 2228

      p_prd_gl_period_name: Mar-2016

      p_prd_source_ledger_id: 22

      p_prd_source_coa_id: 101

      p_source_ledger_id: 22

      p_source_coa_id: 101

       

      p_bal_actual_flag: A

      p_bal_gl_extract_type: FULLREFRESH

       

      2017-02-20 13:17:26,265 DEBUG [AIF]: Comm.updateProcessDetail - START

      2017-02-20 13:17:26,266 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 ('hypadmin' IS NULL) THEN LAST_UPDATED_BY

            ELSE 'hypadmin'

          END

          ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

          WHERE PROCESS_ID = 637

          AND ENTITY_TYPE = 'PROCESS_BAL_IMP'

          AND ENTITY_NAME = 'Mar-2016'

         

      2017-02-20 13:17:26,267 DEBUG [AIF]: Comm.updateProcessDetail - END

      2017-02-20 13:17:26,347 DEBUG [AIF]: EbsData.postImportData - START

      2017-02-20 13:17:26,349 DEBUG [AIF]: CommData.postImportData - START

      2017-02-20 13:17:26,354 DEBUG [AIF]: CommData.getRuleInfo - START

      2017-02-20 13:17:26,355 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 = 637

             

      2017-02-20 13:17:26,358 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 = 2

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

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

           

            ORDER BY adim.BALANCE_COLUMN_NAME

           

      2017-02-20 13:17:26,359 DEBUG [AIF]: {'APPLICATION_ID': 2L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'Tnd_SR', 'ACTUAL_FLAG': u'A', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 3L, 'BAL_SEG_VALUE_OPTION_CODE': u'ALL', 'INCLUDE_ADJ_PERIODS_FLAG': u'Y', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'EBS_R12', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'TndCON', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 5L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': u'22', 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 101L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'hypadmin', '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': 6L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT3', 'COA_SEGMENT_NAME2': u'SEGMENT2', 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 8L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT1', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 3L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT4', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 5L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 7L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT3', 'COA_SEGMENT_NAME2': u'SEGMENT2', 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 1L}, 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': 4L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 36L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'SINGLE', 'INCLUDE_ZERO_BALANCE_FLAG': u'Z', 'EXECUTION_MODE': u'FULLREFRESH', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'ERPI', 'BALANCE_AMOUNT_IS': u'YTD', 'RULE_ID': 27L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': u'STANDARD', 'SIGNAGE_METHOD': u'SAME', 'WEB_SERVICE_URL': u'http://Tnd-HFM-Prd2.Tnd.com.kw:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 2L, 'IMPTARGETSOURCESYSTEMID': 0L}

      2017-02-20 13:17:26,360 DEBUG [AIF]: CommData.getRuleInfo - END

      2017-02-20 13:17:26,360 DEBUG [AIF]: CommData.postImportData - END

      2017-02-20 13:17:26,379 DEBUG [AIF]: EBS/FS Load Data - Load TDATASEG_T - START

      2017-02-20 13:17:26,382 DEBUG [AIF]: CommData.getLedgerListAndMap - START

      2017-02-20 13:17:26,383 DEBUG [AIF]: CommData.getLedgerSQL - START

      2017-02-20 13:17:26,383 DEBUG [AIF]: CommData.getLedgerSQL - END

      2017-02-20 13:17:26,384 DEBUG [AIF]:

                SELECT l.SOURCE_LEDGER_ID

                ,l.SOURCE_LEDGER_NAME

                ,l.SOURCE_COA_ID

                ,l.CALENDAR_ID

                ,'0' SETID

                ,l.PERIOD_TYPE

                ,NULL LEDGER_TABLE_NAME

                FROM AIF_BALANCE_RULES br

                ,AIF_COA_LEDGERS l

                WHERE br.RULE_ID = 27

                AND l.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID

                AND l.SOURCE_LEDGER_ID = br.SOURCE_LEDGER_ID

               

      2017-02-20 13:17:26,385 DEBUG [AIF]: CommData.getLedgerListAndMap - END

      2017-02-20 13:17:26,387 DEBUG [AIF]: CommData.getPovList - START

      2017-02-20 13:17:26,389 DEBUG [AIF]: doAppPeriodMappingsExist - TndCON: N

      2017-02-20 13:17:26,389 DEBUG [AIF]:

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

              ,COALESCE(pp.PERIODDESC, TO_CHAR(pprd.PERIODKEY,'YYYY-MM-DD HH24:MI:SS')) PERIODDESC

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

              FROM AIF_BAL_RULE_LOADS brl

              INNER JOIN AIF_BALANCE_RULES br

                ON br.RULE_ID = brl.RULE_ID

              INNER JOIN TPOVPARTITION part

                ON part.PARTITIONKEY = brl.PARTITIONKEY

              INNER JOIN TPOVCATEGORY cat

                ON cat.CATKEY = brl.CATKEY

              INNER JOIN AIF_PROCESS_PERIODS pprd

                ON pprd.PROCESS_ID = brl.LOADID

             

                LEFT OUTER JOIN TPOVPERIOD pp

                  ON pp.PERIODKEY = pprd.PERIODKEY

              LEFT OUTER JOIN TLOGPROCESS tlp

                ON tlp.PARTITIONKEY = brl.PARTITIONKEY

                AND tlp.CATKEY = brl.CATKEY

                AND tlp.PERIODKEY = pprd.PERIODKEY

                AND tlp.RULE_ID = brl.RULE_ID

              WHERE brl.LOADID = 637

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

           

      2017-02-20 13:17:26,390 DEBUG [AIF]: CommData.getPovList - END

      2017-02-20 13:17:26,391 INFO  [AIF]:

      Import Data from Source for Period 'Mar-16'

      2017-02-20 13:17:26,396 DEBUG [AIF]: CommData.updateWorkflow - START

      2017-02-20 13:17:26,396 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 = 36

          AND tlp.CATKEY = 3

          AND tlp.PERIODKEY = '2016-03-31'

          AND tlp.RULE_ID = 27

          AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

         

      2017-02-20 13:17:26,397 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 = 36 AND CATKEY = 3 AND PERIODKEY = '2016-03-31' AND RULE_ID = 27

             

      2017-02-20 13:17:26,398 DEBUG [AIF]: CommData.updateWorkflow - END

      2017-02-20 13:17:26,398 INFO  [AIF]:

          Import Data from Source for Ledger 'Tnd Operations01 SOB'

      2017-02-20 13:17:26,399 DEBUG [AIF]:

                  SELECT COA_SEGMENT_NAME

                  ,ACCOUNT_TYPE_FLAG

                  ,BALANCE_TYPE_FLAG

                  FROM AIF_COA_SEGMENTS

                  WHERE SOURCE_SYSTEM_ID = 5

                  AND SOURCE_COA_ID = '101'

                  AND (

                    ACCOUNT_TYPE_FLAG = 'Y'

                    OR BALANCE_TYPE_FLAG = 'Y'

                  )

                 

      2017-02-20 13:17:26,399 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 = 2

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

                  AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                  AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                 

                  ORDER BY adim.BALANCE_COLUMN_NAME

                 

      2017-02-20 13:17:26,403 DEBUG [AIF]:

                  INSERT INTO TDATASEG_T (

                    LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

                    ,VALID_FLAG, CHANGESIGN, CODE_COMBINATION_ID, SOURCE_LEDGER_ID

                    ,GL_PERIOD_YEAR, GL_PERIOD_NUM, YEAR, PERIOD

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

                    ,DATAKEY

                    ,ACCOUNT

                    ,ACCOUNTX

                    ,ENTITY

                    ,ENTITYX

                    ,ICP

                    ,ICPX

                    ,UD1

                    ,UD1X

                    ,UD2

                    ,UD2X

                    ,UD3

                    ,UD3X

                    ,UD4

                    ,UD4X

                    ,DATAVIEW

                      ,STAT_BALANCE_FLAG

                      ,CURKEY

                      ,AMOUNT_PTD

                      ,AMOUNT_YTD

                      ,AMOUNT

                      ,AMOUNTX

                    )

                   

                  SELECT bal.PROCESS_ID LOADID

                    ,36 PARTITIONKEY

                    ,3 CATKEY

                    ,27 RULE_ID

                    ,bal.PERIODKEY

                    ,'Y' VALID_FLAG

                    ,0 CHANGESIGN

                    ,bal.CODE_COMBINATION_ID

                    ,bal.SOURCE_LEDGER_ID

                    ,bal.GL_PERIOD_YEAR

                    ,bal.GL_PERIOD_NUM

                    ,bal.YEARTARGET YEAR

                    ,bal.PERIODTARGET PERIOD

                    ,bal.PROCESS_ID ATTR1

                    ,bal.SOURCE_SYSTEM_ID ATTR2

                    ,bal.SOURCE_LEDGER_ID ATTR3

                    ,bal.GL_PERIOD_YEAR ATTR4

                    ,bal.GL_PERIOD_NAME ATTR5

                    ,bal.ACTUAL_FLAG ATTR6

                    ,bal.BUDGET_VERSION_ID ATTR7

                    ,bal.ENCUMBRANCE_TYPE_ID ATTR8

                    ,bal.ACCOUNT_TYPE ATTR9

                    ,NULL ATTR10

                    ,NULL ATTR11

                    ,NULL ATTR12

                    ,NULL ATTR13

                    ,NULL ATTR14

                    ,bal.ACCOUNT_DESC DESC1

                    ,TDATASEG_DATAKEY_S.NEXTVAL

                    ,bal.SEGMENT3||'_'||bal.SEGMENT2 ACCOUNT

                    ,NULL ACCOUNTX

                    ,bal.SEGMENT1 ENTITY

                    ,NULL ENTITYX

                    ,bal.SEGMENT3||'_'||bal.SEGMENT2 ICP

                    ,NULL ICPX

                    ,NULL UD1

                    ,NULL UD1X

                    ,bal.SEGMENT4 UD2

                    ,NULL UD2X

                    ,NULL UD3

                    ,NULL UD3X

                    ,NULL UD4

                    ,NULL UD4X

                    ,'YTD' DATAVIEW

                    ,'N' STAT_BALANCE_FLAG

                    ,bal.CURRENCY_CODE CURKEY

                    ,bal.AMOUNT_PTD AMOUNT_PTD

                    ,bal.AMOUNT_YTD AMOUNT_YTD

                    ,bal.AMOUNT_YTD AMOUNT

                    ,bal.AMOUNT_YTD AMOUNTX

                    FROM (

                     

                  SELECT gb.SOURCE_SYSTEM_ID, gb.SOURCE_COA_ID, gb.SOURCE_LEDGER_ID, gb.CODE_COMBINATION_ID, gb.ACTUAL_FLAG

                      ,gb.BUDGET_VERSION_ID, gb.ENCUMBRANCE_TYPE_ID, gb.ACCOUNT_TYPE, gb.ACCOUNT_DESC, pprd.PROCESS_ID

                      ,pprd.PERIODKEY, pprd.PERIOD_ID, pprd.GL_PERIOD_YEAR, pprd.GL_PERIOD_NAME, pprd.GL_PERIOD_NUM

                      ,pprd.YEARTARGET, pprd.PERIODTARGET

                      ,MAX( gb.DELTA_RUN_ID ) DELTA_RUN_ID

                 

                      ,gb.SEGMENT3, gb.SEGMENT2

                      ,gb.SEGMENT1

                      ,gb.SEGMENT4

                      ,gb.CURRENCY_CODE

                      ,SUM( gb.PERIOD_NET_DR - gb.PERIOD_NET_CR ) AMOUNT_PTD

                      ,SUM( gb.BEGIN_BALANCE_DR - gb.BEGIN_BALANCE_CR + gb.PERIOD_NET_DR - gb.PERIOD_NET_CR ) AMOUNT_YTD

                     

                  FROM AIF_EBS_GL_BALANCES_STG gb

                      ,AIF_PROCESS_PERIODS pprd

                     

                  WHERE gb.SOURCE_SYSTEM_ID = 5

                  AND gb.SOURCE_LEDGER_ID = 22

                  AND gb.ACTUAL_FLAG = 'A'

                  AND pprd.PROCESS_ID = 637

                  AND pprd.PERIODKEY = '2016-03-31'

                  AND pprd.SOURCE_LEDGER_ID = gb.SOURCE_LEDGER_ID

                  AND pprd.GL_PERIOD_NAME = gb.PERIOD_NAME

                 

                      AND (gb.BEGIN_BALANCE_DR - gb.BEGIN_BALANCE_CR + gb.PERIOD_NET_DR - gb.PERIOD_NET_CR) <> 0

                     

                      AND gb.CURRENCY_CODE <> 'STAT'

                     

                      AND gb.TRANSLATED_FLAG IS NULL

                     

                     

                  GROUP BY gb.SOURCE_SYSTEM_ID, gb.SOURCE_COA_ID, gb.SOURCE_LEDGER_ID, gb.CODE_COMBINATION_ID, gb.ACTUAL_FLAG

                      ,gb.BUDGET_VERSION_ID, gb.ENCUMBRANCE_TYPE_ID, gb.ACCOUNT_TYPE, gb.ACCOUNT_DESC, pprd.PROCESS_ID, pprd.PERIODKEY

                      ,pprd.PERIOD_ID, pprd.GL_PERIOD_YEAR, pprd.GL_PERIOD_NAME, pprd.GL_PERIOD_NUM, pprd.YEARTARGET, pprd.PERIODTARGET

                 

                      ,gb.SEGMENT3, gb.SEGMENT2

                      ,gb.SEGMENT1

                      ,gb.SEGMENT4

                      ,gb.CURRENCY_CODE

                    ) bal

                   

                   

                  WHERE 1=1

      2017-02-20 13:17:26,633 INFO  [AIF]:     Monetary Data Rows Imported from Source: 3743

      2017-02-20 13:17:26,634 DEBUG [AIF]: 

                    INSERT INTO AIF_APPL_LOAD_AUDIT (

                      LOADID

                      ,TARGET_APPLICATION_TYPE

                      ,TARGET_APPLICATION_NAME

                      ,PLAN_TYPE

                      ,SOURCE_LEDGER_ID

                      ,EPM_YEAR

                      ,EPM_PERIOD

                      ,SNAPSHOT_FLAG

                      ,PARTITIONKEY

                      ,CATKEY

                      ,RULE_ID

                      ,PERIODKEY

                      ,EXPORT_TO_TARGET_FLAG

                    )

                    SELECT DISTINCT PROCESS_ID LOADID

                    ,'HFM' TARGET_APPLICATION_TYPE

                    ,'TndCON' TARGET_APPLICATION_NAME

                    ,NULL PLAN_TYPE

                    ,SOURCE_LEDGER_ID

                    ,YEARTARGET EPM_YEAR

                    ,PERIODTARGET EPM_PERIOD

                    ,'Y' SNAPSHOT_FLAG

                    ,36 PARTITIONKEY

                    ,3 CATKEY

                    ,27 RULE_ID

                    ,PERIODKEY

                    ,'N' EXPORT_TO_TARGET_FLAG

                    FROM AIF_PROCESS_PERIODS

                    WHERE PROCESS_ID = 637

                    AND PERIODKEY = '2016-03-31'

                    AND SOURCE_LEDGER_ID = 22

                   

      2017-02-20 13:17:26,635 DEBUG [AIF]:

                    INSERT INTO AIF_APPL_LOAD_PRD_AUDIT (

                      LOADID

                      ,SOURCE_LEDGER_ID

                      ,GL_PERIOD_ID

                      ,DELTA_RUN_ID

                      ,PARTITIONKEY

                      ,CATKEY

                      ,RULE_ID

                      ,PERIODKEY

                    )

                    SELECT DISTINCT pprd.PROCESS_ID LOADID

                    ,pprd.SOURCE_LEDGER_ID

                    ,pprd.PERIOD_ID GL_PERIOD_ID

                    ,(SELECT MAX(gl.DELTA_RUN_ID)

                      FROM AIF_GL_LOAD_AUDIT gl

                      WHERE gl.SOURCE_SYSTEM_ID = 5

                      AND gl.SOURCE_LEDGER_ID = pprd.SOURCE_LEDGER_ID

                      AND gl.BALANCE_TYPE = 'A'

                      AND gl.GL_PERIOD_ID = pprd.PERIOD_ID

                    ) DELTA_RUN_ID

                    ,36 PARTITIONKEY

                    ,3 CATKEY

                    ,27 RULE_ID

                    ,pprd.PERIODKEY

                    FROM AIF_PROCESS_PERIODS pprd

                    WHERE pprd.PROCESS_ID = 637

                    AND pprd.PERIODKEY = '2016-03-31'

                    AND pprd.SOURCE_LEDGER_ID = 22

                   

      2017-02-20 13:17:26,636 INFO  [AIF]: Total Data Rows Imported from Source: 3743

      2017-02-20 13:17:26,636 DEBUG [AIF]: EBS/FS Load Data - Load TDATASEG_T - END

      2017-02-20 13:17:26,642 DEBUG [AIF]: Comm.doScriptInit - START

      2017-02-20 13:17:26,703 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=\\Tnd-hfm-prd2\FDMEE\inbox, LOCNAME=Tnd_SR, SOURCENAME=Tnd_EBS_SYSTEM, APPID=2, SOURCEID=5, APPROOTDIR=\\Tnd-hfm-prd2\FDMEE, IMPORTFORMAT=Tnd_SR, SCRIPTSDIR=\\Tnd-hfm-prd2\FDMEE\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=27, CATNAME=Statutory, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=637, PERIODNAME=Mar-16, IMPORTMODE=FULLREFRESH, SOURCETYPE=EBS_R12, PERIODKEY=2016-03-31, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=TndCON, LOCKEY=36, RULENAME=Tnd_SR, OUTBOXDIR=\\Tnd-hfm-prd2\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=3, USERNAME=hypadmin, FILEDIR=null, IMPORTFLAG=Y, USERLOCALE=en}

      2017-02-20 13:17:26,703 DEBUG [AIF]: The EpmOracleHome is set to: D:\Oracle\Middleware\EPMSystem11R1

      2017-02-20 13:17:26,703 DEBUG [AIF]: The EpmOracleInstance is set to: D:\Oracle\Middleware\user_projects\epmsystem1

      2017-02-20 13:17:26,703 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

      2017-02-20 13:17:26,703 DEBUG [AIF]: The executeEventScript is set to: YES

      2017-02-20 13:17:26,703 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

      2017-02-20 13:17:26,703 DEBUG [AIF]: The AppRootFolder is set to: \\Tnd-hfm-prd2\FDMEE

      2017-02-20 13:17:26,703 DEBUG [AIF]: Comm.doScriptInit - END

      2017-02-20 13:17:26,704 DEBUG [AIF]: Comm.executeScript - START

      2017-02-20 13:17:26,704 DEBUG [AIF]: The following script does not exist: \\Tnd-hfm-prd2\FDMEE/data/scripts/event/AftImport.py

      2017-02-20 13:17:26,707 DEBUG [AIF]: Comm.executeVBScript - START

      2017-02-20 13:17:26,707 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

      2017-02-20 13:17:26,707 DEBUG [AIF]: The following script does not exist: \\Tnd-hfm-prd2\FDMEE\data\scripts\event\AftImport.vbs

      2017-02-20 13:17:26,707 DEBUG [AIF]: Comm.executeVBScript - END

      2017-02-20 13:17:26,708 DEBUG [AIF]: Comm.executeScript - END

      2017-02-20 13:17:26,708 DEBUG [AIF]: EbsData.postImportData - END

      2017-02-20 13:17:26,820 DEBUG [AIF]: LogicGroup.createLogicAccounts - START

      2017-02-20 13:17:26,820 DEBUG [AIF]: Comm.executeScript - START

      2017-02-20 13:17:26,821 DEBUG [AIF]: The following script does not exist: \\Tnd-hfm-prd2\FDMEE/data/scripts/event/BefProcLogicGrp.py

      2017-02-20 13:17:26,821 DEBUG [AIF]: Comm.executeVBScript - START

      2017-02-20 13:17:26,822 DEBUG [AIF]: The following script does not exist: \\Tnd-hfm-prd2\FDMEE\data\scripts\event\BefProcLogicGrp.vbs

      2017-02-20 13:17:26,822 DEBUG [AIF]: Comm.executeVBScript - END

      2017-02-20 13:17:26,822 DEBUG [AIF]: Comm.executeScript - END

      2017-02-20 13:17:26,823 DEBUG [AIF]: CommData.getRuleInfo - START

      2017-02-20 13:17:26,823 DEBUG [AIF]: CommData.getRuleInfo - START

      2017-02-20 13:17:26,824 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 = 637

             

      2017-02-20 13:17:26,825 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 = 2

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

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

           

            ORDER BY adim.BALANCE_COLUMN_NAME

           

      2017-02-20 13:17:26,827 DEBUG [AIF]: {'APPLICATION_ID': 2L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'Tnd_SR', 'ACTUAL_FLAG': u'A', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 3L, 'BAL_SEG_VALUE_OPTION_CODE': u'ALL', 'INCLUDE_ADJ_PERIODS_FLAG': u'Y', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'EBS_R12', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'TndCON', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 5L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': u'22', 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 101L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'hypadmin', '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': 6L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT3', 'COA_SEGMENT_NAME2': u'SEGMENT2', 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 8L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT1', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 3L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT4', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 5L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 7L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT3', 'COA_SEGMENT_NAME2': u'SEGMENT2', 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 1L}, 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': 4L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 36L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'SINGLE', 'INCLUDE_ZERO_BALANCE_FLAG': u'Z', 'EXECUTION_MODE': u'FULLREFRESH', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'ERPI', 'BALANCE_AMOUNT_IS': u'YTD', 'RULE_ID': 27L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': u'STANDARD', 'SIGNAGE_METHOD': u'SAME', 'WEB_SERVICE_URL': u'http://Tnd-HFM-Prd2.Tnd.com.kw:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 2L, 'IMPTARGETSOURCESYSTEMID': 0L}

      2017-02-20 13:17:26,827 DEBUG [AIF]: CommData.getRuleInfo - END

      2017-02-20 13:17:26,827 DEBUG [AIF]:

              select part.PARTLOGICGROUP

              ,lgrp.CALCGROUPTYPE

              from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp

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

              and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY 

             

      2017-02-20 13:17:26,828 DEBUG [AIF]: CommData.getRuleInfo - END

      2017-02-20 13:17:26,828 DEBUG [AIF]: Logic group TndHO_SR is found

      2017-02-20 13:17:26,828 DEBUG [AIF]:

                  select litm.CALCGROUPKEY LOGICGROUP, litm.CALCSTMTACCOUNT LOGICACCOUNT, litm.CALCSTMTWHERECLAUSETYPE WHERECLAUSETYPE,

                  litm.CALCSTMTWHERECLAUSEVALUE WHERECLAUSEVALUE, litm.CALCSTMTMATHOPERATOR MATHOPERATOR,

                  litm.CALCSTMTEXPORTACCOUNT EXPORTACCOUNT, litm.CALCSTMTMATHVALUE MATHVALUE, litm.INCLUDECALCULATED INCLUDECALCULATED

                  from TBHVLOGICITEM litm

                  where litm.CALCGROUPKEY='TndHO_SR'

                  order by litm.CALCSTMTSEQUENCE

                 

      2017-02-20 13:17:26,830 DEBUG [AIF]: Simple logic account processing

      2017-02-20 13:17:26,830 DEBUG [AIF]:

                    select BALANCE_COLUMN_NAME from AIF_TARGET_APPL_DIMENSIONS

                    where APPLICATION_ID=2 and BALANCE_COLUMN_NAME is not null

                    and BALANCE_COLUMN_NAME NOT IN ('ENTITY', 'ACCOUNT')

                 

      2017-02-20 13:17:26,835 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L35403_X601' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L35403_X601' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '35403/_X601' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,836 DEBUG [AIF]: Inserted 1 rows for logic account L35403_X601

      2017-02-20 13:17:26,837 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21534_0000' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21534_0000' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21534/_0000' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,837 DEBUG [AIF]: Inserted 1 rows for logic account L21534_0000

      2017-02-20 13:17:26,838 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21538_0000' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21538_0000' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21538/_0000' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,839 DEBUG [AIF]: Inserted 1 rows for logic account L21538_0000

      2017-02-20 13:17:26,839 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21535_0000' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21535_0000' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21535/_0000' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,840 DEBUG [AIF]: Inserted 0 rows for logic account L21535_0000

      2017-02-20 13:17:26,840 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21522_0000' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21522_0000' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21522/_0000' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,841 DEBUG [AIF]: Inserted 1 rows for logic account L21522_0000

      2017-02-20 13:17:26,841 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21540_0000' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21540_0000' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21540/_0000' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,842 DEBUG [AIF]: Inserted 1 rows for logic account L21540_0000

      2017-02-20 13:17:26,842 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21604_0000' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21604_0000' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21604/_0000' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,843 DEBUG [AIF]: Inserted 1 rows for logic account L21604_0000

      2017-02-20 13:17:26,843 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21521_0000' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21521_0000' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21521/_0000' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,844 DEBUG [AIF]: Inserted 1 rows for logic account L21521_0000

      2017-02-20 13:17:26,844 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21528_0000' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21528_0000' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21528/_0000' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,845 DEBUG [AIF]: Inserted 1 rows for logic account L21528_0000

      2017-02-20 13:17:26,845 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21601_0000' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21601_0000' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21601/_0000' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,846 DEBUG [AIF]: Inserted 1 rows for logic account L21601_0000

      2017-02-20 13:17:26,846 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21602_X731' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21602_X731' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21602/_X731' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,847 DEBUG [AIF]: Inserted 1 rows for logic account L21602_X731

      2017-02-20 13:17:26,847 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21601_X204' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21601_X204' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21601/_X204' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,848 DEBUG [AIF]: Inserted 1 rows for logic account L21601_X204

      2017-02-20 13:17:26,849 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21601_X504' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21601_X504' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21601/_X504' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,849 DEBUG [AIF]: Inserted 1 rows for logic account L21601_X504

      2017-02-20 13:17:26,850 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21537_0000' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21537_0000' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21537/_0000' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,851 DEBUG [AIF]: Inserted 1 rows for logic account L21537_0000

      2017-02-20 13:17:26,851 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21533_0000' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21533_0000' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21533/_0000' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,852 DEBUG [AIF]: Inserted 1 rows for logic account L21533_0000

      2017-02-20 13:17:26,852 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21531_0000' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21531_0000' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21531/_0000' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,853 DEBUG [AIF]: Inserted 1 rows for logic account L21531_0000

      2017-02-20 13:17:26,853 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21529_0000' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21529_0000' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21529/_0000' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,854 DEBUG [AIF]: Inserted 1 rows for logic account L21529_0000

      2017-02-20 13:17:26,854 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21601_X731' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21601_X731' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21601/_X731' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,855 DEBUG [AIF]: Inserted 1 rows for logic account L21601_X731

      2017-02-20 13:17:26,855 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21601_X502' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21601_X502' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21601/_X502' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,856 DEBUG [AIF]: Inserted 1 rows for logic account L21601_X502

      2017-02-20 13:17:26,857 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21601_X507' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21601_X507' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21601/_X507' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,857 DEBUG [AIF]: Inserted 1 rows for logic account L21601_X507

      2017-02-20 13:17:26,858 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21601_X601' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21601_X601' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21601/_X601' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,858 DEBUG [AIF]: Inserted 1 rows for logic account L21601_X601

      2017-02-20 13:17:26,859 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21602_X716' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21602_X716' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21602/_X716' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,860 DEBUG [AIF]: Inserted 1 rows for logic account L21602_X716

      2017-02-20 13:17:26,860 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L35403_X504' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L35403_X504' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '35403/_X504' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,861 DEBUG [AIF]: Inserted 1 rows for logic account L35403_X504

      2017-02-20 13:17:26,861 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L35403_X508' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L35403_X508' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '35403/_X508' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,862 DEBUG [AIF]: Inserted 0 rows for logic account L35403_X508

      2017-02-20 13:17:26,862 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L35403_X505' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L35403_X505' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '35403/_X505' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,863 DEBUG [AIF]: Inserted 1 rows for logic account L35403_X505

      2017-02-20 13:17:26,863 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L35403_X503' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L35403_X503' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '35403/_X503' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,864 DEBUG [AIF]: Inserted 1 rows for logic account L35403_X503

      2017-02-20 13:17:26,864 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L35403_X509' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L35403_X509' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '35403/_X509' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,865 DEBUG [AIF]: Inserted 1 rows for logic account L35403_X509

      2017-02-20 13:17:26,866 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L35403_X716' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L35403_X716' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '35403/_X716' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,866 DEBUG [AIF]: Inserted 1 rows for logic account L35403_X716

      2017-02-20 13:17:26,867 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

             

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              ,DATAKEY

            )

            SELECT

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,ACCOUNT

                          ,ENTITY

                          ,VALID_FLAG

                          ,CURKEY

                          ,CALCACCTTYPE

                          ,ATTR13

                          ,AMOUNT

                          ,AMOUNTX

                         

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ,TDATASEG_DATAKEY_S.NEXTVAL AS DATAKEY

            FROM (

             

                          SELECT LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,'L21601_X503' AS ACCOUNT

                          ,ENTITY

                          ,'Y' AS VALID_FLAG

                          ,CURKEY

                          ,5 AS CALCACCTTYPE

                          ,'L21601_X503' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT

                          ,SUM(AMOUNTX) AMOUNTX

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

              FROM TDATASEG_T

              WHERE LOADID=637 AND (ACCOUNT LIKE '21601/_X503' ESCAPE '/')

              GROUP BY

                          LOADID

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,CURKEY

                         

                          ,ENTITY

                            ,UD1

                            ,UD2

                            ,UD3

                            ,UD4

                            ,ICP

            ) LOGIC_ACCOUNT

           

      2017-02-20 13:17:26,868 DEBUG [AIF]: Inserted 1 rows for logic account L21601_X503

      2017-02-20 13:17:26,869 DEBUG [AIF]: Comm.executeScript - START

      2017-02-20 13:17:26,869 DEBUG [AIF]: The following script does not exist: \\Tnd-hfm-prd2\FDMEE/data/scripts/event/AftProcLogicGrp.py

      2017-02-20 13:17:26,869 DEBUG [AIF]: Comm.executeVBScript - START

      2017-02-20 13:17:26,870 DEBUG [AIF]: The following script does not exist: \\Tnd-hfm-prd2\FDMEE\data\scripts\event\AftProcLogicGrp.vbs

      2017-02-20 13:17:26,870 DEBUG [AIF]: Comm.executeVBScript - END

      2017-02-20 13:17:26,870 DEBUG [AIF]: Comm.executeScript - END

      2017-02-20 13:17:26,870 DEBUG [AIF]: LogicGroup.createLogicAccounts - END

      2017-02-20 13:17:26,886 DEBUG [AIF]: CommData.mapData - START

      2017-02-20 13:17:26,886 DEBUG [AIF]: Comm.executeScript - START

      2017-02-20 13:17:26,887 DEBUG [AIF]: The following script does not exist: \\Tnd-hfm-prd2\FDMEE/data/scripts/event/BefProcMap.py

      2017-02-20 13:17:26,887 DEBUG [AIF]: Comm.executeVBScript - START

      2017-02-20 13:17:26,887 DEBUG [AIF]: The following script does not exist: \\Tnd-hfm-prd2\FDMEE\data\scripts\event\BefProcMap.vbs

      2017-02-20 13:17:26,887 DEBUG [AIF]: Comm.executeVBScript - END

      2017-02-20 13:17:26,887 DEBUG [AIF]: Comm.executeScript - END

      2017-02-20 13:17:26,889 DEBUG [AIF]: CommData.insertTransProcessDetails - START

      2017-02-20 13:17:26,889 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

                ,'hypadmin' 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 = 637

                  AND PRIOR_PERIOD_FLAG = 'N'

                  GROUP BY PROCESS_ID

                  ,TRANS_ENTITY_TYPE

                  ,TRANS_ENTITY_NAME

                ) q

                ORDER BY ENTITY_NAME_ORDER

               

      2017-02-20 13:17:26,891 DEBUG [AIF]: CommData.insertTransProcessDetails - END

      2017-02-20 13:17:26,893 DEBUG [AIF]:

              DELETE FROM TDATAMAP_T

              WHERE LOADID < 637

              AND EXISTS (

                SELECT 1

                FROM AIF_PROCESSES p

                WHERE p.RULE_ID = 27

                AND p.PROCESS_ID = TDATAMAP_T.LOADID

              )

             

      2017-02-20 13:17:26,901 DEBUG [AIF]:

              DELETE FROM TDATASEG_T

              WHERE LOADID < 637

              AND EXISTS (

                SELECT 1

                FROM AIF_PROCESSES p

                WHERE p.RULE_ID = 27

                AND p.PROCESS_ID = TDATASEG_T.LOADID

              )

             

      2017-02-20 13:17:26,984 DEBUG [AIF]:

              DELETE FROM AIF_PROCESS_PERIODS

              WHERE PROCESS_ID < 637

              AND EXISTS (

                SELECT 1

                FROM AIF_PROCESSES p

                WHERE p.RULE_ID = 27

                AND p.PROCESS_ID = AIF_PROCESS_PERIODS.PROCESS_ID

              )

             

      2017-02-20 13:17:26,988 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START

      2017-02-20 13:17:26,989 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START

      2017-02-20 13:17:26,990 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 = 36

             

      2017-02-20 13:17:26,990 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END

      2017-02-20 13:17:26,991 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 637

              ,DATAKEY

              ,36 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 = 36

              AND (RULE_ID IS NULL OR RULE_ID = 27)

              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-02-20 13:17:27,054 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 451

      2017-02-20 13:17:27,056 DEBUG [AIF]: CommData.targetMemberFilter - START

      2017-02-20 13:17:27,057 DEBUG [AIF]:

              DELETE FROM AIF_TARGET_APPL_DIM_MEMS

              WHERE APPLICATION_ID = 2

              AND CREATED_BY_RULE_ID = 27   

             

      2017-02-20 13:17:27,059 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, 27 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 = 637

              AND (

                tdmt.WHERECLAUSETYPE IS NULL

                OR tdmt.WHERECLAUSETYPE = 'BETWEEN'

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

              )

              AND adim.APPLICATION_ID = 2

              AND adim.BALANCE_COLUMN_NAME = tdmt.DIMNAME

              AND dim.DIMENSION_ID = adim.DIMENSION_ID

             

      2017-02-20 13:17:27,063 DEBUG [AIF]: CommData.targetMemberFilter - END

      2017-02-20 13:17:27,096 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START

      2017-02-20 13:17:27,097 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 = 637

                AND atad.APPLICATION_ID = 2

                AND tdm.PARTITIONKEY = 36

                AND tdm.TDATAMAPTYPE = 'ERP'

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

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

                AND atad.APPLICATION_ID = 2

                AND tdm.PARTITIONKEY = 36

                AND tdm.TDATAMAPTYPE = 'ERP'

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

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

              ) q

              ORDER BY CALC_SEQ

              ,DIMNAME

              ,SEQUENCE

              ,RULE_ID

              ,SYSTEM_GENERATED_FLAG

              ,SRCKEY

         

      2017-02-20 13:17:27,104 DEBUG [AIF]:

            SELECT VBSCRIPT

            FROM TDATAMAP_T

            WHERE LOADID = 637

            AND PARTITIONKEY = 36

            AND DATAKEY = 45791

           

      2017-02-20 13:17:27,106 DEBUG [AIF]:

            SELECT VBSCRIPT

            FROM TDATAMAP_T

            WHERE LOADID = 637

            AND PARTITIONKEY = 36

            AND DATAKEY = 45792

           

      2017-02-20 13:17:27,107 DEBUG [AIF]:

            SELECT VBSCRIPT

            FROM TDATAMAP_T

            WHERE LOADID = 637

            AND PARTITIONKEY = 36

            AND DATAKEY = 45829

           

      2017-02-20 13:17:27,107 DEBUG [AIF]:

            SELECT VBSCRIPT

            FROM TDATAMAP_T

            WHERE LOADID = 637

            AND PARTITIONKEY = 36

            AND DATAKEY = 45830

           

      2017-02-20 13:17:27,108 DEBUG [AIF]:

            SELECT VBSCRIPT

            FROM TDATAMAP_T

            WHERE LOADID = 637

            AND PARTITIONKEY = 36

            AND DATAKEY = 45831

           

      2017-02-20 13:17:27,109 DEBUG [AIF]:

            SELECT VBSCRIPT

            FROM TDATAMAP_T

            WHERE LOADID = 637

            AND PARTITIONKEY = 36

            AND DATAKEY = 45160

           

      2017-02-20 13:17:27,111 FATAL [AIF]: Error in CommMap.updateTDATASEG_T_TDATASEGW

      Traceback (most recent call last):

        File "<string>", line 1822, in updateTDATASEG_T_TDATASEGW

      TypeError: cannot concatenate 'unicode' and 'NoneType' objects

       

      2017-02-20 13:17:27,111 DEBUG [AIF]: Comm.executeScript - START

      2017-02-20 13:17:27,111 DEBUG [AIF]: The following script does not exist: \\Tnd-hfm-prd2\FDMEE/data/scripts/event/AftProcMap.py

      2017-02-20 13:17:27,112 DEBUG [AIF]: Comm.executeVBScript - START

      2017-02-20 13:17:27,112 DEBUG [AIF]: The following script does not exist: \\Tnd-hfm-prd2\FDMEE\data\scripts\event\AftProcMap.vbs

      2017-02-20 13:17:27,112 DEBUG [AIF]: Comm.executeVBScript - END

      2017-02-20 13:17:27,112 DEBUG [AIF]: Comm.executeScript - END

      2017-02-20 13:17:27,149 DEBUG [AIF]: Comm.finalizeProcess - START

      2017-02-20 13:17:27,150 DEBUG [AIF]: CommData.updateRuleStatus - START

      2017-02-20 13:17:27,150 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 = 637

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

              )

              WHEN 0 THEN 'SUCCESS'

              ELSE (

                SELECT MIN(pd.STATUS)

                FROM AIF_PROCESS_DETAILS pd

                WHERE pd.PROCESS_ID = 637

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

              )

              END

            ELSE 'FAILED'

          END

          WHERE RULE_ID = 27

         

      2017-02-20 13:17:27,152 DEBUG [AIF]: CommData.updateRuleStatus - END

      2017-02-20 13:17:27,153 FATAL [AIF]: Error in COMM Map Data

      2017-02-20 13:17:27,153 DEBUG [AIF]: Comm.updateProcess - START

      2017-02-20 13:17:27,155 DEBUG [AIF]: Comm.updateProcess - END

      2017-02-20 13:17:27,156 DEBUG [AIF]: The fdmAPI connection has been closed.

      2017-02-20 13:17:27,157 INFO  [AIF]: FDMEE Process End, Process ID: 637

        • 1. Re: FDMEE Import failed
          SH_INT

          This is the bit of the error log you should be focussing on

           

          2017-02-20 13:17:27,111 FATAL [AIF]: Error in CommMap.updateTDATASEG_T_TDATASEGW

          Traceback (most recent call last):

            File "<string>", line 1822, in updateTDATASEG_T_TDATASEGW

          TypeError: cannot concatenate 'unicode' and 'NoneType' objects

           

          Somewere in your configuration you are trying to concatenate together two values into a single value, one of these values is probably NULL which is causing the error