1 Reply Latest reply on Jun 24, 2014 5:10 PM by Francisco Amores

    validate error in fdmee while loading flat file

    1050864

      Hi,

       

      I am trying to load the flat file into HFM application ..

      Import successfull but Validate shows 0 errors not showing successfull..

       

      I attached the log file below ..

       

      2014-06-24 01:43:33,636 INFO  [AIF]: FDMEE Process Start, Process ID: 197

      2014-06-24 01:43:33,637 INFO  [AIF]: FDMEE Logging Level: 5

      2014-06-24 01:43:33,637 INFO  [AIF]: FDMEE Log File: C:\Oracle\FDMEE\outbox\logs\POC2_197.log

      2014-06-24 01:43:33,637 INFO  [AIF]: User:admin

      2014-06-24 01:43:33,637 INFO  [AIF]: Location:testfilelc (Partitionkey:14)

      2014-06-24 01:43:33,637 INFO  [AIF]: Period Name:JAN (Period Key:1/31/10 12:00 AM)

      2014-06-24 01:43:33,637 INFO  [AIF]: Category Name:Actual (Category key:5)

      2014-06-24 01:43:33,637 INFO  [AIF]: Rule Name:testfiledlr (Rule ID:20)

      2014-06-24 01:43:34,332 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-24 01:43:34,332 INFO  [AIF]: Java Platform: java1.6.0_37

      2014-06-24 01:43:34,332 INFO  [AIF]: Log File Encoding: UTF-8

      2014-06-24 01:43:35,448 INFO  [AIF]: -------START IMPORT STEP-------

      2014-06-24 01:43:35,474 DEBUG [AIF]: CommData.recalcData - START

      2014-06-24 01:43:35,477 DEBUG [AIF]: CommData.getRuleInfo - START

      2014-06-24 01:43:35,479 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 = 197

            

      2014-06-24 01:43:35,483 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 = 8

            INNER JOIN AIF_DIMENSIONS dim

              ON dim.DIMENSION_ID = adim.DIMENSION_ID

            LEFT OUTER JOIN TBHVIMPITEMERPI tiie

              ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP

              AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME

              AND tiie.IMPMAPTYPE = 'ERP'

            WHERE tpp.PARTITIONKEY = 14

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

          

            ORDER BY adim.BALANCE_COLUMN_NAME

          

      2014-06-24 01:43:35,484 DEBUG [AIF]: {'APPLICATION_ID': 8L, 'IMPORT_FROM_SOURCE_FLAG': u'N', 'PLAN_TYPE': None, 'RULE_NAME': u'testfiledlr', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'C:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 5L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'POC2', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'TESTFILE', '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'], 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 52L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 49L}, 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': 51L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 47L}, 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': 50L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 14L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': None, 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 20L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://epmvirtual:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI'}

      2014-06-24 01:43:35,484 DEBUG [AIF]: CommData.getRuleInfo - END

      2014-06-24 01:43:35,487 DEBUG [AIF]: CommData.insertFilePeriods - START

      2014-06-24 01:43:35,490 DEBUG [AIF]: commAppPeriodMappingExists: Y

      2014-06-24 01:43:35,491 DEBUG [AIF]:

        select PERIODKEY,PERIODDESC,YEARTARGET,PERIODTARGET,FILE_NAME_STATIC,FILE_NAME_SUFFIX_TYPE,FILE_NAME_DATE_FORMAT,GL_EFFECTIVE_PERIOD_NUM

        from (

              SELECT pp.PERIODKEY

                ,pp.PERIODDESC

                ,pp.YEARTARGET YEARTARGET

                ,pp.PERIODTARGET PERIODTARGET        

                ,brl.FILE_NAME_STATIC

                ,brl.FILE_NAME_SUFFIX_TYPE

                ,brl.FILE_NAME_DATE_FORMAT

                ,coalesce(brp.parameter_id,0) GL_EFFECTIVE_PERIOD_NUM

                FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                INNER JOIN TPOVCATEGORY pc

                  ON pc.CATKEY = brl.CATKEY

              

                INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp

                  ON pp.PERIODFREQ = pc.CATFREQ          

                  AND pp.INTSYSTEMKEY = 'POC2'

                INNER JOIN AIF_BAL_RULE_LOAD_PARAMS brp

                  ON brp.loadid = brl.loadid

                  AND convert(varchar,brp.parameter_value,111) = pp.periodkey

                WHERE brl.LOADID = 197  

                  AND br.rule_id = brl.rule_id

                  AND br.MULTI_PERIOD_FILE_FLAG = 'Y'

                

                  UNION

                

                SELECT pp.PERIODKEY

                ,pp.PERIODDESC

                ,pp.YEARTARGET YEARTARGET

                ,pp.PERIODTARGET PERIODTARGET        

                ,brl.FILE_NAME_STATIC

                ,brl.FILE_NAME_SUFFIX_TYPE

                ,brl.FILE_NAME_DATE_FORMAT

                ,0 GL_EFFECTIVE_PERIOD_NUM

                FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                INNER JOIN TPOVCATEGORY pc

                  ON pc.CATKEY = brl.CATKEY

              

                INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp

                  ON pp.PERIODFREQ = pc.CATFREQ          

                  AND pp.INTSYSTEMKEY = 'POC2'

                  AND pp.PERIODKEY >= brl.START_PERIODKEY

                  AND pp.PERIODKEY <= brl.END_PERIODKEY       

                WHERE brl.LOADID = 197  

                  AND br.rule_id = brl.rule_id

                  AND br.MULTI_PERIOD_FILE_FLAG = 'Y'

                  AND 0 = (SELECT count(*)

                            FROM AIF_BALANCE_RULES br2, AIF_BAL_RULE_LOADS brl2

                            INNER JOIN TPOVCATEGORY pc2

                              ON pc2.CATKEY = brl2.CATKEY

                         

                INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp2

                  ON pp2.PERIODFREQ = pc2.CATFREQ          

                  AND pp2.INTSYSTEMKEY = 'POC2'

                            INNER JOIN AIF_BAL_RULE_LOAD_PARAMS brp2

                              ON brp2.loadid = brl2.loadid

                              AND convert(varchar,brp2.parameter_value,111) = pp2.periodkey

                            WHERE brl2.LOADID = brl.LOADID  

                              AND br2.rule_id = brl2.rule_id

                              AND br2.MULTI_PERIOD_FILE_FLAG = 'Y'

                            )

                          

                 ) qrslt

               

                UNION

       

                 SELECT pp.PERIODKEY

                 ,pp.PERIODDESC

                ,pp.YEARTARGET YEARTARGET

                ,pp.PERIODTARGET PERIODTARGET

                ,brl.FILE_NAME_STATIC

                ,brl.FILE_NAME_SUFFIX_TYPE

                ,brl.FILE_NAME_DATE_FORMAT

                , 0 GL_EFFECTIVE_PERIOD_NUM

                FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                INNER JOIN TPOVCATEGORY pc

                  ON pc.CATKEY = brl.CATKEY

              

                INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp

                  ON pp.PERIODFREQ = pc.CATFREQ          

                  AND pp.INTSYSTEMKEY = 'POC2'

                  AND pp.PERIODKEY >= brl.START_PERIODKEY

                  AND pp.PERIODKEY <= brl.END_PERIODKEY

                WHERE brl.LOADID = 197            

                  AND (br.MULTI_PERIOD_FILE_FLAG is null or br.MULTI_PERIOD_FILE_FLAG <> 'Y' )

                  AND br.rule_id = brl.rule_id

                

                ORDER BY PERIODKEY

              

      2014-06-24 01:43:35,493 INFO  [AIF]: File Name: dummy.txt

      2014-06-24 01:43:35,493 DEBUG [AIF]:

              INSERT INTO AIF_PROCESS_PERIODS (

                PROCESS_ID

                ,PERIODKEY

                ,ADJUSTMENT_PERIOD_FLAG

                ,GL_PERIOD_YEAR

                ,GL_PERIOD_CODE

              

                ,GL_PERIOD_NAME

                ,GL_PERIOD_NUM

                ,GL_EFFECTIVE_PERIOD_NUM

                ,YEARTARGET

                ,PERIODTARGET

              

                ,IMP_ENTITY_TYPE

                ,IMP_ENTITY_NAME

                ,TRANS_ENTITY_TYPE

                ,TRANS_ENTITY_NAME

                ,PRIOR_PERIOD_FLAG

              ) VALUES (197,'2010-01-31','N',0,'0' ,'0',0,1,'2010','January', 'PROCESS_BAL_IMP_FILE','dummy.txt','PROCESS_BAL_TRANS','JAN','N' )

            

      2014-06-24 01:43:35,494 DEBUG [AIF]: CommData.insertFilePeriods - END

      2014-06-24 01:43:35,499 DEBUG [AIF]: Comm.doScriptInit - START

      2014-06-24 01:43:35,676 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=C:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=C:\Oracle\FDMEE\inbox, LOCNAME=testfilelc, SOURCENAME=File, APPID=8, IMPORTFORMAT=TESTFILE, SCRIPTSDIR=C:\Oracle\FDMEE\data\scripts, EPMORACLEHOME=C:\Oracle\Middleware\EPMSystem11R1, RULEID=20, CATNAME=Actual, EPMORACLEINSTANCEHOME=C:\Oracle\Middleware\user_projects\epmsystem1, LOADID=197, PERIODNAME=JAN, IMPORTMODE=null, SOURCETYPE=FILE, PERIODKEY=2010-01-31, TARGETAPPDB=NA, EXPORTFLAG=N, TARGETAPPNAME=POC2, FILENAME=null, LOCKEY=14, RULENAME=testfiledlr, OUTBOXDIR=C:\Oracle\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=5, FILEDIR=null, IMPORTFLAG=N}

      2014-06-24 01:43:35,677 DEBUG [AIF]: The EpmOracleHome is set to: C:\Oracle\Middleware\EPMSystem11R1

      2014-06-24 01:43:35,677 DEBUG [AIF]: The EpmOracleInstance is set to: C:\Oracle\Middleware\user_projects\epmsystem1

      2014-06-24 01:43:35,677 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

      2014-06-24 01:43:35,677 DEBUG [AIF]: The executeEventScript is set to: YES

      2014-06-24 01:43:35,677 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB

      2014-06-24 01:43:35,677 DEBUG [AIF]: The AppRootFolder is set to: C:\Oracle\FDMEE

      2014-06-24 01:43:35,677 DEBUG [AIF]: Comm.doScriptInit - END

      2014-06-24 01:43:35,677 DEBUG [AIF]: Comm.executeScript - START

      2014-06-24 01:43:35,677 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/BefCalculate.py

      2014-06-24 01:43:35,679 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-24 01:43:35,679 DEBUG [AIF]: The WindowsTempFolder is set to: c:\temp

      2014-06-24 01:43:35,679 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\BefCalculate.vbs

      2014-06-24 01:43:35,679 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-24 01:43:35,679 DEBUG [AIF]: Comm.executeScript - END

      2014-06-24 01:43:35,682 DEBUG [AIF]: CommData.moveData - START

      2014-06-24 01:43:35,684 DEBUG [AIF]: CommData.getPovList - START

      2014-06-24 01:43:35,684 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 = 'POC2'            

                WHERE brl.LOADID = 197

              ) q

              ORDER BY PARTITIONKEY

              ,CATKEY

              ,PERIODKEY

              ,RULE_ID

            

      2014-06-24 01:43:35,685 DEBUG [AIF]: CommData.getPovList - END

      2014-06-24 01:43:35,686 INFO  [AIF]:

      Move Data for Period 'JAN'

      2014-06-24 01:43:35,689 DEBUG [AIF]: CommData.updateWorkflow - START

      2014-06-24 01:43:35,690 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME = CURRENT_TIMESTAMP

            

              ,PROCESSSTATUS = 12

                ,PROCESSVAL = 0

                ,BLNVALDIRTY = 0

                ,PROCESSVALNOTE = NULL

              WHERE PARTITIONKEY = 14

              AND CATKEY = 5

              AND PERIODKEY = '2010-01-31'

              AND RULE_ID = 20

            

      2014-06-24 01:43:35,691 DEBUG [AIF]: CommData.updateWorkflow - END

      2014-06-24 01:43:35,692 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

              

              

                ,197 LOADID

                ,NULL ATTR14

                ,0 CHANGESIGN

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

                ,'Y' VALID_FLAG

                FROM TDATASEG

                WHERE PARTITIONKEY = 14

                AND CATKEY = 5

                AND RULE_ID = 20

                AND CALCACCTTYPE = 9

                AND LOADID < 197

              

                  AND PERIODKEY = '2010-01-31'

      2014-06-24 01:43:35,692 DEBUG [AIF]: Number of Rows inserted into TDATASEG_T: 1

      2014-06-24 01:43:35,693 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 197

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

              AND CATKEY = 5

              AND RULE_ID = 20

              AND LOADID < 197

            

                  AND PERIODKEY = '2010-01-31'

      2014-06-24 01:43:35,694 DEBUG [AIF]: Number of Rows inserted into AIF_APPL_LOAD_AUDIT: 1

      2014-06-24 01:43:35,694 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 197

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

              AND CATKEY = 5

              AND RULE_ID = 20

              AND LOADID < 197

            

                  AND PERIODKEY = '2010-01-31'

      2014-06-24 01:43:35,694 DEBUG [AIF]: Number of Rows inserted into AIF_APPL_LOAD_PRD_AUDIT: 0

      2014-06-24 01:43:35,695 DEBUG [AIF]: CommData.moveData - END

      2014-06-24 01:43:35,698 DEBUG [AIF]: CommData.updateMemoItems - START

      2014-06-24 01:43:35,699 DEBUG [AIF]: memoItemExists (JAN): N

      2014-06-24 01:43:35,699 DEBUG [AIF]: CommData.updateMemoItems - END

      2014-06-24 01:43:35,699 DEBUG [AIF]: Comm.executeScript - START

      2014-06-24 01:43:35,700 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/AftCalculate.py

      2014-06-24 01:43:35,700 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-24 01:43:35,700 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\AftCalculate.vbs

      2014-06-24 01:43:35,700 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-24 01:43:35,700 DEBUG [AIF]: Comm.executeScript - END

      2014-06-24 01:43:35,700 DEBUG [AIF]: CommData.recalcData - END

      2014-06-24 01:43:35,719 DEBUG [AIF]: LogicGroup.createLogicAccounts - START

      2014-06-24 01:43:35,719 DEBUG [AIF]: Comm.executeScript - START

      2014-06-24 01:43:35,720 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/BefProcLogicGrp.py

      2014-06-24 01:43:35,720 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-24 01:43:35,720 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\BefProcLogicGrp.vbs

      2014-06-24 01:43:35,720 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-24 01:43:35,720 DEBUG [AIF]: Comm.executeScript - END

      2014-06-24 01:43:35,721 DEBUG [AIF]: CommData.getRuleInfo - START

      2014-06-24 01:43:35,721 DEBUG [AIF]: CommData.getRuleInfo - START

      2014-06-24 01:43:35,721 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 = 197

            

      2014-06-24 01:43:35,723 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 = 8

            INNER JOIN AIF_DIMENSIONS dim

              ON dim.DIMENSION_ID = adim.DIMENSION_ID

            LEFT OUTER JOIN TBHVIMPITEMERPI tiie

              ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP

              AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME

              AND tiie.IMPMAPTYPE = 'ERP'

            WHERE tpp.PARTITIONKEY = 14

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

          

            ORDER BY adim.BALANCE_COLUMN_NAME

          

      2014-06-24 01:43:35,724 DEBUG [AIF]: {'APPLICATION_ID': 8L, 'IMPORT_FROM_SOURCE_FLAG': u'N', 'PLAN_TYPE': None, 'RULE_NAME': u'testfiledlr', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'C:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 5L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'POC2', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'TESTFILE', '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'], 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 52L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 49L}, 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': 51L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 47L}, 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': 50L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 14L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': None, 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 20L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://epmvirtual:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI'}

      2014-06-24 01:43:35,724 DEBUG [AIF]: CommData.getRuleInfo - END

      2014-06-24 01:43:35,724 DEBUG [AIF]:

              select part.PARTLOGICGROUP

              ,lgrp.CALCGROUPTYPE

              from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp

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

              and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY

            

      2014-06-24 01:43:35,724 DEBUG [AIF]: CommData.getRuleInfo - END

      2014-06-24 01:43:35,725 DEBUG [AIF]: Comm.executeScript - START

      2014-06-24 01:43:35,725 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/AftProcLogicGrp.py

      2014-06-24 01:43:35,725 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-24 01:43:35,725 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\AftProcLogicGrp.vbs

      2014-06-24 01:43:35,725 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-24 01:43:35,725 DEBUG [AIF]: Comm.executeScript - END

      2014-06-24 01:43:35,725 DEBUG [AIF]: LogicGroup.createLogicAccounts - END

      2014-06-24 01:43:35,740 DEBUG [AIF]: CommData.mapData - START

      2014-06-24 01:43:35,740 DEBUG [AIF]: Comm.executeScript - START

      2014-06-24 01:43:35,740 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/BefProcMap.py

      2014-06-24 01:43:35,740 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-24 01:43:35,740 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\BefProcMap.vbs

      2014-06-24 01:43:35,740 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-24 01:43:35,740 DEBUG [AIF]: Comm.executeScript - END

      2014-06-24 01:43:35,742 DEBUG [AIF]: CommData.insertTransProcessDetails - START

      2014-06-24 01:43:35,743 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 = 197

                  AND PRIOR_PERIOD_FLAG = 'N'

                  GROUP BY PROCESS_ID

                  ,TRANS_ENTITY_TYPE

                  ,TRANS_ENTITY_NAME

                ) q

                ORDER BY ENTITY_NAME_ORDER

              

      2014-06-24 01:43:35,746 DEBUG [AIF]: CommData.insertTransProcessDetails - END

      2014-06-24 01:43:35,749 DEBUG [AIF]:

              DELETE FROM TDATAMAP_T

              WHERE LOADID < 197

              AND EXISTS (

                SELECT 1

                FROM AIF_PROCESSES p

                WHERE p.RULE_ID = 20

                AND p.PROCESS_ID = TDATAMAP_T.LOADID

              )

            

      2014-06-24 01:43:35,749 DEBUG [AIF]:

              DELETE FROM TDATASEG_T

              WHERE LOADID < 197

              AND EXISTS (

                SELECT 1

                FROM AIF_PROCESSES p

                WHERE p.RULE_ID = 20

                AND p.PROCESS_ID = TDATASEG_T.LOADID

              )

            

      2014-06-24 01:43:35,750 DEBUG [AIF]:

              DELETE FROM AIF_PROCESS_PERIODS

              WHERE PROCESS_ID < 197

              AND EXISTS (

                SELECT 1

                FROM AIF_PROCESSES p

                WHERE p.RULE_ID = 20

                AND p.PROCESS_ID = AIF_PROCESS_PERIODS.PROCESS_ID

              )

            

      2014-06-24 01:43:35,753 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START

      2014-06-24 01:43:35,754 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START

      2014-06-24 01:43:35,755 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 = 14

            

      2014-06-24 01:43:35,755 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END

      2014-06-24 01:43:35,755 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 197

              ,DATAKEY

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

              AND (RULE_ID IS NULL OR RULE_ID = 20)

              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-24 01:43:35,758 DEBUG [AIF]: CommData.targetMemberFilter - START

      2014-06-24 01:43:35,759 DEBUG [AIF]:

              DELETE FROM AIF_TARGET_APPL_DIM_MEMS

              WHERE APPLICATION_ID = 8

              AND CREATED_BY_RULE_ID = 20  

            

      2014-06-24 01:43:35,759 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

              ,20 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 = 197

              AND (

                tdmt.WHERECLAUSETYPE IS NULL

                OR tdmt.WHERECLAUSETYPE = 'BETWEEN'

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

              )

              AND adim.APPLICATION_ID = 8

              AND adim.BALANCE_COLUMN_NAME = tdmt.DIMNAME

              AND dim.DIMENSION_ID = adim.DIMENSION_ID

            

      2014-06-24 01:43:35,760 DEBUG [AIF]: CommData.targetMemberFilter - END

      2014-06-24 01:43:35,790 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START

      2014-06-24 01:43:35,792 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 = 197

                AND atad.APPLICATION_ID = 8

                AND tdm.PARTITIONKEY = 14

                AND tdm.TDATAMAPTYPE = 'ERP'

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

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

                AND atad.APPLICATION_ID = 8

                AND tdm.PARTITIONKEY = 14

                AND tdm.TDATAMAPTYPE = 'ERP'

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

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

              ) q

              ORDER BY CALC_SEQ

              ,DIMNAME

              ,SEQUENCE

              ,RULE_ID

              ,SYSTEM_GENERATED_FLAG

              ,SRCKEY

        

      2014-06-24 01:43:35,796 INFO  [AIF]:

      Map Data for Period 'JAN'

      2014-06-24 01:43:35,796 DEBUG [AIF]: Comm.updateProcessDetail - START

      2014-06-24 01:43:35,797 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 = 197

          AND ENTITY_TYPE = 'PROCESS_BAL_TRANS'

          AND ENTITY_NAME = 'JAN'

        

      2014-06-24 01:43:35,798 DEBUG [AIF]: Comm.updateProcessDetail - END

      2014-06-24 01:43:35,800 DEBUG [AIF]:

            SELECT COUNT(*) ROW_COUNT

            FROM TDATASEG_T

            WHERE LOADID = 197

          

            AND (

            

            PARTITIONKEY = 14

            AND CATKEY = 5

            AND PERIODKEY = '2010-01-31'

            AND RULE_ID = 20

              AND VALID_FLAG = 'Y'

            )

      2014-06-24 01:43:35,800 INFO  [AIF]:

      Processing Mappings for Column 'ACCOUNT'

      2014-06-24 01:43:35,800 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET ACCOUNTX = 'Opening Stock'

                    ,ACCOUNTR = 36

                    ,ACCOUNTF = 3

                  

                    WHERE LOADID = 197

                    AND PARTITIONKEY = 14

                    AND CATKEY = 5

                    AND (ACCOUNTX IS NULL OR ACCOUNTX = '')

                  

                  AND (ACCOUNT LIKE 'Opening Stock')

                    AND PERIODKEY = '2010-01-31'

      2014-06-24 01:43:35,801 INFO  [AIF]: Data Rows Updated by Rule Mapping 'pocr1' (LIKE): 1

      2014-06-24 01:43:35,802 INFO  [AIF]:

      Processing Mappings for Column 'ENTITY'

      2014-06-24 01:43:35,802 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET ENTITYX = 'LE1'

                    ,ENTITYR = 37

                    ,ENTITYF = 3

                  

                    WHERE LOADID = 197

                    AND PARTITIONKEY = 14

                    AND CATKEY = 5

                    AND (ENTITYX IS NULL OR ENTITYX = '')

                  

                  AND (ENTITY LIKE 'LE1')

                    AND PERIODKEY = '2010-01-31'

      2014-06-24 01:43:35,802 INFO  [AIF]: Data Rows Updated by Rule Mapping 'POCR2' (LIKE): 1

      2014-06-24 01:43:35,803 INFO  [AIF]:

      Processing Mappings for Column 'ICP'

      2014-06-24 01:43:35,803 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET ICPX = '[ICP None]'

                    ,ICPR = 41

                    ,ICPF = 3

                  

                    WHERE LOADID = 197

                    AND PARTITIONKEY = 14

                    AND CATKEY = 5

                    AND (ICPX IS NULL OR ICPX = '')

                  

                  AND (ICP IN ('[ICP None]'))

                    AND PERIODKEY = '2010-01-31'

      2014-06-24 01:43:35,804 INFO  [AIF]: Data Rows Updated by Rule Mapping 'POCRICP' (IN): 1

      2014-06-24 01:43:35,804 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET ICPX = '[ICP None]'

                    ,ICPR = 40

                    ,ICPF = 3

                  

                    WHERE LOADID = 197

                    AND PARTITIONKEY = 14

                    AND CATKEY = 5

                    AND (ICPX IS NULL OR ICPX = '')

                  

                  AND (ICP LIKE '[ICP None]')

                    AND PERIODKEY = '2010-01-31'

      2014-06-24 01:43:35,805 INFO  [AIF]: Data Rows Updated by Location Mapping 'POCR5' (LIKE): 0

      2014-06-24 01:43:35,805 INFO  [AIF]:

      Processing Mappings for Column 'UD1'

      2014-06-24 01:43:35,805 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET UD1X = '[None]'

                    ,UD1R = 42

                    ,UD1F = 3

                  

                    WHERE LOADID = 197

                    AND PARTITIONKEY = 14

                    AND CATKEY = 5

                    AND (UD1X IS NULL OR UD1X = '')

                  

                  AND (UD1 IN ('[None]'))

                    AND PERIODKEY = '2010-01-31'

      2014-06-24 01:43:35,806 INFO  [AIF]: Data Rows Updated by Rule Mapping 'POCRCS1' (IN): 1

      2014-06-24 01:43:35,806 INFO  [AIF]:

      Processing Mappings for Column 'UD2'

      2014-06-24 01:43:35,806 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET UD2X = '[None]'

                    ,UD2R = 43

                    ,UD2F = 3

                  

                    WHERE LOADID = 197

                    AND PARTITIONKEY = 14

                    AND CATKEY = 5

                    AND (UD2X IS NULL OR UD2X = '')

                  

                  AND (UD2 IN ('[None]'))

                    AND PERIODKEY = '2010-01-31'

      2014-06-24 01:43:35,807 INFO  [AIF]: Data Rows Updated by Rule Mapping 'poccs2' (IN): 1

      2014-06-24 01:43:35,807 DEBUG [AIF]: Comm.updateProcessDetail - START

      2014-06-24 01:43:35,807 DEBUG [AIF]:

          UPDATE AIF_PROCESS_DETAILS

          SET STATUS = 'SUCCESS'

          ,RECORDS_PROCESSED = CASE

            WHEN RECORDS_PROCESSED IS NULL THEN 0

            ELSE RECORDS_PROCESSED

          END + 1

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

          AND ENTITY_TYPE = 'PROCESS_BAL_TRANS'

          AND ENTITY_NAME = 'JAN'

        

      2014-06-24 01:43:35,808 DEBUG [AIF]: Comm.updateProcessDetail - END

      2014-06-24 01:43:35,808 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END

      2014-06-24 01:43:35,809 DEBUG [AIF]:

            UPDATE TDATASEG_T

            SET ATTR14 = DATAKEY

            WHERE LOADID = 197

            AND PARTITIONKEY = 14

            AND CATKEY = 5

            AND PERIODKEY = '2010-01-31'

          

      2014-06-24 01:43:35,815 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START

      2014-06-24 01:43:35,815 INFO  [AIF]:

      Stage Data for Period 'JAN'

      2014-06-24 01:43:35,815 DEBUG [AIF]:

              DELETE FROM TDATAMAPSEG

              WHERE PARTITIONKEY = 14

              AND CATKEY = 5

              AND PERIODKEY = '2010-01-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-24 01:43:35,816 INFO  [AIF]: Number of Rows deleted from TDATAMAPSEG: 6

      2014-06-24 01:43:35,816 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

              ,'2010-01-31'

              ,DIMNAME

              ,SRCKEY

              ,SRCDESC

              ,TARGKEY

              ,WHERECLAUSETYPE

              ,WHERECLAUSEVALUE

              ,CHANGESIGN

              ,SEQUENCE

              ,VBSCRIPT

              ,TDATAMAPTYPE

              ,SYSTEM_GENERATED_FLAG

              FROM TDATAMAP_T

              WHERE LOADID = 197

            

      2014-06-24 01:43:35,817 INFO  [AIF]: Number of Rows inserted into TDATAMAPSEG: 6

      2014-06-24 01:43:35,817 DEBUG [AIF]:

              DELETE FROM TDATAMAP_T

              WHERE LOADID = 197

            

      2014-06-24 01:43:35,818 INFO  [AIF]: Number of Rows deleted from TDATAMAP_T: 6

      2014-06-24 01:43:35,818 DEBUG [AIF]:

                  DELETE FROM TDATASEG

                  WHERE LOADID < 197

                  AND PARTITIONKEY = 14

                  AND CATKEY = 5

                  AND RULE_ID = 20

                  AND PERIODKEY = '2010-01-31'

                

      2014-06-24 01:43:35,818 INFO  [AIF]: Number of Rows deleted from TDATASEG: 1

      2014-06-24 01:43:35,818 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 = 197

                AND PARTITIONKEY = 14

                AND CATKEY = 5

                AND PERIODKEY = '2010-01-31'

              

      2014-06-24 01:43:35,820 INFO  [AIF]: Number of Rows inserted into TDATASEG: 1

      2014-06-24 01:43:35,820 DEBUG [AIF]:

              DELETE FROM TDATASEG_T

              WHERE LOADID = 197

              AND PARTITIONKEY = 14

              AND CATKEY = 5

              AND PERIODKEY = '2010-01-31'

            

      2014-06-24 01:43:35,821 INFO  [AIF]: Number of Rows deleted from TDATASEG_T: 1

      2014-06-24 01:43:35,821 DEBUG [AIF]: CommData.updateWorkflow - START

      2014-06-24 01:43:35,821 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME = CURRENT_TIMESTAMP

            

              ,PROCESSSTATUS = 1

                ,PROCESSIMP = 1

                ,BLNWCDIRTY = 0

                ,BLNLOGICDIRTY = 0

                ,BLNVALDIRTY = 0

                ,PROCESSIMPNOTE = 'Import Successful'

              WHERE PARTITIONKEY = 14

              AND CATKEY = 5

              AND PERIODKEY = '2010-01-31'

              AND RULE_ID = 20

            

      2014-06-24 01:43:35,821 DEBUG [AIF]: CommData.updateWorkflow - END

      2014-06-24 01:43:35,821 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END

      2014-06-24 01:43:35,821 DEBUG [AIF]: Comm.executeScript - START

      2014-06-24 01:43:35,822 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/AftProcMap.py

      2014-06-24 01:43:35,822 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-24 01:43:35,822 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\AftProcMap.vbs

      2014-06-24 01:43:35,822 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-24 01:43:35,822 DEBUG [AIF]: Comm.executeScript - END

      2014-06-24 01:43:35,822 DEBUG [AIF]: CommData.mapData - END

      2014-06-24 01:43:35,831 INFO  [AIF]: -------END IMPORT STEP-------

      2014-06-24 01:43:35,840 INFO  [AIF]: -------START VALIDATE STEP-------

      2014-06-24 01:43:35,859 DEBUG [AIF]: CommData.validateData - START

      2014-06-24 01:43:35,859 DEBUG [AIF]: Comm.executeScript - START

      2014-06-24 01:43:35,859 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/BefValidate.py

      2014-06-24 01:43:35,859 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-24 01:43:35,860 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\BefValidate.vbs

      2014-06-24 01:43:35,860 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-24 01:43:35,860 DEBUG [AIF]: Comm.executeScript - END

      2014-06-24 01:43:35,865 DEBUG [AIF]: CommMap.validateData - START

      2014-06-24 01:43:35,865 INFO  [AIF]:

      Validate Data Mappings for Period 'JAN'

      2014-06-24 01:43:35,865 DEBUG [AIF]:

            SELECT COUNT(*) ROW_COUNT

            FROM TDATASEG

            WHERE LOADID = 197

          

            AND (

            

            PARTITIONKEY = 14

            AND CATKEY = 5

            AND PERIODKEY = '2010-01-31'

            AND RULE_ID = 20

              AND VALID_FLAG = 'Y'

            )

      2014-06-24 01:43:35,866 DEBUG [AIF]: CommData.updateWorkflow - START

      2014-06-24 01:43:35,866 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 = 14

          AND tlp.CATKEY = 5

          AND tlp.PERIODKEY = '2010-01-31'

          AND tlp.RULE_ID = 20

          AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

        

      2014-06-24 01:43:35,867 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 = 14

              AND CATKEY = 5

              AND PERIODKEY = '2010-01-31'

              AND RULE_ID = 20

            

      2014-06-24 01:43:35,868 DEBUG [AIF]: CommData.updateWorkflow - END

      2014-06-24 01:43:35,868 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 = '')

                      

                      )

                      AND LOADID = 197

                      AND PARTITIONKEY = 14

                      AND CATKEY = 5

                      AND PERIODKEY = '2010-01-31'

                      AND VALID_FLAG = 'Y'

                    

                        AND CALCACCTTYPE > 0

                      

      2014-06-24 01:43:35,869 DEBUG [AIF]: CommData.updateWorkflow - START

      2014-06-24 01:43:35,869 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME = CURRENT_TIMESTAMP

            

              ,PROCESSSTATUS = 11

                ,PROCESSVAL = 1

                ,BLNVALDIRTY = 0

                ,PROCESSVALNOTE = 'Validate Successful'

              WHERE PARTITIONKEY = 14

              AND CATKEY = 5

              AND PERIODKEY = '2010-01-31'

              AND RULE_ID = 20

            

      2014-06-24 01:43:35,870 DEBUG [AIF]: CommData.updateWorkflow - END

      2014-06-24 01:43:35,870 INFO  [AIF]: Total Data Rows available for Export to Target: 1

      2014-06-24 01:43:35,870 DEBUG [AIF]: CommMap.validateData - END

      2014-06-24 01:43:35,870 INFO  [AIF]:

      Validate Data Members for Period 'JAN'

      2014-06-24 01:43:35,870 DEBUG [AIF]:

            SELECT COUNT(*) ROW_COUNT

            FROM TDATASEG

            WHERE LOADID = 197

          

            AND (

            

            PARTITIONKEY = 14

            AND CATKEY = 5

            AND PERIODKEY = '2010-01-31'

            AND RULE_ID = 20

              AND VALID_FLAG = 'Y'

            )

      2014-06-24 01:43:35,871 INFO  [AIF]: Total Data Rows available for Export to Target: 1

      2014-06-24 01:43:35,871 DEBUG [AIF]:

          SELECT property_value

          FROM   aif_target_appl_properties

          WHERE  application_id = 8 and property_type = 'CHECK_INTERSECTION'

        

      2014-06-24 01:43:35,872 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-24 01:43:35,872 INFO  [AIF]: Executing the following script: C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\bin\HFM_VALIDATE.vbs

      2014-06-24 01:43:35,873 DEBUG [AIF]: The command to be executed is:

      cscript C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\bin\HFM_VALIDATE.vbs "197" "****" "C%3A%5COracle%5CMiddleware%5Cuser_projects%5Cepmsystem1" "%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35" "SQLOLEDB"

      Microsoft (R) Windows Script Host Version 5.8

      Copyright (C) Microsoft Corporation. All rights reserved.

       

      2014-06-24 01:43:35,908 ERROR [AIF]: The script has failed to execute:

      2014-06-24 01:43:35,908 INFO  [AIF]: C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\bin\HFM_VALIDATE.vbs(9, 1) Microsoft VBScript runtime error: ActiveX component can't create object: 'erpiHFMAdapter.clsFMAdapter'

       

      2014-06-24 01:43:35,910 FATAL [AIF]: Error in CommData.validateData

      Traceback (most recent call last):

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

        File "<string>", line 558, in executeVBScript

      RuntimeError: 0

       

      2014-06-24 01:43:35,910 DEBUG [AIF]: CommData.updateWorkflow - START

      2014-06-24 01:43:35,910 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME = CURRENT_TIMESTAMP

            

              ,PROCESSSTATUS = 12

                ,PROCESSVAL = 0

                ,BLNVALDIRTY = 0

                ,PROCESSVALNOTE = 'Error = 0 records'

              WHERE PARTITIONKEY = 14

              AND CATKEY = 5

              AND PERIODKEY = '2010-01-31'

              AND RULE_ID = 20

            

      2014-06-24 01:43:35,911 DEBUG [AIF]: CommData.updateWorkflow - END

      2014-06-24 01:43:35,911 DEBUG [AIF]: Comm.executeScript - START

      2014-06-24 01:43:35,912 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/AftValidate.py

      2014-06-24 01:43:35,912 DEBUG [AIF]: Comm.executeVBScript - START

      2014-06-24 01:43:35,912 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\AftValidate.vbs

      2014-06-24 01:43:35,912 DEBUG [AIF]: Comm.executeVBScript - END

      2014-06-24 01:43:35,912 DEBUG [AIF]: Comm.executeScript - END

      2014-06-24 01:43:35,930 DEBUG [AIF]: Comm.finalizeProcess - START

      2014-06-24 01:43:35,931 DEBUG [AIF]: CommData.updateRuleStatus - START

      2014-06-24 01:43:35,931 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 = 197

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

              )

              WHEN 0 THEN 'SUCCESS'

              ELSE (

                SELECT MIN(pd.STATUS)

                FROM AIF_PROCESS_DETAILS pd

                WHERE pd.PROCESS_ID = 197

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

              )

              END

            ELSE 'FAILED'

          END

          WHERE RULE_ID = 20

        

      2014-06-24 01:43:35,932 DEBUG [AIF]: CommData.updateRuleStatus - END

      2014-06-24 01:43:35,933 FATAL [AIF]: Error in COMM Validate Data

      2014-06-24 01:43:35,934 DEBUG [AIF]: Comm.updateProcess - START

      2014-06-24 01:43:35,936 DEBUG [AIF]: Comm.updateProcess - END

       

       

      Thanks in advance..