1 Reply Latest reply on Jun 27, 2014 1:28 PM by Francisco Amores

    Error on validation for loading ebs data

    1050864

      Hi ,

       

      I attached the log file with this mail .. I can't able to  validate the data from ebs source

       

      2014-06-26 23:38:48,843 INFO  [AIF]: FDMEE Process Start, Process ID: 232

      2014-06-26 23:38:48,843 INFO  [AIF]: FDMEE Logging Level: 5

      2014-06-26 23:38:48,843 INFO  [AIF]: FDMEE Log File: C:\Oracle\FDMEE\outbox\logs\POC5_232.log

      2014-06-26 23:38:48,843 INFO  [AIF]: User:admin

      2014-06-26 23:38:48,843 INFO  [AIF]: Location:SUNR12_LOC (Partitionkey:16)

      2014-06-26 23:38:48,843 INFO  [AIF]: Period Name:Aug-13 (Period Key:8/31/13 12:00 AM)

      2014-06-26 23:38:48,843 INFO  [AIF]: Category Name:Actual (Category key:5)

      2014-06-26 23:38:48,844 INFO  [AIF]: Rule Name:SUNR12_DR (Rule ID:22)

      2014-06-26 23:38:49,538 INFO  [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

      [Oracle JRockit(R) (Oracle Corporation)]

      2014-06-26 23:38:49,538 INFO  [AIF]: Java Platform: java1.6.0_37

      2014-06-26 23:38:49,538 INFO  [AIF]: Log File Encoding: UTF-8

      2014-06-26 23:38:50,753 INFO  [AIF]: -------START IMPORT STEP-------

      2014-06-26 23:38:50,778 DEBUG [AIF]: CommData.recalcData - START

      2014-06-26 23:38:50,781 DEBUG [AIF]: CommData.getRuleInfo - START

      2014-06-26 23:38:50,782 DEBUG [AIF]:

              SELECT brl.RULE_ID

              ,br.RULE_NAME

              ,brl.PARTITIONKEY

              ,brl.CATKEY

              ,part.PARTVALGROUP

              ,br.SOURCE_SYSTEM_ID

              ,ss.SOURCE_SYSTEM_TYPE

              ,CASE

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

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

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

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

                ELSE 'Y'

              END SOURCE_ADAPTER_FLAG

              ,app.APPLICATION_ID

              ,app.TARGET_APPLICATION_NAME

              ,app.TARGET_APPLICATION_TYPE

              ,app.DATA_LOAD_METHOD

              ,brl.PLAN_TYPE

              ,CASE brl.PLAN_TYPE

                WHEN 'PLAN1' THEN 1

                WHEN 'PLAN2' THEN 2

                WHEN 'PLAN3' THEN 3

                WHEN 'PLAN4' THEN 4

                WHEN 'PLAN5' THEN 5

                ELSE 0

              END PLAN_NUMBER

              ,br.INCL_ZERO_BALANCE_FLAG

              ,br.PERIOD_MAPPING_TYPE

              ,br.INCLUDE_ADJ_PERIODS_FLAG

              ,br.BALANCE_TYPE ACTUAL_FLAG

              ,br.AMOUNT_TYPE

              ,br.BALANCE_SELECTION

              ,br.BALANCE_METHOD_CODE

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

              ,br.CURRENCY_CODE

              ,br.BAL_SEG_VALUE_OPTION_CODE

              ,brl.EXECUTION_MODE

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

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

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

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

              ,CASE

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

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

                ELSE 'NONE'

              END LEDGER_GROUP_CODE

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

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

              ,br.LEDGER_GROUP

              ,(SELECT brd.DETAIL_CODE

                FROM AIF_BAL_RULE_DETAILS brd

                WHERE brd.RULE_ID = br.RULE_ID

                AND brd.DETAIL_TYPE = 'LEDGER'       

              ) PS_LEDGER

              ,CASE lg.LEDGER_TEMPLATE

                WHEN 'COMMITMENT' THEN 'Y'

                ELSE 'N'

              END KK_FLAG

              ,p.LAST_UPDATED_BY

              ,p.AIF_WEB_SERVICE_URL WEB_SERVICE_URL

              ,p.EPM_ORACLE_INSTANCE

              ,brl.JOURNAL_FLAG

              ,br.MULTI_PERIOD_FILE_FLAG

              ,br.IMPGROUPKEY

              FROM AIF_PROCESSES p

              INNER JOIN AIF_BAL_RULE_LOADS brl

                ON brl.LOADID = p.PROCESS_ID

              INNER JOIN AIF_BALANCE_RULES br

                ON br.RULE_ID = brl.RULE_ID

              INNER JOIN AIF_SOURCE_SYSTEMS ss

                ON ss.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID

              INNER JOIN AIF_TARGET_APPLICATIONS app

                ON app.APPLICATION_ID = brl.APPLICATION_ID

              INNER JOIN TPOVPARTITION part

                ON part.PARTITIONKEY = br.PARTITIONKEY

              INNER JOIN TBHVIMPGROUP imp

                ON imp.IMPGROUPKEY = part.PARTIMPGROUP

              LEFT OUTER JOIN AIF_COA_LEDGERS l

                ON l.SOURCE_SYSTEM_ID = p.SOURCE_SYSTEM_ID

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

              LEFT OUTER JOIN AIF_PS_SET_CNTRL_REC_STG scr

                ON scr.SOURCE_SYSTEM_ID = l.SOURCE_SYSTEM_ID

                AND scr.SETCNTRLVALUE = l.SOURCE_LEDGER_NAME

                AND scr.RECNAME = 'LED_GRP_TBL'

              LEFT OUTER JOIN AIF_PS_LED_GRP_TBL_STG lg

                ON lg.SOURCE_SYSTEM_ID = scr.SOURCE_SYSTEM_ID

                AND lg.SETID = scr.SETID

                AND lg.LEDGER_GROUP = br.LEDGER_GROUP

              WHERE p.PROCESS_ID = 232

             

      2014-06-26 23:38:50,785 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 = 13

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

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

           

            ORDER BY adim.BALANCE_COLUMN_NAME

           

      2014-06-26 23:38:50,786 DEBUG [AIF]: {'APPLICATION_ID': 13L, 'IMPORT_FROM_SOURCE_FLAG': u'N', 'PLAN_TYPE': None, 'RULE_NAME': u'SUNR12_DR', 'ACTUAL_FLAG': u'A', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'C:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 5L, 'BAL_SEG_VALUE_OPTION_CODE': u'ALL', 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'EBS_R12', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'POC5', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 11L, '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, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT2', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 81L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', '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'ICP', 'DIMENSION_ID': 83L}, 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': 78L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 80L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT5', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 82L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT3', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 76L}, 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': 79L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 16L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'SINGLE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': None, 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 22L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': u'STANDARD', 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://epmvirtual:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI'}

      2014-06-26 23:38:50,787 DEBUG [AIF]: CommData.getRuleInfo - END

      2014-06-26 23:38:50,802 DEBUG [AIF]: CommData.insertPeriods - START

      2014-06-26 23:38:50,805 DEBUG [AIF]: CommData.getLedgerListAndMap - START

      2014-06-26 23:38:50,805 DEBUG [AIF]: CommData.getLedgerSQL - START

      2014-06-26 23:38:50,805 DEBUG [AIF]: CommData.getLedgerSQL - END

      2014-06-26 23:38:50,805 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 = 22

                AND l.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID

                AND l.SOURCE_LEDGER_ID = br.SOURCE_LEDGER_ID

               

      2014-06-26 23:38:50,806 DEBUG [AIF]: CommData.getLedgerListAndMap - END

      2014-06-26 23:38:50,808 DEBUG [AIF]: commAppPeriodMappingExists: Y

      2014-06-26 23:38:50,808 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

      2014-06-26 23:38:50,808 DEBUG [AIF]:

              INSERT INTO AIF_PROCESS_PERIODS (

                PROCESS_ID

                ,PERIODKEY

                ,PERIOD_ID

                ,ADJUSTMENT_PERIOD_FLAG

                ,GL_PERIOD_YEAR

                ,GL_PERIOD_NUM

                ,GL_PERIOD_NAME

                ,GL_PERIOD_CODE

                ,GL_EFFECTIVE_PERIOD_NUM

                ,YEARTARGET

                ,PERIODTARGET

                ,IMP_ENTITY_TYPE

                ,IMP_ENTITY_ID

                ,IMP_ENTITY_NAME

                ,TRANS_ENTITY_TYPE

                ,TRANS_ENTITY_ID

                ,TRANS_ENTITY_NAME

                ,PRIOR_PERIOD_FLAG

                ,SOURCE_LEDGER_ID

              )

             

                      SELECT DISTINCT brl.LOADID PROCESS_ID

                      ,pp.PERIODKEY PERIODKEY

                      ,prd.PERIOD_ID

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

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

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

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

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

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

                      ,pp.YEARTARGET YEARTARGET

                      ,pp.PERIODTARGET PERIODTARGET

                      ,'PROCESS_BAL_IMP' IMP_ENTITY_TYPE

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

                      ,COALESCE(prd.PERIOD_NAME, ppsrc.GL_PERIOD_NAME,'0') 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

                      ,1 SOURCE_LEDGER_ID

                      FROM (

                        AIF_BAL_RULE_LOADS brl

                        INNER JOIN TPOVCATEGORY pc

                          ON pc.CATKEY = brl.CATKEY

                     

                        INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp

                          ON pp.PERIODFREQ = pc.CATFREQ

                          AND pp.PERIODKEY >= brl.START_PERIODKEY

                          AND pp.PERIODKEY <= brl.END_PERIODKEY

                          AND pp.INTSYSTEMKEY = 'POC5'

                      )

                      INNER JOIN TPOVPERIODSOURCE ppsrc

                        ON ppsrc.PERIODKEY = pp.PERIODKEY

                        AND ppsrc.MAPPING_TYPE = 'EXPLICIT'

                        AND ppsrc.SOURCE_SYSTEM_ID = 11

                        AND ppsrc.CALENDAR_ID IN ('10000')

                      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 = 'Month'

               

                        AND prd.ADJUSTMENT_PERIOD_FLAG = 'N'

                      WHERE brl.LOADID = 232

                      ORDER BY pp.PERIODKEY

                      ,GL_EFFECTIVE_PERIOD_NUM

                     

      2014-06-26 23:38:50,809 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', 'PROCESS_BAL_TRANS', 1L, u'POC5', u'EXPLICIT', 11L, u'10000', u'0', u'Month', 'N', 232]

      2014-06-26 23:38:50,809 DEBUG [AIF]: CommData.insertPeriods - END

      2014-06-26 23:38:50,815 DEBUG [AIF]: Comm.doScriptInit - START

      2014-06-26 23:38:50,975 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=C:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=C:\Oracle\FDMEE\inbox, LOCNAME=SUNR12_LOC, SOURCENAME=SUNR12, APPID=13, IMPORTFORMAT=SUNR12_IMPF, SCRIPTSDIR=C:\Oracle\FDMEE\data\scripts, EPMORACLEHOME=C:\Oracle\Middleware\EPMSystem11R1, RULEID=22, CATNAME=Actual, EPMORACLEINSTANCEHOME=C:\Oracle\Middleware\user_projects\epmsystem1, LOADID=232, PERIODNAME=Aug-13, IMPORTMODE=null, SOURCETYPE=EBS_R12, PERIODKEY=2013-08-31, TARGETAPPDB=NA, EXPORTFLAG=N, TARGETAPPNAME=POC5, LOCKEY=16, RULENAME=SUNR12_DR, OUTBOXDIR=C:\Oracle\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=5, FILEDIR=null, IMPORTFLAG=N}

      2014-06-26 23:38:50,975 DEBUG [AIF]: The EpmOracleHome is set to: C:\Oracle\Middleware\EPMSystem11R1

      2014-06-26 23:38:50,975 DEBUG [AIF]: The EpmOracleInstance is set to: C:\Oracle\Middleware\user_projects\epmsystem1

      2014-06-26 23:38:50,975 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

      2014-06-26 23:38:50,975 DEBUG [AIF]: The executeEventScript is set to: YES

      2014-06-26 23:38:50,975 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB

      2014-06-26 23:38:50,975 DEBUG [AIF]: The AppRootFolder is set to: C:\Oracle\FDMEE

      2014-06-26 23:38:50,975 DEBUG [AIF]: Comm.doScriptInit - END

      2014-06-26 23:38:50,975 DEBUG [AIF]: Comm.executeScript - START

      2014-06-26 23:38:50,975 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/BefCalculate.py

      2014-06-26 23:38:50,977 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-26 23:38:50,977 DEBUG [AIF]: The WindowsTempFolder is set to: c:\temp

      2014-06-26 23:38:50,977 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\BefCalculate.vbs

      2014-06-26 23:38:50,977 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-26 23:38:50,977 DEBUG [AIF]: Comm.executeScript - END

      2014-06-26 23:38:50,981 DEBUG [AIF]: CommData.moveData - START

      2014-06-26 23:38:50,983 DEBUG [AIF]: CommData.getPovList - START

      2014-06-26 23:38:50,983 DEBUG [AIF]:

              SELECT PARTITIONKEY

              ,PARTNAME

              ,CATKEY

              ,CATNAME

              ,PERIODKEY

              ,COALESCE(PERIODDESC, CONVERT(VARCHAR,PERIODKEY,120)) PERIODDESC

              ,RULE_ID

              ,RULE_NAME

              FROM (

                SELECT DISTINCT brl.PARTITIONKEY

                ,part.PARTNAME

                ,brl.CATKEY

                ,cat.CATNAME

                ,pprd.PERIODKEY

                ,pp.PERIODDESC

                ,brl.RULE_ID

                ,br.RULE_NAME

                FROM AIF_BAL_RULE_LOADS brl

                INNER JOIN AIF_BALANCE_RULES br

                  ON br.RULE_ID = brl.RULE_ID

                INNER JOIN TPOVPARTITION part

                  ON part.PARTITIONKEY = brl.PARTITIONKEY

                INNER JOIN TPOVCATEGORY cat

                  ON cat.CATKEY = brl.CATKEY

                INNER JOIN AIF_PROCESS_PERIODS pprd

                  ON pprd.PROCESS_ID = brl.LOADID

               

                LEFT OUTER JOIN TPOVPERIODADAPTOR pp

                  ON pp.PERIODKEY = pprd.PERIODKEY

                  AND pp.INTSYSTEMKEY = 'POC5'             

                WHERE brl.LOADID = 232

              ) q

              ORDER BY PARTITIONKEY

              ,CATKEY

              ,PERIODKEY

              ,RULE_ID

             

      2014-06-26 23:38:50,984 DEBUG [AIF]: CommData.getPovList - END

      2014-06-26 23:38:50,986 INFO  [AIF]:

      Move Data for Period 'Aug-13'

      2014-06-26 23:38:50,990 DEBUG [AIF]: CommData.updateWorkflow - START

      2014-06-26 23:38:50,990 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME = CURRENT_TIMESTAMP

             

              ,PROCESSSTATUS = 12

                ,PROCESSVAL = 0

                ,BLNVALDIRTY = 0

                ,PROCESSVALNOTE = NULL

              WHERE PARTITIONKEY = 16

              AND CATKEY = 5

              AND PERIODKEY = '2013-08-31'

              AND RULE_ID = 22

             

      2014-06-26 23:38:50,991 DEBUG [AIF]: CommData.updateWorkflow - END

      2014-06-26 23:38:50,991 DEBUG [AIF]:

                INSERT INTO TDATASEG_T (

                 

                PARTITIONKEY

        ,CATKEY

             ,PERIODKEY

          ,RULE_ID

            ,CURKEY

                ,DATAVIEW

           ,CALCACCTTYPE

      ,JOURNALID

                ,DESC1

              ,DESC2

                ,ACCOUNT

            ,ENTITY

             ,ICP

                ,UD1

                ,UD2

                ,UD3

                ,UD4

                ,UD5

                ,UD6

                ,UD7

                ,UD8

                ,UD9

                ,UD10

                ,UD11

               ,UD12

               ,UD13

               ,UD14

               ,UD15

                ,UD16

               ,UD17

               ,UD18

               ,UD19

               ,UD20

                ,ATTR1

              ,ATTR2

              ,ATTR3

              ,ATTR4

              ,ATTR5

                ,ATTR6

              ,ATTR7

              ,ATTR8

              ,ATTR9

              ,ATTR10

                ,ATTR11

             ,ATTR12

             ,ATTR13

                ,ARCHIVEID

          ,HASMEMOITEM

        ,STATICDATAKEY 

                ,AMOUNT

             ,AMOUNT_PTD

         ,AMOUNT_YTD

                ,CODE_COMBINATION_ID

           ,STAT_BALANCE_FLAG

               

                 

                  ,LOADID

                  ,ATTR14

                  ,CHANGESIGN

                  ,AMOUNTX

                  ,VALID_FLAG

                )

                SELECT

                PARTITIONKEY

        ,CATKEY

             ,PERIODKEY

          ,RULE_ID

            ,CURKEY

                ,DATAVIEW

           ,CALCACCTTYPE

      ,JOURNALID

                ,DESC1

              ,DESC2

                ,ACCOUNT

            ,ENTITY

             ,ICP

                ,UD1

                ,UD2

                ,UD3

                ,UD4

                ,UD5

                ,UD6

                ,UD7

                ,UD8

                ,UD9

                ,UD10

                ,UD11

               ,UD12

               ,UD13

               ,UD14

               ,UD15

                ,UD16

               ,UD17

               ,UD18

               ,UD19

               ,UD20

                ,ATTR1

              ,ATTR2

              ,ATTR3

              ,ATTR4

              ,ATTR5

                ,ATTR6

              ,ATTR7

              ,ATTR8

              ,ATTR9

              ,ATTR10

                ,ATTR11

             ,ATTR12

             ,ATTR13

                ,ARCHIVEID

          ,HASMEMOITEM

        ,STATICDATAKEY 

                ,AMOUNT

             ,AMOUNT_PTD

         ,AMOUNT_YTD

                ,CODE_COMBINATION_ID

           ,STAT_BALANCE_FLAG

               

               

                ,232 LOADID

                ,NULL ATTR14

                ,0 CHANGESIGN

                ,(CASE CHANGESIGN WHEN 1 THEN -AMOUNTX ELSE AMOUNTX END) AMOUNTX

                ,'Y' VALID_FLAG

                FROM TDATASEG

                WHERE PARTITIONKEY = 16

                AND CATKEY = 5

                AND RULE_ID = 22

                AND CALCACCTTYPE = 9

                AND LOADID < 232

               

                  AND PERIODKEY = '2013-08-31'

      2014-06-26 23:38:51,001 DEBUG [AIF]: Number of Rows inserted into TDATASEG_T: 300

      2014-06-26 23:38:51,001 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

                ,SEGMENT_FILTER_FLAG

                ,PARTITIONKEY

                ,CATKEY

                ,RULE_ID

                ,PERIODKEY

                ,EXPORT_TO_TARGET_FLAG

              )

              SELECT DISTINCT 232

              ,TARGET_APPLICATION_TYPE

              ,TARGET_APPLICATION_NAME

              ,PLAN_TYPE

              ,SOURCE_LEDGER_ID

              ,EPM_YEAR

              ,EPM_PERIOD

              ,SNAPSHOT_FLAG

              ,SEGMENT_FILTER_FLAG

              ,PARTITIONKEY

              ,CATKEY

              ,RULE_ID

              ,PERIODKEY

              ,'N'

              FROM AIF_APPL_LOAD_AUDIT

              WHERE PARTITIONKEY = 16

              AND CATKEY = 5

              AND RULE_ID = 22

              AND LOADID < 232

             

                  AND PERIODKEY = '2013-08-31'

      2014-06-26 23:38:51,002 DEBUG [AIF]: Number of Rows inserted into AIF_APPL_LOAD_AUDIT: 1

      2014-06-26 23:38:51,003 DEBUG [AIF]:

              INSERT INTO AIF_APPL_LOAD_PRD_AUDIT (

                LOADID

                ,SOURCE_LEDGER_ID

                ,GL_PERIOD_ID

                ,GL_PERIOD_YEAR

                ,DELTA_RUN_ID

                ,PARTITIONKEY

                ,CATKEY

                ,RULE_ID

                ,PERIODKEY

              )

              SELECT DISTINCT 232

              ,SOURCE_LEDGER_ID

              ,GL_PERIOD_ID

              ,GL_PERIOD_YEAR

              ,DELTA_RUN_ID

              ,PARTITIONKEY

              ,CATKEY

              ,RULE_ID

              ,PERIODKEY

              FROM AIF_APPL_LOAD_PRD_AUDIT

              WHERE PARTITIONKEY = 16

              AND CATKEY = 5

              AND RULE_ID = 22

              AND LOADID < 232

             

                  AND PERIODKEY = '2013-08-31'

      2014-06-26 23:38:51,003 DEBUG [AIF]: Number of Rows inserted into AIF_APPL_LOAD_PRD_AUDIT: 1

      2014-06-26 23:38:51,004 DEBUG [AIF]: CommData.moveData - END

      2014-06-26 23:38:51,007 DEBUG [AIF]: CommData.updateMemoItems - START

      2014-06-26 23:38:51,008 DEBUG [AIF]: memoItemExists (Aug-13): N

      2014-06-26 23:38:51,008 DEBUG [AIF]: CommData.updateMemoItems - END

      2014-06-26 23:38:51,008 DEBUG [AIF]: Comm.executeScript - START

      2014-06-26 23:38:51,008 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/AftCalculate.py

      2014-06-26 23:38:51,008 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-26 23:38:51,008 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\AftCalculate.vbs

      2014-06-26 23:38:51,008 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-26 23:38:51,008 DEBUG [AIF]: Comm.executeScript - END

      2014-06-26 23:38:51,008 DEBUG [AIF]: CommData.recalcData - END

      2014-06-26 23:38:51,031 DEBUG [AIF]: LogicGroup.createLogicAccounts - START

      2014-06-26 23:38:51,032 DEBUG [AIF]: Comm.executeScript - START

      2014-06-26 23:38:51,032 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/BefProcLogicGrp.py

      2014-06-26 23:38:51,032 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-26 23:38:51,033 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\BefProcLogicGrp.vbs

      2014-06-26 23:38:51,033 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-26 23:38:51,033 DEBUG [AIF]: Comm.executeScript - END

      2014-06-26 23:38:51,034 DEBUG [AIF]: CommData.getRuleInfo - START

      2014-06-26 23:38:51,034 DEBUG [AIF]: CommData.getRuleInfo - START

      2014-06-26 23:38:51,034 DEBUG [AIF]:

              SELECT brl.RULE_ID

              ,br.RULE_NAME

              ,brl.PARTITIONKEY

              ,brl.CATKEY

              ,part.PARTVALGROUP

              ,br.SOURCE_SYSTEM_ID

              ,ss.SOURCE_SYSTEM_TYPE

              ,CASE

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

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

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

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

                ELSE 'Y'

              END SOURCE_ADAPTER_FLAG

              ,app.APPLICATION_ID

              ,app.TARGET_APPLICATION_NAME

              ,app.TARGET_APPLICATION_TYPE

              ,app.DATA_LOAD_METHOD

              ,brl.PLAN_TYPE

              ,CASE brl.PLAN_TYPE

                WHEN 'PLAN1' THEN 1

                WHEN 'PLAN2' THEN 2

                WHEN 'PLAN3' THEN 3

                WHEN 'PLAN4' THEN 4

                WHEN 'PLAN5' THEN 5

                ELSE 0

              END PLAN_NUMBER

              ,br.INCL_ZERO_BALANCE_FLAG

              ,br.PERIOD_MAPPING_TYPE

              ,br.INCLUDE_ADJ_PERIODS_FLAG

              ,br.BALANCE_TYPE ACTUAL_FLAG

              ,br.AMOUNT_TYPE

              ,br.BALANCE_SELECTION

              ,br.BALANCE_METHOD_CODE

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

              ,br.CURRENCY_CODE

              ,br.BAL_SEG_VALUE_OPTION_CODE

              ,brl.EXECUTION_MODE

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

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

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

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

              ,CASE

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

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

                ELSE 'NONE'

              END LEDGER_GROUP_CODE

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

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

              ,br.LEDGER_GROUP

              ,(SELECT brd.DETAIL_CODE

                FROM AIF_BAL_RULE_DETAILS brd

                WHERE brd.RULE_ID = br.RULE_ID

                AND brd.DETAIL_TYPE = 'LEDGER'       

              ) PS_LEDGER

              ,CASE lg.LEDGER_TEMPLATE

                WHEN 'COMMITMENT' THEN 'Y'

                ELSE 'N'

              END KK_FLAG

              ,p.LAST_UPDATED_BY

              ,p.AIF_WEB_SERVICE_URL WEB_SERVICE_URL

              ,p.EPM_ORACLE_INSTANCE

              ,brl.JOURNAL_FLAG

              ,br.MULTI_PERIOD_FILE_FLAG

              ,br.IMPGROUPKEY

              FROM AIF_PROCESSES p

              INNER JOIN AIF_BAL_RULE_LOADS brl

                ON brl.LOADID = p.PROCESS_ID

              INNER JOIN AIF_BALANCE_RULES br

                ON br.RULE_ID = brl.RULE_ID

              INNER JOIN AIF_SOURCE_SYSTEMS ss

                ON ss.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID

              INNER JOIN AIF_TARGET_APPLICATIONS app

                ON app.APPLICATION_ID = brl.APPLICATION_ID

              INNER JOIN TPOVPARTITION part

                ON part.PARTITIONKEY = br.PARTITIONKEY

              INNER JOIN TBHVIMPGROUP imp

                ON imp.IMPGROUPKEY = part.PARTIMPGROUP

              LEFT OUTER JOIN AIF_COA_LEDGERS l

                ON l.SOURCE_SYSTEM_ID = p.SOURCE_SYSTEM_ID

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

              LEFT OUTER JOIN AIF_PS_SET_CNTRL_REC_STG scr

                ON scr.SOURCE_SYSTEM_ID = l.SOURCE_SYSTEM_ID

                AND scr.SETCNTRLVALUE = l.SOURCE_LEDGER_NAME

                AND scr.RECNAME = 'LED_GRP_TBL'

              LEFT OUTER JOIN AIF_PS_LED_GRP_TBL_STG lg

                ON lg.SOURCE_SYSTEM_ID = scr.SOURCE_SYSTEM_ID

                AND lg.SETID = scr.SETID

                AND lg.LEDGER_GROUP = br.LEDGER_GROUP

              WHERE p.PROCESS_ID = 232

             

      2014-06-26 23:38:51,036 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 = 13

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

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

           

            ORDER BY adim.BALANCE_COLUMN_NAME

           

      2014-06-26 23:38:51,037 DEBUG [AIF]: {'APPLICATION_ID': 13L, 'IMPORT_FROM_SOURCE_FLAG': u'N', 'PLAN_TYPE': None, 'RULE_NAME': u'SUNR12_DR', 'ACTUAL_FLAG': u'A', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'C:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 5L, 'BAL_SEG_VALUE_OPTION_CODE': u'ALL', 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'EBS_R12', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'POC5', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 11L, '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, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT2', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 81L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', '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'ICP', 'DIMENSION_ID': 83L}, 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': 78L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 80L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT5', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 82L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT3', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 76L}, 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': 79L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 16L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'SINGLE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': None, 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 22L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': u'STANDARD', 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://epmvirtual:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI'}

      2014-06-26 23:38:51,037 DEBUG [AIF]: CommData.getRuleInfo - END

      2014-06-26 23:38:51,037 DEBUG [AIF]:

              select part.PARTLOGICGROUP

              ,lgrp.CALCGROUPTYPE

              from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp

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

              and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY 

             

      2014-06-26 23:38:51,037 DEBUG [AIF]: CommData.getRuleInfo - END

      2014-06-26 23:38:51,038 DEBUG [AIF]: Comm.executeScript - START

      2014-06-26 23:38:51,038 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/AftProcLogicGrp.py

      2014-06-26 23:38:51,038 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-26 23:38:51,038 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\AftProcLogicGrp.vbs

      2014-06-26 23:38:51,038 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-26 23:38:51,038 DEBUG [AIF]: Comm.executeScript - END

      2014-06-26 23:38:51,038 DEBUG [AIF]: LogicGroup.createLogicAccounts - END

      2014-06-26 23:38:51,049 DEBUG [AIF]: CommData.mapData - START

      2014-06-26 23:38:51,049 DEBUG [AIF]: Comm.executeScript - START

      2014-06-26 23:38:51,049 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/BefProcMap.py

      2014-06-26 23:38:51,049 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-26 23:38:51,049 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\BefProcMap.vbs

      2014-06-26 23:38:51,049 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-26 23:38:51,050 DEBUG [AIF]: Comm.executeScript - END

      2014-06-26 23:38:51,051 DEBUG [AIF]: CommData.insertTransProcessDetails - START

      2014-06-26 23:38:51,051 DEBUG [AIF]:

                INSERT INTO AIF_PROCESS_DETAILS (

                  PROCESS_ID

                  ,ENTITY_TYPE

                  ,ENTITY_ID

                  ,ENTITY_NAME

                  ,ENTITY_NAME_ORDER

                  ,TARGET_TABLE_NAME

                  ,EXECUTION_START_TIME

                  ,EXECUTION_END_TIME

                  ,RECORDS_PROCESSED

                  ,STATUS

                  ,LAST_UPDATED_BY

                  ,LAST_UPDATE_DATE

                )

                SELECT PROCESS_ID

                ,ENTITY_TYPE

                ,ENTITY_ID

                ,ENTITY_NAME

                ,ENTITY_NAME_ORDER

                ,'TDATASEG' TARGET_TABLE_NAME

                ,CURRENT_TIMESTAMP EXECUTION_START_TIME

                ,NULL EXECUTION_END_TIME

                ,0 RECORDS_PROCESSED

                ,'PENDING' STATUS

                ,'admin' LAST_UPDATED_BY

                ,CURRENT_TIMESTAMP LAST_UPDATE_DATE

                FROM (

                  SELECT 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 = 232

                  AND PRIOR_PERIOD_FLAG = 'N'

                  GROUP BY PROCESS_ID

                  ,TRANS_ENTITY_TYPE

                  ,TRANS_ENTITY_NAME

                ) q

                ORDER BY ENTITY_NAME_ORDER

               

      2014-06-26 23:38:51,052 DEBUG [AIF]: CommData.insertTransProcessDetails - END

      2014-06-26 23:38:51,055 DEBUG [AIF]:

              DELETE FROM TDATAMAP_T

              WHERE LOADID < 232

              AND EXISTS (

                SELECT 1

                FROM AIF_PROCESSES p

                WHERE p.RULE_ID = 22

                AND p.PROCESS_ID = TDATAMAP_T.LOADID

              )

             

      2014-06-26 23:38:51,055 DEBUG [AIF]:

              DELETE FROM TDATASEG_T

              WHERE LOADID < 232

              AND EXISTS (

                SELECT 1

                FROM AIF_PROCESSES p

                WHERE p.RULE_ID = 22

                AND p.PROCESS_ID = TDATASEG_T.LOADID

              )

             

      2014-06-26 23:38:51,063 DEBUG [AIF]:

              DELETE FROM AIF_PROCESS_PERIODS

              WHERE PROCESS_ID < 232

              AND EXISTS (

                SELECT 1

                FROM AIF_PROCESSES p

                WHERE p.RULE_ID = 22

                AND p.PROCESS_ID = AIF_PROCESS_PERIODS.PROCESS_ID

              )

             

      2014-06-26 23:38:51,065 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START

      2014-06-26 23:38:51,066 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START

      2014-06-26 23:38:51,066 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 = 16

             

      2014-06-26 23:38:51,066 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END

      2014-06-26 23:38:51,066 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 232

              ,DATAKEY

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

              AND (RULE_ID IS NULL OR RULE_ID = 22)

              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

                  )

                )

              )

             

      2014-06-26 23:38:51,069 DEBUG [AIF]: CommData.targetMemberFilter - START

      2014-06-26 23:38:51,070 DEBUG [AIF]:

              DELETE FROM AIF_TARGET_APPL_DIM_MEMS

              WHERE APPLICATION_ID = 13

              AND CREATED_BY_RULE_ID = 22   

             

      2014-06-26 23:38:51,070 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

              )

              SELECT DISTINCT adim.APPLICATION_ID

              ,adim.DIMENSION_ID

              ,tdmt.TARGKEY MEMBER_NAME

              ,22 CREATED_BY_RULE_ID

              ,adim.VALID_FOR_PLAN1

              ,adim.VALID_FOR_PLAN2

              ,adim.VALID_FOR_PLAN3

              ,adim.VALID_FOR_PLAN4

              ,adim.VALID_FOR_PLAN5

              FROM TDATAMAP_T tdmt

              ,AIF_TARGET_APPL_DIMENSIONS adim

              ,AIF_DIMENSIONS dim 

              WHERE tdmt.LOADID = 232

              AND (

                tdmt.WHERECLAUSETYPE IS NULL

                OR tdmt.WHERECLAUSETYPE = 'BETWEEN'

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

              )

              AND adim.APPLICATION_ID = 13

              AND adim.BALANCE_COLUMN_NAME = tdmt.DIMNAME

              AND dim.DIMENSION_ID = adim.DIMENSION_ID

             

      2014-06-26 23:38:51,071 DEBUG [AIF]: CommData.targetMemberFilter - END

      2014-06-26 23:38:51,107 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START

      2014-06-26 23:38:51,110 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 = 232

                AND atad.APPLICATION_ID = 13

                AND tdm.PARTITIONKEY = 16

                AND tdm.TDATAMAPTYPE = 'ERP'

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

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

                AND atad.APPLICATION_ID = 13

                AND tdm.PARTITIONKEY = 16

                AND tdm.TDATAMAPTYPE = 'ERP'

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

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

              ) q

              ORDER BY CALC_SEQ

              ,DIMNAME

              ,SEQUENCE

              ,RULE_ID

              ,SYSTEM_GENERATED_FLAG

              ,SRCKEY

         

      2014-06-26 23:38:51,112 INFO  [AIF]:

      Map Data for Period 'Aug-13'

      2014-06-26 23:38:51,113 DEBUG [AIF]: Comm.updateProcessDetail - START

      2014-06-26 23:38:51,114 DEBUG [AIF]:

          UPDATE AIF_PROCESS_DETAILS

          SET STATUS = 'RUNNING'

          ,RECORDS_PROCESSED = CASE

            WHEN RECORDS_PROCESSED IS NULL THEN 0

            ELSE RECORDS_PROCESSED

          END + NULL

          ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

          ,LAST_UPDATED_BY = CASE

            WHEN ('admin' IS NULL) THEN LAST_UPDATED_BY

            ELSE 'admin'

          END

          ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

          WHERE PROCESS_ID = 232

          AND ENTITY_TYPE = 'PROCESS_BAL_TRANS'

          AND ENTITY_NAME = 'Aug-13'

         

      2014-06-26 23:38:51,115 DEBUG [AIF]: Comm.updateProcessDetail - END

      2014-06-26 23:38:51,117 DEBUG [AIF]:

            SELECT COUNT(*) ROW_COUNT

            FROM TDATASEG_T

            WHERE LOADID = 232

           

            AND (

             

            PARTITIONKEY = 16

            AND CATKEY = 5

            AND PERIODKEY = '2013-08-31'

            AND RULE_ID = 22

              AND VALID_FLAG = 'Y'

            )

      2014-06-26 23:38:51,124 INFO  [AIF]:

      Processing Mappings for Column 'ACCOUNT'

      2014-06-26 23:38:51,124 DEBUG [AIF]:

                  UPDATE TDATASEG_T

                  SET ACCOUNTX = (

                    SELECT tdm.TARGKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ACCOUNT'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ACCOUNT

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,ACCOUNTR = (

                    SELECT tdm.DATAKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ACCOUNT'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ACCOUNT

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,ACCOUNTF = 1

                  ,AMOUNTX = AMOUNTX * (

                    SELECT CASE tdm.CHANGESIGN

                      WHEN 1 THEN -1

                      ELSE 1

                    END

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ACCOUNT'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ACCOUNT

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,CHANGESIGN = (

                    SELECT CASE tdm.CHANGESIGN

                      WHEN 1 THEN CASE TDATASEG_T.CHANGESIGN

                        WHEN 1 THEN 0

                        WHEN 0 THEN 1

                        ELSE TDATASEG_T.CHANGESIGN

                      END

                      ELSE TDATASEG_T.CHANGESIGN

                    END

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ACCOUNT'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ACCOUNT

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,VALID_FLAG = CASE (

                    SELECT tdm.TARGKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ACCOUNT'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ACCOUNT

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  ) WHEN 'IGNORE' THEN 'I' ELSE VALID_FLAG END

                  WHERE LOADID = 232

                  AND PARTITIONKEY = 16

                  AND CATKEY = 5

                  AND (ACCOUNTX IS NULL OR ACCOUNTX = '')

                  AND EXISTS (

                    SELECT 1

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ACCOUNT'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ACCOUNT

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                 

                    AND PERIODKEY = '2013-08-31'

      2014-06-26 23:38:51,160 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 33

      2014-06-26 23:38:51,161 INFO  [AIF]:

      Processing Mappings for Column 'ENTITY'

      2014-06-26 23:38:51,161 DEBUG [AIF]:

                  UPDATE TDATASEG_T

                  SET ENTITYX = (

                    SELECT tdm.TARGKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ENTITY'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ENTITY

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,ENTITYR = (

                    SELECT tdm.DATAKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ENTITY'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ENTITY

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,ENTITYF = 1

                  ,AMOUNTX = AMOUNTX * (

                    SELECT CASE tdm.CHANGESIGN

                      WHEN 1 THEN -1

                      ELSE 1

                    END

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ENTITY'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ENTITY

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,CHANGESIGN = (

                    SELECT CASE tdm.CHANGESIGN

                      WHEN 1 THEN CASE TDATASEG_T.CHANGESIGN

                        WHEN 1 THEN 0

                        WHEN 0 THEN 1

                        ELSE TDATASEG_T.CHANGESIGN

                      END

                      ELSE TDATASEG_T.CHANGESIGN

                    END

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ENTITY'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ENTITY

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,VALID_FLAG = CASE (

                    SELECT tdm.TARGKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ENTITY'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ENTITY

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  ) WHEN 'IGNORE' THEN 'I' ELSE VALID_FLAG END

                  WHERE LOADID = 232

                  AND PARTITIONKEY = 16

                  AND CATKEY = 5

                  AND (ENTITYX IS NULL OR ENTITYX = '')

                  AND EXISTS (

                    SELECT 1

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ENTITY'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ENTITY

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                 

                    AND PERIODKEY = '2013-08-31'

      2014-06-26 23:38:51,200 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 235

      2014-06-26 23:38:51,201 INFO  [AIF]:

      Processing Mappings for Column 'ICP'

      2014-06-26 23:38:51,201 DEBUG [AIF]:

                  UPDATE TDATASEG_T

                  SET ICPX = (

                    SELECT tdm.TARGKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ICP'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ICP

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,ICPR = (

                    SELECT tdm.DATAKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ICP'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ICP

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,ICPF = 1

                  ,AMOUNTX = AMOUNTX * (

                    SELECT CASE tdm.CHANGESIGN

                      WHEN 1 THEN -1

                      ELSE 1

                    END

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ICP'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ICP

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,CHANGESIGN = (

                    SELECT CASE tdm.CHANGESIGN

                      WHEN 1 THEN CASE TDATASEG_T.CHANGESIGN

                        WHEN 1 THEN 0

                        WHEN 0 THEN 1

                        ELSE TDATASEG_T.CHANGESIGN

                      END

                      ELSE TDATASEG_T.CHANGESIGN

                    END

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ICP'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ICP

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,VALID_FLAG = CASE (

                    SELECT tdm.TARGKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ICP'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ICP

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  ) WHEN 'IGNORE' THEN 'I' ELSE VALID_FLAG END

                  WHERE LOADID = 232

                  AND PARTITIONKEY = 16

                  AND CATKEY = 5

                  AND (ICPX IS NULL OR ICPX = '')

                  AND EXISTS (

                    SELECT 1

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'ICP'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.ICP

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                 

                    AND PERIODKEY = '2013-08-31'

      2014-06-26 23:38:51,235 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 0

      2014-06-26 23:38:51,235 INFO  [AIF]:

      Processing Mappings for Column 'UD3'

      2014-06-26 23:38:51,236 DEBUG [AIF]:

                  UPDATE TDATASEG_T

                  SET UD3X = (

                    SELECT tdm.TARGKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'UD3'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.UD3

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,UD3R = (

                    SELECT tdm.DATAKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'UD3'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.UD3

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,UD3F = 1

                  ,AMOUNTX = AMOUNTX * (

                    SELECT CASE tdm.CHANGESIGN

                      WHEN 1 THEN -1

                      ELSE 1

                    END

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'UD3'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.UD3

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,CHANGESIGN = (

                    SELECT CASE tdm.CHANGESIGN

                      WHEN 1 THEN CASE TDATASEG_T.CHANGESIGN

                        WHEN 1 THEN 0

                        WHEN 0 THEN 1

                        ELSE TDATASEG_T.CHANGESIGN

                      END

                      ELSE TDATASEG_T.CHANGESIGN

                    END

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'UD3'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.UD3

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,VALID_FLAG = CASE (

                    SELECT tdm.TARGKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'UD3'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.UD3

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  ) WHEN 'IGNORE' THEN 'I' ELSE VALID_FLAG END

                  WHERE LOADID = 232

                  AND PARTITIONKEY = 16

                  AND CATKEY = 5

                  AND (UD3X IS NULL OR UD3X = '')

                  AND EXISTS (

                    SELECT 1

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'UD3'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.UD3

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                 

                    AND PERIODKEY = '2013-08-31'

      2014-06-26 23:38:51,271 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 0

      2014-06-26 23:38:51,272 INFO  [AIF]:

      Processing Mappings for Column 'UD4'

      2014-06-26 23:38:51,272 DEBUG [AIF]:

                  UPDATE TDATASEG_T

                  SET UD4X = (

                    SELECT tdm.TARGKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'UD4'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.UD4

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,UD4R = (

                    SELECT tdm.DATAKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'UD4'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.UD4

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,UD4F = 1

                  ,AMOUNTX = AMOUNTX * (

                    SELECT CASE tdm.CHANGESIGN

                      WHEN 1 THEN -1

                      ELSE 1

                    END

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'UD4'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.UD4

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,CHANGESIGN = (

                    SELECT CASE tdm.CHANGESIGN

                      WHEN 1 THEN CASE TDATASEG_T.CHANGESIGN

                        WHEN 1 THEN 0

                        WHEN 0 THEN 1

                        ELSE TDATASEG_T.CHANGESIGN

                      END

                      ELSE TDATASEG_T.CHANGESIGN

                    END

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'UD4'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.UD4

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                  ,VALID_FLAG = CASE (

                    SELECT tdm.TARGKEY

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'UD4'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.UD4

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  ) WHEN 'IGNORE' THEN 'I' ELSE VALID_FLAG END

                  WHERE LOADID = 232

                  AND PARTITIONKEY = 16

                  AND CATKEY = 5

                  AND (UD4X IS NULL OR UD4X = '')

                  AND EXISTS (

                    SELECT 1

                   

                  FROM TDATAMAP_T tdm

                  WHERE tdm.LOADID = TDATASEG_T.LOADID

                  AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

                  AND tdm.DIMNAME = 'UD4'

                  AND tdm.WHERECLAUSETYPE IS NULL

                  AND tdm.SRCKEY = TDATASEG_T.UD4

                    AND tdm.RULE_ID = TDATASEG_T.RULE_ID

                  )

                 

                    AND PERIODKEY = '2013-08-31'

      2014-06-26 23:38:51,301 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 0

      2014-06-26 23:38:51,301 DEBUG [AIF]: Comm.updateProcessDetail - START

      2014-06-26 23:38:51,301 DEBUG [AIF]:

          UPDATE AIF_PROCESS_DETAILS

          SET STATUS = 'SUCCESS'

          ,RECORDS_PROCESSED = CASE

            WHEN RECORDS_PROCESSED IS NULL THEN 0

            ELSE RECORDS_PROCESSED

          END + 300

          ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

          ,LAST_UPDATED_BY = CASE

            WHEN ('admin' IS NULL) THEN LAST_UPDATED_BY

            ELSE 'admin'

          END

          ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

          WHERE PROCESS_ID = 232

          AND ENTITY_TYPE = 'PROCESS_BAL_TRANS'

          AND ENTITY_NAME = 'Aug-13'

         

      2014-06-26 23:38:51,302 DEBUG [AIF]: Comm.updateProcessDetail - END

      2014-06-26 23:38:51,302 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END

      2014-06-26 23:38:51,303 DEBUG [AIF]:

            UPDATE TDATASEG_T

            SET ATTR14 = DATAKEY

            WHERE LOADID = 232

            AND PARTITIONKEY = 16

            AND CATKEY = 5

            AND PERIODKEY = '2013-08-31'

           

      2014-06-26 23:38:51,318 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START

      2014-06-26 23:38:51,318 INFO  [AIF]:

      Stage Data for Period 'Aug-13'

      2014-06-26 23:38:51,318 DEBUG [AIF]:

              DELETE FROM TDATAMAPSEG

              WHERE PARTITIONKEY = 16

              AND CATKEY = 5

              AND PERIODKEY = '2013-08-31'

              AND (

                TDATAMAPTYPE = 'ERP'

                OR (

                  TDATAMAPTYPE = 'MULTIDIM'

                  AND EXISTS (

                    SELECT 1

                    FROM TDATAMAPSEG parent

                    WHERE parent.PARTITIONKEY = TDATAMAPSEG.PARTITIONKEY

                    AND parent.DATAKEY = TDATAMAPSEG.TARGKEY

                    AND parent.CATKEY = TDATAMAPSEG.CATKEY

                    AND parent.PERIODKEY = TDATAMAPSEG.PERIODKEY

                    AND parent.TDATAMAPTYPE = 'ERP'

                  )

                )

              )

             

      2014-06-26 23:38:51,320 INFO  [AIF]: Number of Rows deleted from TDATAMAPSEG: 13

      2014-06-26 23:38:51,320 DEBUG [AIF]:

              INSERT INTO TDATAMAPSEG (

                DATAKEY

                ,PARTITIONKEY

                ,CATKEY

                ,PERIODKEY

                ,DIMNAME

                ,SRCKEY

                ,SRCDESC

                ,TARGKEY

                ,WHERECLAUSETYPE

                ,WHERECLAUSEVALUE

                ,CHANGESIGN

                ,SEQUENCE

                ,VBSCRIPT

                ,TDATAMAPTYPE

                ,SYSTEM_GENERATED_FLAG

              )

              SELECT DATAKEY

              ,PARTITIONKEY

              ,5

              ,'2013-08-31'

              ,DIMNAME

              ,SRCKEY

              ,SRCDESC

              ,TARGKEY

              ,WHERECLAUSETYPE

              ,WHERECLAUSEVALUE

              ,CHANGESIGN

              ,SEQUENCE

              ,VBSCRIPT

              ,TDATAMAPTYPE

              ,SYSTEM_GENERATED_FLAG

              FROM TDATAMAP_T

              WHERE LOADID = 232

             

      2014-06-26 23:38:51,320 INFO  [AIF]: Number of Rows inserted into TDATAMAPSEG: 13

      2014-06-26 23:38:51,320 DEBUG [AIF]:

              DELETE FROM TDATAMAP_T

              WHERE LOADID = 232

             

      2014-06-26 23:38:51,321 INFO  [AIF]: Number of Rows deleted from TDATAMAP_T: 13

      2014-06-26 23:38:51,321 DEBUG [AIF]:

                  DELETE FROM TDATASEG

                  WHERE LOADID < 232

                  AND PARTITIONKEY = 16

                  AND CATKEY = 5

                  AND RULE_ID = 22

                  AND PERIODKEY = '2013-08-31'

                 

      2014-06-26 23:38:51,330 INFO  [AIF]: Number of Rows deleted from TDATASEG: 300

      2014-06-26 23:38:51,330 DEBUG [AIF]:

                INSERT INTO TDATASEG (

                 

                DATAKEY

            ,PARTITIONKEY

            ,CATKEY

            ,PERIODKEY

            ,CURKEY

                ,DATAVIEW

            ,CALCACCTTYPE

            ,CHANGESIGN

            ,JOURNALID

                ,AMOUNT

            ,AMOUNTX

            ,AMOUNT_PTD

            ,AMOUNT_YTD

                ,DESC1

            ,DESC2

                ,ACCOUNT

            ,ACCOUNTX

            ,ACCOUNTR

            ,ACCOUNTF

                ,ENTITY

            ,ENTITYX

            ,ENTITYR

            ,ENTITYF

                ,ICP

            ,ICPX

            ,ICPR

            ,ICPF

                ,UD1

            ,UD1X

            ,UD1R

            ,UD1F

                ,UD2

            ,UD2X

            ,UD2R

            ,UD2F

                ,UD3

            ,UD3X

            ,UD3R

            ,UD3F

                ,UD4

            ,UD4X

            ,UD4R

            ,UD4F

                ,UD5

            ,UD5X

            ,UD5R

            ,UD5F

                ,UD6

            ,UD6X

            ,UD6R

            ,UD6F

                ,UD7

            ,UD7X

            ,UD7R

            ,UD7F

                ,UD8

            ,UD8X

            ,UD8R

            ,UD8F

                ,UD9

            ,UD9X

            ,UD9R

            ,UD9F

                ,UD10

            ,UD10X

            ,UD10R

            ,UD10F

                ,UD11

            ,UD11X

            ,UD11R

            ,UD11F

                ,UD12

            ,UD12X

            ,UD12R

            ,UD12F

                ,UD13

            ,UD13X

            ,UD13R

            ,UD13F

                ,UD14

            ,UD14X

            ,UD14R

            ,UD14F

                ,UD15

            ,UD15X

            ,UD15R

            ,UD15F

                ,UD16

            ,UD16X

            ,UD16R

            ,UD16F

                ,UD17

            ,UD17X

            ,UD17R

            ,UD17F

                ,UD18

            ,UD18X

            ,UD18R

            ,UD18F

                ,UD19

            ,UD19X

            ,UD19R

            ,UD19F

                ,UD20

            ,UD20X

            ,UD20R

            ,UD20F

                ,ATTR1

            ,ATTR2

            ,ATTR3

            ,ATTR4

            ,ATTR5

                ,ATTR6

            ,ATTR7

            ,ATTR8

            ,ATTR9

            ,ATTR10

                ,ATTR11

            ,ATTR12

            ,ATTR13

            ,ATTR14

                ,ARCHIVEID

            ,HASMEMOITEM

            ,STATICDATAKEY

                ,LOADID

            ,RULE_ID,

            CODE_COMBINATION_ID

                ,STAT_BALANCE_FLAG

            ,VALID_FLAG

               

                )

                SELECT

                DATAKEY

            ,PARTITIONKEY

            ,CATKEY

            ,PERIODKEY

            ,CURKEY

                ,DATAVIEW

            ,CALCACCTTYPE

            ,CHANGESIGN

            ,JOURNALID

                ,AMOUNT

            ,AMOUNTX

            ,AMOUNT_PTD

            ,AMOUNT_YTD

                ,DESC1

            ,DESC2

                ,ACCOUNT

            ,ACCOUNTX

            ,ACCOUNTR

            ,ACCOUNTF

                ,ENTITY

            ,ENTITYX

            ,ENTITYR

            ,ENTITYF

                ,ICP

            ,ICPX

            ,ICPR

            ,ICPF

                ,UD1

            ,UD1X

            ,UD1R

            ,UD1F

                ,UD2

            ,UD2X

            ,UD2R

            ,UD2F

                ,UD3

            ,UD3X

            ,UD3R

            ,UD3F

                ,UD4

            ,UD4X

            ,UD4R

            ,UD4F

                ,UD5

            ,UD5X

            ,UD5R

            ,UD5F

                ,UD6

            ,UD6X

            ,UD6R

            ,UD6F

                ,UD7

            ,UD7X

            ,UD7R

            ,UD7F

                ,UD8

            ,UD8X

            ,UD8R

            ,UD8F

                ,UD9

            ,UD9X

            ,UD9R

            ,UD9F

                ,UD10

            ,UD10X

            ,UD10R

            ,UD10F

                ,UD11

            ,UD11X

            ,UD11R

            ,UD11F

                ,UD12

            ,UD12X

            ,UD12R

            ,UD12F

                ,UD13

            ,UD13X

            ,UD13R

            ,UD13F

                ,UD14

            ,UD14X

            ,UD14R

            ,UD14F

                ,UD15

            ,UD15X

            ,UD15R

            ,UD15F

                ,UD16

            ,UD16X

            ,UD16R

            ,UD16F

                ,UD17

            ,UD17X

            ,UD17R

            ,UD17F

                ,UD18

            ,UD18X

            ,UD18R

            ,UD18F

                ,UD19

            ,UD19X

            ,UD19R

            ,UD19F

                ,UD20

            ,UD20X

            ,UD20R

            ,UD20F

                ,ATTR1

            ,ATTR2

            ,ATTR3

            ,ATTR4

            ,ATTR5

                ,ATTR6

            ,ATTR7

            ,ATTR8

            ,ATTR9

            ,ATTR10

                ,ATTR11

            ,ATTR12

            ,ATTR13

            ,ATTR14

                ,ARCHIVEID

            ,HASMEMOITEM

            ,STATICDATAKEY

                ,LOADID

            ,RULE_ID,

            CODE_COMBINATION_ID

                ,STAT_BALANCE_FLAG

            ,VALID_FLAG

               

                FROM TDATASEG_T

                WHERE LOADID = 232

                AND PARTITIONKEY = 16

                AND CATKEY = 5

                AND PERIODKEY = '2013-08-31'

               

      2014-06-26 23:38:51,346 INFO  [AIF]: Number of Rows inserted into TDATASEG: 300

      2014-06-26 23:38:51,346 DEBUG [AIF]:

              DELETE FROM TDATASEG_T

              WHERE LOADID = 232

              AND PARTITIONKEY = 16

              AND CATKEY = 5

              AND PERIODKEY = '2013-08-31'

             

      2014-06-26 23:38:51,356 INFO  [AIF]: Number of Rows deleted from TDATASEG_T: 300

      2014-06-26 23:38:51,356 DEBUG [AIF]: CommData.updateWorkflow - START

      2014-06-26 23:38:51,356 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME = CURRENT_TIMESTAMP

             

              ,PROCESSSTATUS = 1

                ,PROCESSIMP = 1

                ,BLNWCDIRTY = 0

                ,BLNLOGICDIRTY = 0

                ,BLNVALDIRTY = 0

                ,PROCESSIMPNOTE = 'Import Successful'

              WHERE PARTITIONKEY = 16

              AND CATKEY = 5

              AND PERIODKEY = '2013-08-31'

              AND RULE_ID = 22

             

      2014-06-26 23:38:51,358 DEBUG [AIF]: CommData.updateWorkflow - END

      2014-06-26 23:38:51,358 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END

      2014-06-26 23:38:51,358 DEBUG [AIF]: Comm.executeScript - START

      2014-06-26 23:38:51,358 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/AftProcMap.py

      2014-06-26 23:38:51,358 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-26 23:38:51,358 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\AftProcMap.vbs

      2014-06-26 23:38:51,358 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-26 23:38:51,358 DEBUG [AIF]: Comm.executeScript - END

      2014-06-26 23:38:51,358 DEBUG [AIF]: CommData.mapData - END

      2014-06-26 23:38:51,368 INFO  [AIF]: -------END IMPORT STEP-------

      2014-06-26 23:38:51,378 INFO  [AIF]: -------START VALIDATE STEP-------

      2014-06-26 23:38:51,393 DEBUG [AIF]: CommData.validateData - START

      2014-06-26 23:38:51,394 DEBUG [AIF]: Comm.executeScript - START

      2014-06-26 23:38:51,394 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/BefValidate.py

      2014-06-26 23:38:51,394 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-26 23:38:51,395 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\BefValidate.vbs

      2014-06-26 23:38:51,395 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-26 23:38:51,395 DEBUG [AIF]: Comm.executeScript - END

      2014-06-26 23:38:51,398 DEBUG [AIF]: CommMap.validateData - START

      2014-06-26 23:38:51,399 INFO  [AIF]:

      Validate Data Mappings for Period 'Aug-13'

      2014-06-26 23:38:51,399 DEBUG [AIF]:

            SELECT COUNT(*) ROW_COUNT

            FROM TDATASEG

            WHERE LOADID = 232

           

            AND (

             

            PARTITIONKEY = 16

            AND CATKEY = 5

            AND PERIODKEY = '2013-08-31'

            AND RULE_ID = 22

              AND VALID_FLAG = 'Y'

            )

      2014-06-26 23:38:51,414 DEBUG [AIF]: CommData.updateWorkflow - START

      2014-06-26 23:38:51,415 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 = 16

          AND tlp.CATKEY = 5

          AND tlp.PERIODKEY = '2013-08-31'

          AND tlp.RULE_ID = 22

          AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

         

      2014-06-26 23:38:51,415 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME = CURRENT_TIMESTAMP

             

              ,PROCESSSTATUS = 10

                ,PROCESSVAL = 0

                ,PROCESSEXP = 0

                ,PROCESSENTLOAD = 0

                ,PROCESSENTVAL = 0

                ,BLNVALDIRTY = 0

                ,PROCESSVALNOTE = NULL

                ,PROCESSEXPNOTE = NULL

                ,PROCESSENTLOADNOTE = NULL

                ,PROCESSENTVALNOTE = NULL

              WHERE PARTITIONKEY = 16

              AND CATKEY = 5

              AND PERIODKEY = '2013-08-31'

              AND RULE_ID = 22

             

      2014-06-26 23:38:51,416 DEBUG [AIF]: CommData.updateWorkflow - END

      2014-06-26 23:38:51,416 DEBUG [AIF]:

                      UPDATE TDATASEG

                      SET VALID_FLAG = 'N'

                      WHERE 1=1

                      AND (

                        (1=0)

                        OR (TDATASEG.ACCOUNTX IS NULL OR TDATASEG.ACCOUNTX = '')

                       

                        OR (TDATASEG.ENTITYX IS NULL OR TDATASEG.ENTITYX = '')

                       

                        OR (TDATASEG.ICPX IS NULL OR TDATASEG.ICPX = '')

                       

                        OR (TDATASEG.UD1X IS NULL OR TDATASEG.UD1X = '')

                       

                        OR (TDATASEG.UD2X IS NULL OR TDATASEG.UD2X = '')

                       

                        OR (TDATASEG.UD3X IS NULL OR TDATASEG.UD3X = '')

                       

                        OR (TDATASEG.UD4X IS NULL OR TDATASEG.UD4X = '')

                       

                      )

                      AND LOADID = 232

                      AND PARTITIONKEY = 16

                      AND CATKEY = 5

                      AND PERIODKEY = '2013-08-31'

                      AND VALID_FLAG = 'Y'

                     

                        AND CALCACCTTYPE > 0

                       

      2014-06-26 23:38:51,454 INFO  [AIF]: Data Rows Marked as Invalid: 300

      2014-06-26 23:38:51,454 ERROR [AIF]: Error: Data rows with unmapped dimensions exist for Period 'Aug-13'

      2014-06-26 23:38:51,454 DEBUG [AIF]: CommData.updateWorkflow - START

      2014-06-26 23:38:51,454 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME = CURRENT_TIMESTAMP

             

              ,PROCESSSTATUS = 12

                ,PROCESSVAL = 0

                ,BLNVALDIRTY = 0

                ,PROCESSVALNOTE = 'Error = 300 records'

              WHERE PARTITIONKEY = 16

              AND CATKEY = 5

              AND PERIODKEY = '2013-08-31'

              AND RULE_ID = 22

             

      2014-06-26 23:38:51,455 DEBUG [AIF]: CommData.updateWorkflow - END

      2014-06-26 23:38:51,455 INFO  [AIF]: Total Data Rows available for Export to Target: 0

      2014-06-26 23:38:51,456 FATAL [AIF]: Error in CommMap.validateData

      Traceback (most recent call last):

        File "<string>", line 2729, in validateData

      RuntimeError: [u"Error: Data rows with unmapped dimensions exist for Period 'Aug-13'"]

       

      2014-06-26 23:38:51,456 FATAL [AIF]: Error in CommData.validateData

      Traceback (most recent call last):

        File "<string>", line 4144, in validateData

        File "<string>", line 2729, in validateData

      RuntimeError: [u"Error: Data rows with unmapped dimensions exist for Period 'Aug-13'"]

       

      2014-06-26 23:38:51,456 DEBUG [AIF]: Comm.executeScript - START

      2014-06-26 23:38:51,457 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/AftValidate.py

      2014-06-26 23:38:51,457 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-26 23:38:51,457 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\AftValidate.vbs

      2014-06-26 23:38:51,457 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-26 23:38:51,457 DEBUG [AIF]: Comm.executeScript - END

      2014-06-26 23:38:51,475 DEBUG [AIF]: Comm.finalizeProcess - START

      2014-06-26 23:38:51,477 DEBUG [AIF]: CommData.updateRuleStatus - START

      2014-06-26 23:38:51,477 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 = 232

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

              )

              WHEN 0 THEN 'SUCCESS'

              ELSE (

                SELECT MIN(pd.STATUS)

                FROM AIF_PROCESS_DETAILS pd

                WHERE pd.PROCESS_ID = 232

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

              )

              END

            ELSE 'FAILED'

          END

          WHERE RULE_ID = 22

         

      2014-06-26 23:38:51,478 DEBUG [AIF]: CommData.updateRuleStatus - END

      2014-06-26 23:38:51,478 FATAL [AIF]: Error in COMM Validate Data

      2014-06-26 23:38:51,479 DEBUG [AIF]: Comm.updateProcess - START

      2014-06-26 23:38:51,480 DEBUG [AIF]: Comm.updateProcess - END

       

       

       

      Thanks in advance

        • 1. Re: Error on validation for loading ebs data
          Francisco Amores

          Hi,

           

          please review Validation Error tab in data load workbench to see which unmapped members you have. Then fix them until you get success validation.

           

          Logs shows how you have unmapped dimension members.

           

          2014-06-26 23:38:51,456 FATAL [AIF]: Error in CommMap.validateData

          Traceback (most recent call last):

            File "<string>", line 2729, in validateData

          RuntimeError: [u"Error: Data rows with unmapped dimensions exist for Period 'Aug-13'"]