7 Replies Latest reply on Jun 6, 2017 2:45 PM by amith.madisetty

    FDMEE retrieving and storing global variable always returns no data

    3355552

      Hi all,

       

      I keep on getting null value during my retrieval of temporary variable. My FDMEE is 11.1.2.4.200

       

      Here is my Storing temporary variable script(which I apply in the Amount Import Format)-- I followed the step by step from https://docs.oracle.com/cd/E57185_01/FDMAG/ch08s04s06s01.html :

      ICPLeft = ""

      def ICPGetLeft (strfield, strrecord):

          if strrecord[0:8] == "Company:":

              global ICPLeft

              ICPLeft = strrecord[11:15]

          return strfield

       

      and here is my Retrieving temporary variable script(which I apply in the ICP import format) --I followed the step by step from https://docs.oracle.com/cd/E57185_01/FDMAG/ch08s04s06s02.html :

      def ICPPutLeft (strfield, strrecord):

          return ICPLeft

       

      This is my import format screenshot:

      This is the sample of my source files in 2 liners( I would like to take the text ABCD to be stored in my variable):

      Company:;;;ABCD;;;;;;;;;Company:;;;EFGH;;;;;;;;;;;

      110170;Trade receivables (group);;EUR; 8,130,802 ;0.891910; 9,116,169 ;1.000000; 9,116,169 ;; -   ;;210170;Trade accounts payable (group);;EUR; 8,130,816 ;0.001524; 5,333,459,579 ;585.053950; 9,116,184 ;;;;-15 ;;15

      111170;Other current receivables (group);;USD;;1.000000; -   ;1.000000; -   ;; -   ;;211170;Other current liabilities (group);;USD;;0.001709; -   ;585.053950; -   ;;;; -   ;;0

       

       

      My mapping in ICP dimension is * to *

      But during import, it does not seem to import anything source data to my ICP row. All the other dimension mapping are imported correctly, except ICP, it does not seem to have anything in the source. Wondering why?

      Anything wrong with my script???

       

      My process logs:

       

       

      2017-06-06 09:30:40,409 INFO  [AIF]: FDMEE Process: 339, Log Level: 5, Log File: \\SVCHGVA1-429\FDMEEData\outbox\logs\CONSO_339.log

      2017-06-06 09:30:40,409 INFO  [AIF]: Location     : EFGH (Partitionkey:8)

      2017-06-06 09:30:40,409 INFO  [AIF]: Period Name  : M6 - 2017 (Period Key:30.06.17 00:00)

      2017-06-06 09:30:40,409 INFO  [AIF]: Category Name: Actual (Category key:1)

      2017-06-06 09:30:40,409 INFO  [AIF]: Rule Name    : DLR_EFGH (Rule ID:6)

      2017-06-06 09:30:42,081 INFO  [AIF]: FDM Version: 11.1.2.4.200

      2017-06-06 09:30:42,081 INFO  [AIF]: Log File Encoding: UTF-8

      2017-06-06 09:30:44,159 INFO  [AIF]: -------START IMPORT STEP-------

      2017-06-06 09:30:44,253 DEBUG [AIF]: CommData.preImportData - START

      2017-06-06 09:30:44,268 DEBUG [AIF]: CommData.getRuleInfo - START

      2017-06-06 09:30:44,284 DEBUG [AIF]:

            SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, dim.TARGET_DIMENSION_CLASS_NAME, tiie.IMPCONCATCHAR

                  ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1

            FROM TPOVPARTITION tpp

            INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

              ON adim.APPLICATION_ID = 2

            INNER JOIN AIF_DIMENSIONS dim

              ON dim.DIMENSION_ID = adim.DIMENSION_ID

            LEFT OUTER JOIN TBHVIMPITEMERPI tiie

              ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME AND tiie.IMPMAPTYPE = 'ERP'

            WHERE tpp.PARTITIONKEY = 8

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

            ORDER BY adim.BALANCE_COLUMN_NAME

       

       

      2017-06-06 09:30:44,284 DEBUG [AIF]: {'APPLICATION_ID': 2L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'DLR_EFGH', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem3', 'CATKEY': 1L, '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'AOGCONSO', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'IF_EFGHICPartner', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'forensis', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 8L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 6L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 11L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 9L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'LOOKUP', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 27L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 7L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 13L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 10L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 8L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 6L, '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', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 2L, 'IMPTARGETSOURCESYSTEMID': 0L}

      2017-06-06 09:30:44,284 DEBUG [AIF]: CommData.getRuleInfo - END

      2017-06-06 09:30:44,300 DEBUG [AIF]: CommData.insertFilePeriods - START

      2017-06-06 09:30:44,300 DEBUG [AIF]: doAppPeriodMappingsExist - AAACONSO: N

      2017-06-06 09:30:44,300 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, pp.PERIODTARGET, brl.FILE_NAME_STATIC, brl.FILE_NAME_SUFFIX_TYPE, brl.FILE_NAME_DATE_FORMAT

                      ,coalesce(brp.parameter_id,0) GL_EFFECTIVE_PERIOD_NUM

                FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                INNER JOIN TPOVCATEGORY pc

                  ON pc.CATKEY = brl.CATKEY

                INNER JOIN TPOVPERIOD_FLAT_V pp

                  ON pp.PERIODFREQ = pc.CATFREQ

                INNER JOIN AIF_BAL_RULE_LOAD_PARAMS brp

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

                WHERE brl.LOADID = 339

                  AND br.rule_id = brl.rule_id

                  AND br.MULTI_PERIOD_FILE_FLAG in ('T','H')

                  AND brp.parameter_name like 'AMOUNT%'

                UNION

                SELECT pp.PERIODKEY, pp.PERIODDESC, pp.YEARTARGET, pp.PERIODTARGET, brl.FILE_NAME_STATIC, brl.FILE_NAME_SUFFIX_TYPE, brl.FILE_NAME_DATE_FORMAT

                      ,0 GL_EFFECTIVE_PERIOD_NUM

                FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                INNER JOIN TPOVCATEGORY pc

                  ON pc.CATKEY = brl.CATKEY

                INNER JOIN TPOVPERIOD_FLAT_V pp

                  ON pp.PERIODFREQ = pc.CATFREQ AND pp.PERIODKEY >= brl.START_PERIODKEY AND pp.PERIODKEY <= brl.END_PERIODKEY  

                WHERE brl.LOADID = 339

                  AND br.rule_id = brl.rule_id

                  AND br.MULTI_PERIOD_FILE_FLAG in('Y', 'X','E')

                ) qrslt

                UNION

                SELECT pp.PERIODKEY, pp.PERIODDESC, pp.YEARTARGET, pp.PERIODTARGET, brl.FILE_NAME_STATIC, brl.FILE_NAME_SUFFIX_TYPE, brl.FILE_NAME_DATE_FORMAT

                      ,0 GL_EFFECTIVE_PERIOD_NUM

                FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                INNER JOIN TPOVCATEGORY pc

                  ON pc.CATKEY = brl.CATKEY

                INNER JOIN TPOVPERIOD_FLAT_V pp

                  ON pp.PERIODFREQ = pc.CATFREQ AND pp.PERIODKEY >= brl.START_PERIODKEY AND pp.PERIODKEY <= brl.END_PERIODKEY

                WHERE brl.LOADID = 339

                  AND (br.MULTI_PERIOD_FILE_FLAG is null or br.MULTI_PERIOD_FILE_FLAG = 'N' )

                  AND br.rule_id = brl.rule_id

                ORDER BY PERIODKEY

         

      2017-06-06 09:30:44,300 INFO  [AIF]: File Name: Master_ABCD_Partner_EFGH1.csv

      2017-06-06 09:30:44,300 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 (339,'2017-06-30','N',0,'0' ,'0',0,1,'2017','M6', 'PROCESS_BAL_IMP_FILE','Master_ABCD_Partner_EFGH1.csv','PROCESS_BAL_TRANS','M6 - 2017','N')

       

      2017-06-06 09:30:44,300 DEBUG [AIF]: CommData.insertFilePeriods - END

      2017-06-06 09:30:44,315 DEBUG [AIF]: CommData.getPovList - START

      2017-06-06 09:30:44,315 DEBUG [AIF]:

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

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

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

              FROM AIF_BAL_RULE_LOADS brl

              INNER JOIN AIF_BALANCE_RULES br

                ON br.RULE_ID = brl.RULE_ID

              INNER JOIN TPOVPARTITION part

                ON part.PARTITIONKEY = brl.PARTITIONKEY

              INNER JOIN TPOVCATEGORY cat

                ON cat.CATKEY = brl.CATKEY

              INNER JOIN AIF_PROCESS_PERIODS pprd

                ON pprd.PROCESS_ID = brl.LOADID

              LEFT OUTER JOIN TPOVPERIOD pp

                ON pp.PERIODKEY = pprd.PERIODKEY

              LEFT OUTER JOIN TLOGPROCESS tlp

                ON tlp.PARTITIONKEY = brl.PARTITIONKEY AND tlp.CATKEY = brl.CATKEY AND tlp.PERIODKEY = pprd.PERIODKEY AND tlp.RULE_ID = brl.RULE_ID

              WHERE brl.LOADID = 339

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

       

      2017-06-06 09:30:44,315 DEBUG [AIF]: CommData.getPovList - END

      2017-06-06 09:30:44,315 DEBUG [AIF]: CommData.insertImportProcessDetails - START

      2017-06-06 09:30:44,315 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, 'forensis' LAST_UPDATED_BY, CURRENT_TIMESTAMP LAST_UPDATE_DATE

                FROM (

                  SELECT DISTINCT PROCESS_ID, IMP_ENTITY_TYPE ENTITY_TYPE, IMP_ENTITY_ID ENTITY_ID, IMP_ENTITY_NAME ENTITY_NAME

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

                  FROM AIF_PROCESS_PERIODS

                  WHERE PROCESS_ID = 339

                ) q

                ORDER BY ENTITY_NAME_ORDER

         

      2017-06-06 09:30:44,378 DEBUG [AIF]: CommData.insertImportProcessDetails - END

      2017-06-06 09:30:44,394 DEBUG [AIF]: Comm.doScriptInit - START

      2017-06-06 09:30:44,456 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem3\FinancialDataQuality, INBOXDIR=\\SVCHGVA1-429\FDMEEData\inbox, LOCNAME=EFGH, SOURCENAME=File, APPID=2, SOURCEID=1, APPROOTDIR=\\SVCHGVA1-429\FDMEEData, IMPORTFORMAT=IF_EFGHICPartner, SCRIPTSDIR=\\SVCHGVA1-429\FDMEEData\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=6, CATNAME=Actual, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem3, LOADID=339, PERIODNAME=M6 - 2017, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2017-06-30, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=AAACONSO, FILENAME=Master_ABCD_Partner_EFGH1.csv, LOCKEY=8, RULENAME=DLR_EFGH, OUTBOXDIR=\\SVCHGVA1-429\FDMEEData\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=1, USERNAME=forensis, FILEDIR=, IMPORTFLAG=Y, USERLOCALE=null}

      2017-06-06 09:30:44,456 DEBUG [AIF]: The executeEventScript is set to: YES

      2017-06-06 09:30:44,456 DEBUG [AIF]: The AppRootFolder is set to: \\SVCHGVA1-429\FDMEEData

      2017-06-06 09:30:44,456 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

      2017-06-06 09:30:44,456 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB

      2017-06-06 09:30:44,456 DEBUG [AIF]: Comm.doScriptInit - END

      2017-06-06 09:30:44,456 DEBUG [AIF]: Comm.executeScript - START

      2017-06-06 09:30:44,472 INFO  [AIF]: Executing the following script: \\SVCHGVA1-429\FDMEEData/data/scripts/event/BefImport.py

      2017-06-06 09:30:44,472 DEBUG [AIF]: Comm.executeVBScript - START

      2017-06-06 09:30:44,472 DEBUG [AIF]: The WindowsTempFolder is set to: c:\users\hfm~1.adm\appdata\local\temp

      2017-06-06 09:30:44,472 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData\data\scripts\event\BefImport.vbs

      2017-06-06 09:30:44,472 DEBUG [AIF]: Comm.executeVBScript - END

      2017-06-06 09:30:44,472 DEBUG [AIF]: Comm.executeScript - END

      2017-06-06 09:30:44,472 DEBUG [AIF]: CommData.preImportData - END

      2017-06-06 09:30:48,612 DEBUG [AIF]: FileData.importData - START

      2017-06-06 09:30:48,612 DEBUG [AIF]: Importing data for load id: 339

      2017-06-06 09:30:48,628 DEBUG [AIF]: CommData.getRuleInfo - START

      2017-06-06 09:30:48,628 DEBUG [AIF]:

            SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, dim.TARGET_DIMENSION_CLASS_NAME, tiie.IMPCONCATCHAR

                  ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1

            FROM TPOVPARTITION tpp

            INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

              ON adim.APPLICATION_ID = 2

            INNER JOIN AIF_DIMENSIONS dim

              ON dim.DIMENSION_ID = adim.DIMENSION_ID

            LEFT OUTER JOIN TBHVIMPITEMERPI tiie

              ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME AND tiie.IMPMAPTYPE = 'ERP'

            WHERE tpp.PARTITIONKEY = 8

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

            ORDER BY adim.BALANCE_COLUMN_NAME

       

       

      2017-06-06 09:30:48,644 DEBUG [AIF]: {'APPLICATION_ID': 2L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'DLR_EFGH', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem3', 'CATKEY': 1L, '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'AAACONSO', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'IF_EFGHICPartner', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'forensis', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 8L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 6L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 11L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 9L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'LOOKUP', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 27L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 7L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 13L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 10L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 8L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 6L, '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', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 2L, 'IMPTARGETSOURCESYSTEMID': 0L}

      2017-06-06 09:30:48,644 DEBUG [AIF]: CommData.getRuleInfo - END

      2017-06-06 09:30:48,644 DEBUG [AIF]: doAppPeriodMappingsExist - AAACONSO: N

      2017-06-06 09:30:48,644 DEBUG [AIF]:  SELECT a.partitionkey,

                                        a.catkey,

                                        a.start_periodkey,

                                        b.perioddesc,

                                        coalesce(a.journal_flag,'N') JOURNAL_FLAG,

                                        c.last_updated_by,

                                        coalesce(a.FILE_NAME_STATIC,'') FILE_NAME_STATIC,

                                        a.FILE_PATH,

                                        a.RULE_ID,

                                        a.application_id,

                                        coalesce(br.MULTI_PERIOD_FILE_FLAG, 'N') MULTI_PERIOD_FILE_FLAG

                                      FROM aif_bal_rule_loads a,

                                      aif_balance_rules br,

                                        tpovperiod b,

                                        aif_processes c

                                      WHERE a.loadid       = 339

                                      AND a.start_periodkey=b.periodkey

                                      AND a.loadid         =c.process_id

                                      AND br.rule_id = a.rule_id

                               

      2017-06-06 09:30:48,644 DEBUG [AIF]: FileData.py: Importing Text data for load id: 339

      2017-06-06 09:30:48,659 INFO  [AIF]: EPMFDM-140274:Message - Log File Name :\\SVCHGVA1-429\FDMEEData\outbox\logs\AAACONSO_339.log

      2017-06-06 09:30:48,659 INFO  [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH::339;8:1:6:[NONE]:\\SVCHGVA1-429\FDMEEData/

      2017-06-06 09:30:48,675 INFO  [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8

      2017-06-06 09:30:48,675 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - Start

      2017-06-06 09:30:48,690 INFO  [AIF]: EPMFDM-140274:Message - Log File Name :\\SVCHGVA1-429\FDMEEData\outbox\logs\AAACONSO_339.log

      2017-06-06 09:30:48,690 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=Script=ICPGetLeft.py:StartPos=17:SourceClName=null

      2017-06-06 09:30:48,690 INFO  [AIF]: EPMFDM-140274:Message - Instantiating JythonInterpreter

      2017-06-06 09:30:48,800 INFO  [AIF]: EPMFDM-140275:Message - Log File Name :\\SVCHGVA1-429\FDMEEData\outbox\logs\AAACONSO_339.log

      2017-06-06 09:30:48,800 DEBUG [AIF]: EPMFDM-140274:Message - Passing script file for execution to jython interpretor: \\SVCHGVA1-429\FDMEEData/data/scripts/import/ICPGetLeft.py

      2017-06-06 09:30:48,800 INFO  [AIF]: EPMFDM-140275:Message - Execute File: \\SVCHGVA1-429\FDMEEData/data/scripts/import/ICPGetLeft.py

      2017-06-06 09:30:48,800 DEBUG [AIF]: EPMFDM-140275:Message - LOG_LEVEL: 5

      2017-06-06 09:30:48,800 DEBUG [AIF]: EPMFDM-140275:Message - Script File encoding: UTF-8

      2017-06-06 09:30:48,800 DEBUG [AIF]: EPMFDM-140275:Message - ICPLeft = ""

      def ICPGetLeft (strfield, strrecord):

          if strrecord[0:8] == "Company:":

              global ICPLeft

              ICPLeft = strrecord[11:15]

          return strfield

       

       

       

       

      2017-06-06 09:30:48,815 DEBUG [AIF]: EPMFDM-140274:Message - compiling script:ICPGetLeft(strField,strRecord)

      2017-06-06 09:30:48,815 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD5:ImpFieldText=null:StartPos=19:SourceClName=null

      2017-06-06 09:30:48,815 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=EFGH:StartPos=50:SourceClName=null

      2017-06-06 09:30:48,815 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=13:SourceClName=null

      2017-06-06 09:30:48,815 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ICP:ImpFieldText=Script=ICPPutLeft.py;:StartPos=51:SourceClName=null

      2017-06-06 09:30:48,815 DEBUG [AIF]: EPMFDM-140274:Message - Passing script file for execution to jython interpretor: \\SVCHGVA1-429\FDMEEData/data/scripts/import/ICPPutLeft.py

      2017-06-06 09:30:48,815 INFO  [AIF]: EPMFDM-140275:Message - Execute File: \\SVCHGVA1-429\FDMEEData/data/scripts/import/ICPPutLeft.py

      2017-06-06 09:30:48,815 DEBUG [AIF]: EPMFDM-140275:Message - LOG_LEVEL: 5

      2017-06-06 09:30:48,815 DEBUG [AIF]: EPMFDM-140275:Message - Script File encoding: UTF-8

      2017-06-06 09:30:48,815 DEBUG [AIF]: EPMFDM-140275:Message - def ICPPutLeft (strfield, strrecord):

          return ICPLeft

       

       

       

       

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - compiling script:ICPPutLeft(strField,strRecord)

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=-:StartPos=52:SourceClName=null

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=16:SourceClName=null

      2017-06-06 09:30:48,831 INFO  [AIF]: EPMFDM-140274:Message - File Name Master_ABCD_Partner_EFGH1.csv

      periodKey2017-06-30

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:[Company:;;;ABCD;;;;;;;;;Company:;;;EFGH;;;;;;;;;;;]

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying UD5 mapping on the row:[Company:;;;ABCD;;;;;;;;;Company:;;;EFGH;;;;;;;;;;;]

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying ENTITY mapping on the row:[Company:;;;ABCD;;;;;;;;;Company:;;;EFGH;;;;;;;;;;;]

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying ICP mapping on the row:[Company:;;;ABCD;;;;;;;;;Company:;;;EFGH;;;;;;;;;;;]

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Error: nullcom.hyperion.aif.file.common.util.DataLoadEngine$ImportItemFileEntity.evaluateExpressions(DataLoadEngine.java:1072)

      com.hyperion.aif.file.common.util.DataLoadEngine.processFileRow(DataLoadEngine.java:842)

      com.hyperion.aif.file.common.util.DataLoadEngine.loadRow(DataLoadEngine.java:431)

      com.hyperion.aif.file.data.ImportTextData.performLoad(ImportTextData.java:456)

      sun.reflect.GeneratedMethodAccessor28862.invoke(Unknown Source)

      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      java.lang.reflect.Method.invoke(Method.java:597)

      org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:175)

      org.python.core.PyObject.__call__(PyObject.java:355)

      org.python.core.PyMethod.__call__(PyMethod.java:215)

      org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

      org.python.core.PyMethod.__call__(PyMethod.java:206)

      org.python.core.PyObject.__call__(PyObject.java:381)

      org.python.core.PyObject.__call__(PyObject.java:385)

      org.python.pycode._pyx2142.importData$2(<string>:119)

      org.python.pycode._pyx2142.call_function(<string>)

      org.python.core.PyTableCode.call(PyTableCode.java:165)

      org.python.core.PyBaseCode.call(PyBaseCode.java:297)

      org.python.core.PyBaseCode.call(PyBaseCode.java:191)

      org.python.core.PyFunction.__call__(PyFunction.java:385)

      org.python.core.PyMethod.__call__(PyMethod.java:215)

      org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

      org.python.core.PyMethod.__call__(PyMethod.java:206)

      org.python.core.PyObject.__call__(PyObject.java:432)

      org.python.core.PyObject.__call__(PyObject.java:436)

      org.python.pycode._pyx2145.f$0(<string>:5)

      org.python.pycode._pyx2145.call_function(<string>)

      org.python.core.PyTableCode.call(PyTableCode.java:165)

      org.python.core.PyCode.call(PyCode.java:18)

      org.python.core.Py.runCode(Py.java:1204)

      org.python.core.Py.exec(Py.java:1248)

      org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)

      org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)

      com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

      com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

      oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

      oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

      oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

      com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

      com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

      com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

      com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

      oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

      oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

      oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

      org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

      oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

      oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

      oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

      oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:79)

      oracle.odi.runtime.agent.invocation.support.InternalLocalRuntimeAgentInvoker.invoke(InternalLocalRuntimeAgentInvoker.java:49)

      oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:173)

      oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:140)

      com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:271)

      com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)

      oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)

      oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)

      oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

      com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

      com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

      com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

      com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

      oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

      oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

      oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

      org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

      oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

      oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

      oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

      oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

      oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:564)

      oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:518)

      javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

      javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

      weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

      weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

      weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

      weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

      weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

      oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

      oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

      oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

      oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

      oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

      oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

      weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

      oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

      weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

      weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)

      weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

      weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

      weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

      weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)

      weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

      weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)

      weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

      weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

       

       

       

       

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying UD3 mapping on the row:[Company:;;;ABCD;;;;;;;;;Company:;;;EFGH;;;;;;;;;;;]

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying ENTITY mapping on the row:[110170;Trade receivables (group);;EUR; 8,130,802 ;0.891910; 9,116,169 ;1.000000; 9,116,169 ;; -   ;;210170;Trade accounts payable (group);;EUR; 8,130,816 ;0.001524; 5,333,459,579 ;585.053950; 9,116,184 ;;;;-15 ;;15]

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying ICP mapping on the row:[110170;Trade receivables (group);;EUR; 8,130,802 ;0.891910; 9,116,169 ;1.000000; 9,116,169 ;; -   ;;210170;Trade accounts payable (group);;EUR; 8,130,816 ;0.001524; 5,333,459,579 ;585.053950; 9,116,184 ;;;;-15 ;;15]

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Error: nullcom.hyperion.aif.file.common.util.DataLoadEngine$ImportItemFileEntity.evaluateExpressions(DataLoadEngine.java:1072)

      com.hyperion.aif.file.common.util.DataLoadEngine.processFileRow(DataLoadEngine.java:842)

      com.hyperion.aif.file.common.util.DataLoadEngine.loadRow(DataLoadEngine.java:431)

      com.hyperion.aif.file.data.ImportTextData.performLoad(ImportTextData.java:456)

      sun.reflect.GeneratedMethodAccessor28862.invoke(Unknown Source)

      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      java.lang.reflect.Method.invoke(Method.java:597)

      org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:175)

      org.python.core.PyObject.__call__(PyObject.java:355)

      org.python.core.PyMethod.__call__(PyMethod.java:215)

      org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

      org.python.core.PyMethod.__call__(PyMethod.java:206)

      org.python.core.PyObject.__call__(PyObject.java:381)

      org.python.core.PyObject.__call__(PyObject.java:385)

      org.python.pycode._pyx2142.importData$2(<string>:119)

      org.python.pycode._pyx2142.call_function(<string>)

      org.python.core.PyTableCode.call(PyTableCode.java:165)

      org.python.core.PyBaseCode.call(PyBaseCode.java:297)

      org.python.core.PyBaseCode.call(PyBaseCode.java:191)

      org.python.core.PyFunction.__call__(PyFunction.java:385)

      org.python.core.PyMethod.__call__(PyMethod.java:215)

      org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

      org.python.core.PyMethod.__call__(PyMethod.java:206)

      org.python.core.PyObject.__call__(PyObject.java:432)

      org.python.core.PyObject.__call__(PyObject.java:436)

      org.python.pycode._pyx2145.f$0(<string>:5)

      org.python.pycode._pyx2145.call_function(<string>)

      org.python.core.PyTableCode.call(PyTableCode.java:165)

      org.python.core.PyCode.call(PyCode.java:18)

      org.python.core.Py.runCode(Py.java:1204)

      org.python.core.Py.exec(Py.java:1248)

      org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)

      org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)

      com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

      com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

      oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

      oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

      oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

      com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

      com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

      com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

      com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

      oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

      oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

      oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

      org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

      oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

      oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

      oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

      oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:79)

      oracle.odi.runtime.agent.invocation.support.InternalLocalRuntimeAgentInvoker.invoke(InternalLocalRuntimeAgentInvoker.java:49)

      oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:173)

      oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:140)

      com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:271)

      com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)

      oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)

      oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)

      oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

      com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

      com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

      com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

      com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

      oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

      oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

      oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

      org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

      oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

      oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

      oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

      oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

      oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:564)

      oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:518)

      javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

      javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

      weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

      weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

      weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

      weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

      weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

      oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

      oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

      oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

      oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

      oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

      oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

      weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

      oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

      weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

      weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)

      weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

      weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

      weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

      weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)

      weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

      weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)

      weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

      weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

       

       

       

       

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying UD3 mapping on the row:[110170;Trade receivables (group);;EUR; 8,130,802 ;0.891910; 9,116,169 ;1.000000; 9,116,169 ;; -   ;;210170;Trade accounts payable (group);;EUR; 8,130,816 ;0.001524; 5,333,459,579 ;585.053950; 9,116,184 ;;;;-15 ;;15]

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying ENTITY mapping on the row:[111170;Other current receivables (group);;USD;;1.000000; -   ;1.000000; -   ;; -   ;;211170;Other current liabilities (group);;USD;;0.001709; -   ;585.053950; -   ;;;; -   ;;0]

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying ICP mapping on the row:[111170;Other current receivables (group);;USD;;1.000000; -   ;1.000000; -   ;; -   ;;211170;Other current liabilities (group);;USD;;0.001709; -   ;585.053950; -   ;;;; -   ;;0]

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Error: nullcom.hyperion.aif.file.common.util.DataLoadEngine$ImportItemFileEntity.evaluateExpressions(DataLoadEngine.java:1072)

      com.hyperion.aif.file.common.util.DataLoadEngine.processFileRow(DataLoadEngine.java:842)

      com.hyperion.aif.file.common.util.DataLoadEngine.loadRow(DataLoadEngine.java:431)

      com.hyperion.aif.file.data.ImportTextData.performLoad(ImportTextData.java:456)

      sun.reflect.GeneratedMethodAccessor28862.invoke(Unknown Source)

      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      java.lang.reflect.Method.invoke(Method.java:597)

      org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:175)

      org.python.core.PyObject.__call__(PyObject.java:355)

      org.python.core.PyMethod.__call__(PyMethod.java:215)

      org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

      org.python.core.PyMethod.__call__(PyMethod.java:206)

      org.python.core.PyObject.__call__(PyObject.java:381)

      org.python.core.PyObject.__call__(PyObject.java:385)

      org.python.pycode._pyx2142.importData$2(<string>:119)

      org.python.pycode._pyx2142.call_function(<string>)

      org.python.core.PyTableCode.call(PyTableCode.java:165)

      org.python.core.PyBaseCode.call(PyBaseCode.java:297)

      org.python.core.PyBaseCode.call(PyBaseCode.java:191)

      org.python.core.PyFunction.__call__(PyFunction.java:385)

      org.python.core.PyMethod.__call__(PyMethod.java:215)

      org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

      org.python.core.PyMethod.__call__(PyMethod.java:206)

      org.python.core.PyObject.__call__(PyObject.java:432)

      org.python.core.PyObject.__call__(PyObject.java:436)

      org.python.pycode._pyx2145.f$0(<string>:5)

      org.python.pycode._pyx2145.call_function(<string>)

      org.python.core.PyTableCode.call(PyTableCode.java:165)

      org.python.core.PyCode.call(PyCode.java:18)

      org.python.core.Py.runCode(Py.java:1204)

      org.python.core.Py.exec(Py.java:1248)

      org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)

      org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)

      com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

      com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

      oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

      oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

      oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

      com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

      com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

      com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

      com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

      oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

      oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

      oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

      org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

      oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

      oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

      oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

      oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:79)

      oracle.odi.runtime.agent.invocation.support.InternalLocalRuntimeAgentInvoker.invoke(InternalLocalRuntimeAgentInvoker.java:49)

      oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:173)

      oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:140)

      com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:271)

      com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)

      oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)

      oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)

      oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

      com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

      com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

      com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

      com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

      com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

      oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

      oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

      oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

      oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

      org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

      oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

      oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

      oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

      oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

      oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:564)

      oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:518)

      javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

      javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

      weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

      weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

      weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

      weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

      weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

      oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

      oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

      oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

      oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

      oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

      oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

      weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

      oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

      weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

      weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)

      weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

      weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

      weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

      weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)

      weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

      weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)

      weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

      weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

       

       

       

       

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying UD3 mapping on the row:[111170;Other current receivables (group);;USD;;1.000000; -   ;1.000000; -   ;; -   ;;211170;Other current liabilities (group);;USD;;0.001709; -   ;585.053950; -   ;;;; -   ;;0]

      2017-06-06 09:30:48,831 INFO  [AIF]: EPMFDM-140274:Message -  PROCESS ID: 339

      PARTITIONKEY: 8

      IMPORT GROUP: IF_EFGHICPartner

      FILE TYPE: DELIMITED

      DELIMITER: ;

      SOURCE FILE: Master_ABCD_Partner_EFGH1.csv

      PROCESSING CODES:

      -----------------------------------------------------------------------------------

      BLANK............. Line is blank or empty.

      NN................ Non-Numeric, Amount field contains non numeric characters.

      TC................ Type Conversion, Amount field could not be converted to a number.

      ZP................ Zero Suppress, Amount field contains a 0 value and zero suppress is ON.

      SKIP FIELD.............. SKIP field value was found

      NULL ACCOUNT VALUE.............. Account Field is null

      SKIP FROM SCRIPT.............. Skipped through Script

       

       

       

       

       

       

       

       

      [TC] - [Amount=NN] Company:;;;ABCD;;;;;;;;;Company:;;;EFGH;;;;;;;;;;;

      [TC] - [Amount=NN] 111170;Other current receivables (group);;USD;;1.000000; -   ;1.000000; -   ;; -   ;;211170;Other current liabilities (group);;USD;;0.001709; -   ;585.053950; -   ;;;; -   ;;0

      Rows Loaded: 1

      Rows Rejected: 2

       

       

       

       

      2017-06-06 09:30:48,831 INFO  [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Move

      2017-06-06 09:30:48,831 INFO  [AIF]: EPMFDM-140274:Message - Start archiving file:

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 33920170630

      2017-06-06 09:30:48,831 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: Master_ABCD_Partner_EFGH1

      Extension: csv

      2017-06-06 09:30:48,847 INFO  [AIF]: EPMFDM-140274:Message - Archive file name: 33920170630.csv

      2017-06-06 09:30:48,847 INFO  [AIF]: EPMFDM-140274:Message - Deleting the source file: Master_ABCD_Partner_EFGH1.csv

      2017-06-06 09:30:48,847 INFO  [AIF]: EPMFDM-140274:Message - Source File deleted: \\SVCHGVA1-429\FDMEEData\Master_ABCD_Partner_EFGH1.csv

      2017-06-06 09:30:48,847 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - End

      2017-06-06 09:30:48,847 INFO  [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 172

      2017-06-06 09:30:48,847 INFO  [AIF]: EPMFDM-140274:Message - Releasing JythonInterpreter

      2017-06-06 09:30:48,847 DEBUG [AIF]: FileData.importData - END

      2017-06-06 09:30:48,956 DEBUG [AIF]: CommData.postImportData - START

      2017-06-06 09:30:48,956 DEBUG [AIF]: CommData.getRuleInfo - START

      2017-06-06 09:30:48,956 DEBUG [AIF]:

            SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, dim.TARGET_DIMENSION_CLASS_NAME, tiie.IMPCONCATCHAR

                  ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1

            FROM TPOVPARTITION tpp

            INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

              ON adim.APPLICATION_ID = 2

            INNER JOIN AIF_DIMENSIONS dim

              ON dim.DIMENSION_ID = adim.DIMENSION_ID

            LEFT OUTER JOIN TBHVIMPITEMERPI tiie

              ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME AND tiie.IMPMAPTYPE = 'ERP'

            WHERE tpp.PARTITIONKEY = 8

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

            ORDER BY adim.BALANCE_COLUMN_NAME

       

       

      2017-06-06 09:30:48,972 DEBUG [AIF]: {'APPLICATION_ID': 2L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'DLR_EFGH', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem3', 'CATKEY': 1L, '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'AAACONSO', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'IF_EFGHICPartner', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'forensis', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 8L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 6L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 11L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 9L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'LOOKUP', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 27L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 7L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 13L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 10L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 8L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 6L, '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://SVCHGVA1-429.trading.AAA.grp:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 2L, 'IMPTARGETSOURCESYSTEMID': 0L}

      2017-06-06 09:30:48,972 DEBUG [AIF]: CommData.getRuleInfo - END

      2017-06-06 09:30:48,972 DEBUG [AIF]: CommData.updateTDATASEG_T - START

      2017-06-06 09:30:48,987 DEBUG [AIF]: CommData.getLedgerListAndMap - START

      2017-06-06 09:30:48,987 DEBUG [AIF]: CommData.getLedgerSQL - START

      2017-06-06 09:30:48,987 DEBUG [AIF]: CommData.getLedgerSQL - END

      2017-06-06 09:30:48,987 DEBUG [AIF]:

                SELECT COALESCE(br.SOURCE_LEDGER_ID,0) SOURCE_LEDGER_ID, NULL SOURCE_LEDGER_NAME, NULL SOURCE_COA_ID

                      ,br.CALENDAR_ID, NULL SETID, NULL PERIOD_TYPE, NULL LEDGER_TABLE_NAME

                FROM AIF_BALANCE_RULES br

                WHERE br.RULE_ID = 6

         

      2017-06-06 09:30:48,987 DEBUG [AIF]: CommData.getLedgerListAndMap - END

      2017-06-06 09:30:48,987 DEBUG [AIF]: CommData.getPovList - START

      2017-06-06 09:30:48,987 DEBUG [AIF]:

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

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

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

              FROM AIF_BAL_RULE_LOADS brl

              INNER JOIN AIF_BALANCE_RULES br

                ON br.RULE_ID = brl.RULE_ID

              INNER JOIN TPOVPARTITION part

                ON part.PARTITIONKEY = brl.PARTITIONKEY

              INNER JOIN TPOVCATEGORY cat

                ON cat.CATKEY = brl.CATKEY

              INNER JOIN AIF_PROCESS_PERIODS pprd

                ON pprd.PROCESS_ID = brl.LOADID

              LEFT OUTER JOIN TPOVPERIOD pp

                ON pp.PERIODKEY = pprd.PERIODKEY

              LEFT OUTER JOIN TLOGPROCESS tlp

                ON tlp.PARTITIONKEY = brl.PARTITIONKEY AND tlp.CATKEY = brl.CATKEY AND tlp.PERIODKEY = pprd.PERIODKEY AND tlp.RULE_ID = brl.RULE_ID

              WHERE brl.LOADID = 339

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

       

      2017-06-06 09:30:49,003 DEBUG [AIF]: CommData.getPovList - END

      2017-06-06 09:30:49,003 DEBUG [AIF]:

                SELECT pp.PERIODKEY

                FROM AIF_PROCESS_PERIODS pp

                   ,( SELECT entity_name FILE_ENTITY_NAME, pd.process_id, pd.entity_name_order

                      FROM aif_process_details pd

                      WHERE pd.entity_type     = 'PROCESS_BAL_IMP_FILE'

                      AND pd.target_table_name = 'TDATASEG'

                      AND pd.status            = 'FAILED'

                    ) en

                WHERE pp.PROCESS_ID    = 339

                AND en.process_id      = pp.process_id

                AND pp.IMP_ENTITY_NAME = en.file_entity_name

                order by en.entity_name_order

         

      2017-06-06 09:30:49,003 INFO  [AIF]:

      Import Data from Source for Period 'M6 - 2017'

      2017-06-06 09:30:49,003 DEBUG [AIF]: CommData.updateWorkflow - START

      2017-06-06 09:30:49,003 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 = 8 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2017-06-30' AND tlp.RULE_ID = 6 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

       

       

      2017-06-06 09:30:49,003 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME=CURRENT_TIMESTAMP

                 ,PROCESSSTATUS=0,PROCESSIMP=0,PROCESSVAL=0,PROCESSEXP=0,PROCESSENTLOAD=0,PROCESSENTVAL=0,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0

                 ,PROCESSIMPNOTE=NULL,PROCESSVALNOTE=NULL,PROCESSEXPNOTE=NULL,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL

              WHERE PARTITIONKEY=8 AND CATKEY=1 AND PERIODKEY='2017-06-30' AND RULE_ID=6

       

      2017-06-06 09:30:49,019 DEBUG [AIF]: CommData.updateWorkflow - END

      2017-06-06 09:30:49,019 DEBUG [AIF]:

                  SELECT adim.BALANCE_COLUMN_NAME DIMNAME, dim.TARGET_DIMENSION_CLASS_NAME

                  FROM TPOVPARTITION tpp

                  INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                    ON adim.APPLICATION_ID = tpp.PARTTARGETAPPLICATIONID AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                  INNER JOIN AIF_DIMENSIONS dim

                    ON dim.DIMENSION_ID = adim.DIMENSION_ID

                  WHERE tpp.PARTITIONKEY = 8

                  AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                  ORDER BY adim.BALANCE_COLUMN_NAME

           

      2017-06-06 09:30:49,019 DEBUG [AIF]:

                  UPDATE TDATASEG_T

                  SET AMOUNTX = AMOUNT

                     ,ACCOUNTX = NULL

                     ,ENTITYX = NULL

                     ,ICPX = NULL

                     ,UD1X = NULL

                     ,UD2X = NULL

                     ,UD3X = NULL

                     ,UD4X = NULL

                     ,UD5X = NULL

                  WHERE TDATASEG_T.LOADID = 339 AND TDATASEG_T.PARTITIONKEY = 8 AND TDATASEG_T.CATKEY = 1 AND TDATASEG_T.PERIODKEY = '2017-06-30'

           

      2017-06-06 09:30:49,019 INFO  [AIF]: Generic Data Rows Imported from Source: 1

      2017-06-06 09:30:49,019 DEBUG [AIF]:

                    INSERT INTO AIF_APPL_LOAD_AUDIT (

                      LOADID

                      ,TARGET_APPLICATION_TYPE

                      ,TARGET_APPLICATION_NAME

                      ,PLAN_TYPE

                      ,SOURCE_LEDGER_ID

                      ,EPM_YEAR

                      ,EPM_PERIOD

                      ,SNAPSHOT_FLAG

                      ,PARTITIONKEY

                      ,CATKEY

                      ,RULE_ID

                      ,PERIODKEY

                      ,EXPORT_TO_TARGET_FLAG

                    )

                    SELECT DISTINCT PROCESS_ID LOADID

                    ,'HFM' TARGET_APPLICATION_TYPE

                    ,'AAACONSO' TARGET_APPLICATION_NAME

                    ,NULL PLAN_TYPE

                    ,0 SOURCE_LEDGER_ID

                    ,YEARTARGET EPM_YEAR

                    ,PERIODTARGET EPM_PERIOD

                    ,'Y' SNAPSHOT_FLAG

                    ,8 PARTITIONKEY

                    ,1 CATKEY

                    ,6 RULE_ID

                    ,PERIODKEY

                    ,'N' EXPORT_TO_TARGET_FLAG

                    FROM AIF_PROCESS_PERIODS

                    WHERE PROCESS_ID = 339

                    AND PERIODKEY = '2017-06-30'

             

      2017-06-06 09:30:49,019 INFO  [AIF]: Total Data Rows Imported from Source: 1

      2017-06-06 09:30:49,019 DEBUG [AIF]: CommData.updateTDATASEG_T - END

      2017-06-06 09:30:49,034 DEBUG [AIF]: Comm.doScriptInit - START

      2017-06-06 09:30:49,144 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem3\FinancialDataQuality, INBOXDIR=\\SVCHGVA1-429\FDMEEData\inbox, LOCNAME=EFGH, SOURCENAME=File, APPID=2, SOURCEID=1, APPROOTDIR=\\SVCHGVA1-429\FDMEEData, IMPORTFORMAT=IF_EFGHICPartner, SCRIPTSDIR=\\SVCHGVA1-429\FDMEEData\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=6, CATNAME=Actual, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem3, LOADID=339, PERIODNAME=M6 - 2017, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2017-06-30, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=AAACONSO, FILENAME=Master_ABCD_Partner_EFGH1.csv, LOCKEY=8, RULENAME=DLR_EFGH, OUTBOXDIR=\\SVCHGVA1-429\FDMEEData\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=1, USERNAME=forensis, FILEDIR=, IMPORTFLAG=Y, USERLOCALE=null}

      2017-06-06 09:30:49,144 DEBUG [AIF]: The executeEventScript is set to: YES

      2017-06-06 09:30:49,144 DEBUG [AIF]: The AppRootFolder is set to: \\SVCHGVA1-429\FDMEEData

      2017-06-06 09:30:49,144 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

      2017-06-06 09:30:49,144 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB

      2017-06-06 09:30:49,144 DEBUG [AIF]: Comm.doScriptInit - END

      2017-06-06 09:30:49,144 DEBUG [AIF]: Comm.executeScript - START

      2017-06-06 09:30:49,144 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData/data/scripts/event/AftImport.py

      2017-06-06 09:30:49,159 DEBUG [AIF]: Comm.executeVBScript - START

      2017-06-06 09:30:49,159 DEBUG [AIF]: The WindowsTempFolder is set to: c:\users\hfm~1.adm\appdata\local\temp

      2017-06-06 09:30:49,159 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData\data\scripts\event\AftImport.vbs

      2017-06-06 09:30:49,159 DEBUG [AIF]: Comm.executeVBScript - END

      2017-06-06 09:30:49,159 DEBUG [AIF]: Comm.executeScript - END

      2017-06-06 09:30:49,159 DEBUG [AIF]: CommData.postImportData - END

      2017-06-06 09:30:49,394 DEBUG [AIF]: LogicGroup.createLogicAccounts - START

      2017-06-06 09:30:49,394 DEBUG [AIF]: Comm.executeScript - START

      2017-06-06 09:30:49,394 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData/data/scripts/event/BefProcLogicGrp.py

      2017-06-06 09:30:49,394 DEBUG [AIF]: Comm.executeVBScript - START

      2017-06-06 09:30:49,394 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData\data\scripts\event\BefProcLogicGrp.vbs

      2017-06-06 09:30:49,394 DEBUG [AIF]: Comm.executeVBScript - END

      2017-06-06 09:30:49,394 DEBUG [AIF]: Comm.executeScript - END

      2017-06-06 09:30:49,394 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START

      2017-06-06 09:30:49,394 DEBUG [AIF]:

              select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE

              from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp

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

              and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY

       

      2017-06-06 09:30:49,394 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END

      2017-06-06 09:30:49,394 DEBUG [AIF]: Logic group LG_ICREC is found

      2017-06-06 09:30:49,394 DEBUG [AIF]:

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

                litm.CALCSTMTWHERECLAUSEVALUE WHERECLAUSEVALUE, litm.CALCSTMTMATHOPERATOR MATHOPERATOR,

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

                from TBHVLOGICITEM litm

                where litm.CALCGROUPKEY='LG_ICREC'

                order by litm.CALCSTMTSEQUENCE

         

      2017-06-06 09:30:49,409 DEBUG [AIF]: Complex logic account processing

      2017-06-06 09:30:49,409 DEBUG [AIF]:

                        SELECT adim.BALANCE_COLUMN_NAME

                        FROM AIF_TARGET_APPL_DIMENSIONS adim

                        WHERE adim.APPLICATION_ID = 2

                        AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                        AND NOT EXISTS ( SELECT 1

                                         FROM TBHVLOGICITEMCRITERIA lic

                                         WHERE lic.CALCGROUPKEY = 'LG_ICREC'

                                         AND lic.CALCSTMTACCOUNT = 'ACCOUNT3'

                                         AND lic.DIMENSION = adim.BALANCE_COLUMN_NAME )

                 

      2017-06-06 09:30:49,409 DEBUG [AIF]:

                        SELECT DIMENSION

                        ,CRITERIATYPE

                        ,CRITERIAVALUE

                        ,GROUPBY

                        ,GROUPLEVEL

                        FROM TBHVLOGICITEMCRITERIA

                        WHERE CALCGROUPKEY = 'LG_ICREC'

                        AND CALCSTMTACCOUNT = 'ACCOUNT3'

                 

      2017-06-06 09:30:49,425 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

                    LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

                   ,VALID_FLAG, CURKEY, CALCACCTTYPE, ATTR13

                   ,AMOUNT, AMOUNTX, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,ACCOUNT

                      ,UD3

            

            )

            SELECT

                    LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

                   ,VALID_FLAG, CURKEY, CALCACCTTYPE, ATTR13

                   ,AMOUNT, AMOUNTX, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,ACCOUNT

                      ,UD3

            

            FROM (

                    SELECT LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

                          ,'Y' AS VALID_FLAG, CURKEY, 5 AS CALCACCTTYPE, 'ACCOUNT3' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT, SUM(AMOUNTX) AMOUNTX, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,'L'+ACCOUNT ACCOUNT

                      ,'NOMOVE_L' UD3

                    FROM TDATASEG_T

                    WHERE LOADID=339 AND CALCACCTTYPE NOT IN (5,-1) AND (ACCOUNT LIKE '3%') AND (1=1)

                    GROUP BY LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY, CURKEY, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,'L'+ACCOUNT

                 ) LOGIC_ACCOUNT

       

       

      2017-06-06 09:30:49,425 DEBUG [AIF]: Inserted 0 rows for logic account ACCOUNT3

      2017-06-06 09:30:49,425 DEBUG [AIF]:

                        SELECT adim.BALANCE_COLUMN_NAME

                        FROM AIF_TARGET_APPL_DIMENSIONS adim

                        WHERE adim.APPLICATION_ID = 2

                        AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                        AND NOT EXISTS ( SELECT 1

                                         FROM TBHVLOGICITEMCRITERIA lic

                                         WHERE lic.CALCGROUPKEY = 'LG_ICREC'

                                         AND lic.CALCSTMTACCOUNT = 'ACCOUNT4'

                                         AND lic.DIMENSION = adim.BALANCE_COLUMN_NAME )

                 

      2017-06-06 09:30:49,425 DEBUG [AIF]:

                        SELECT DIMENSION

                        ,CRITERIATYPE

                        ,CRITERIAVALUE

                        ,GROUPBY

                        ,GROUPLEVEL

                        FROM TBHVLOGICITEMCRITERIA

                        WHERE CALCGROUPKEY = 'LG_ICREC'

                        AND CALCSTMTACCOUNT = 'ACCOUNT4'

                 

      2017-06-06 09:30:49,425 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

                    LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

                   ,VALID_FLAG, CURKEY, CALCACCTTYPE, ATTR13

                   ,AMOUNT, AMOUNTX, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,ACCOUNT

                      ,UD3

            

            )

            SELECT

                    LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

                   ,VALID_FLAG, CURKEY, CALCACCTTYPE, ATTR13

                   ,AMOUNT, AMOUNTX, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,ACCOUNT

                      ,UD3

            

            FROM (

                    SELECT LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

                          ,'Y' AS VALID_FLAG, CURKEY, 5 AS CALCACCTTYPE, 'ACCOUNT4' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT, SUM(AMOUNTX) AMOUNTX, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,'L'+ACCOUNT ACCOUNT

                      ,'NOMOVE_L' UD3

                    FROM TDATASEG_T

                    WHERE LOADID=339 AND CALCACCTTYPE NOT IN (5,-1) AND (ACCOUNT LIKE '4%') AND (1=1)

                    GROUP BY LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY, CURKEY, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,'L'+ACCOUNT

                 ) LOGIC_ACCOUNT

       

       

      2017-06-06 09:30:49,440 DEBUG [AIF]: Inserted 0 rows for logic account ACCOUNT4

      2017-06-06 09:30:49,440 DEBUG [AIF]:

                        SELECT adim.BALANCE_COLUMN_NAME

                        FROM AIF_TARGET_APPL_DIMENSIONS adim

                        WHERE adim.APPLICATION_ID = 2

                        AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                        AND NOT EXISTS ( SELECT 1

                                         FROM TBHVLOGICITEMCRITERIA lic

                                         WHERE lic.CALCGROUPKEY = 'LG_ICREC'

                                         AND lic.CALCSTMTACCOUNT = 'ACCOUNT5'

                                         AND lic.DIMENSION = adim.BALANCE_COLUMN_NAME )

                 

      2017-06-06 09:30:49,440 DEBUG [AIF]:

                        SELECT DIMENSION

                        ,CRITERIATYPE

                        ,CRITERIAVALUE

                        ,GROUPBY

                        ,GROUPLEVEL

                        FROM TBHVLOGICITEMCRITERIA

                        WHERE CALCGROUPKEY = 'LG_ICREC'

                        AND CALCSTMTACCOUNT = 'ACCOUNT5'

                 

      2017-06-06 09:30:49,440 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

                    LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

                   ,VALID_FLAG, CURKEY, CALCACCTTYPE, ATTR13

                   ,AMOUNT, AMOUNTX, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,ACCOUNT

                      ,UD3

            

            )

            SELECT

                    LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

                   ,VALID_FLAG, CURKEY, CALCACCTTYPE, ATTR13

                   ,AMOUNT, AMOUNTX, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,ACCOUNT

                      ,UD3

            

            FROM (

                    SELECT LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

                          ,'Y' AS VALID_FLAG, CURKEY, 5 AS CALCACCTTYPE, 'ACCOUNT5' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT, SUM(AMOUNTX) AMOUNTX, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,'L'+ACCOUNT ACCOUNT

                      ,'NOMOVE_L' UD3

                    FROM TDATASEG_T

                    WHERE LOADID=339 AND CALCACCTTYPE NOT IN (5,-1) AND (ACCOUNT LIKE '5%') AND (1=1)

                    GROUP BY LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY, CURKEY, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,'L'+ACCOUNT

                 ) LOGIC_ACCOUNT

       

       

      2017-06-06 09:30:49,440 DEBUG [AIF]: Inserted 0 rows for logic account ACCOUNT5

      2017-06-06 09:30:49,440 DEBUG [AIF]:

                        SELECT adim.BALANCE_COLUMN_NAME

                        FROM AIF_TARGET_APPL_DIMENSIONS adim

                        WHERE adim.APPLICATION_ID = 2

                        AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                        AND NOT EXISTS ( SELECT 1

                                         FROM TBHVLOGICITEMCRITERIA lic

                                         WHERE lic.CALCGROUPKEY = 'LG_ICREC'

                                         AND lic.CALCSTMTACCOUNT = 'ACCOUNT6'

                                         AND lic.DIMENSION = adim.BALANCE_COLUMN_NAME )

                 

      2017-06-06 09:30:49,456 DEBUG [AIF]:

                        SELECT DIMENSION

                        ,CRITERIATYPE

                        ,CRITERIAVALUE

                        ,GROUPBY

                        ,GROUPLEVEL

                        FROM TBHVLOGICITEMCRITERIA

                        WHERE CALCGROUPKEY = 'LG_ICREC'

                        AND CALCSTMTACCOUNT = 'ACCOUNT6'

                 

      2017-06-06 09:30:49,456 DEBUG [AIF]:

            INSERT INTO TDATASEG_T (

                    LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

                   ,VALID_FLAG, CURKEY, CALCACCTTYPE, ATTR13

                   ,AMOUNT, AMOUNTX, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,ACCOUNT

                      ,UD3

            

            )

            SELECT

                    LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

                   ,VALID_FLAG, CURKEY, CALCACCTTYPE, ATTR13

                   ,AMOUNT, AMOUNTX, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,ACCOUNT

                      ,UD3

            

            FROM (

                    SELECT LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

                          ,'Y' AS VALID_FLAG, CURKEY, 5 AS CALCACCTTYPE, 'ACCOUNT6' AS ATTR13

                          ,SUM(AMOUNT) AMOUNT, SUM(AMOUNTX) AMOUNTX, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,'L'+ACCOUNT ACCOUNT

                      ,'NOMOVE_L' UD3

                    FROM TDATASEG_T

                    WHERE LOADID=339 AND CALCACCTTYPE NOT IN (5,-1) AND (ACCOUNT LIKE '6%') AND (1=1)

                    GROUP BY LOADID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY, CURKEY, ICP, UD4, UD2, UD1, ENTITY, UD5, DATAVIEW, JOURNALID

                      ,'L'+ACCOUNT

                 ) LOGIC_ACCOUNT

       

       

      2017-06-06 09:30:49,456 DEBUG [AIF]: Inserted 0 rows for logic account ACCOUNT6

      2017-06-06 09:30:49,456 DEBUG [AIF]: Comm.executeScript - START

      2017-06-06 09:30:49,456 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData/data/scripts/event/AftProcLogicGrp.py

      2017-06-06 09:30:49,456 DEBUG [AIF]: Comm.executeVBScript - START

      2017-06-06 09:30:49,456 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData\data\scripts\event\AftProcLogicGrp.vbs

      2017-06-06 09:30:49,456 DEBUG [AIF]: Comm.executeVBScript - END

      2017-06-06 09:30:49,456 DEBUG [AIF]: Comm.executeScript - END

      2017-06-06 09:30:49,456 DEBUG [AIF]: LogicGroup.createLogicAccounts - END

      2017-06-06 09:30:49,503 DEBUG [AIF]: CommData.mapData - START

      2017-06-06 09:30:49,503 DEBUG [AIF]: CommData.insertTransProcessDetails - START

      2017-06-06 09:30:49,503 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, 'forensis' 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 = 339

                  AND PRIOR_PERIOD_FLAG = 'N'

                  GROUP BY PROCESS_ID, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME

                ) q

                ORDER BY ENTITY_NAME_ORDER

         

      2017-06-06 09:30:49,503 DEBUG [AIF]: CommData.insertTransProcessDetails - END

      2017-06-06 09:30:49,503 DEBUG [AIF]:

              DELETE FROM TDATAMAP_T

              WHERE LOADID < 339

              AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 6 AND p.PROCESS_ID = TDATAMAP_T.LOADID )

       

      2017-06-06 09:30:49,503 DEBUG [AIF]:

              DELETE FROM TDATASEG_T

              WHERE LOADID < 339

              AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 6 AND p.PROCESS_ID = TDATASEG_T.LOADID )

       

      2017-06-06 09:30:49,503 DEBUG [AIF]:

              DELETE FROM AIF_PROCESS_PERIODS

              WHERE PROCESS_ID < 339

              AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 6 AND p.PROCESS_ID = AIF_PROCESS_PERIODS.PROCESS_ID )

       

      2017-06-06 09:30:49,519 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START

      2017-06-06 09:30:49,519 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START

      2017-06-06 09:30:49,519 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 = 8

       

      2017-06-06 09:30:49,519 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END

      2017-06-06 09:30:49,519 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 339, DATAKEY, 8 PARTITIONKEY, DIMNAME, SRCKEY, SRCDESC, CASE WHEN TARGKEY = '<BLANK>' THEN ' ' ELSE TARGKEY END

                    ,WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG, RULE_ID

              FROM TDATAMAP tdm

              WHERE PARTITIONKEY = 8

              AND ( RULE_ID IS NULL OR RULE_ID = 6 )

              AND ( TDATAMAPTYPE = 'ERP'

                    OR

                    ( TDATAMAPTYPE = 'MULTIDIM'

                      AND EXISTS ( SELECT 1

                                   FROM TDATAMAP multidim

                                   WHERE multidim.PARTITIONKEY = tdm.PARTITIONKEY

                                   AND multidim.TDATAMAPTYPE = 'ERP'

                                   AND multidim.DATAKEY = tdm.TARGKEY )

                    )

                  )

       

      2017-06-06 09:30:49,519 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 10

      2017-06-06 09:30:49,581 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START

      2017-06-06 09:30:49,581 DEBUG [AIF]: Comm.executeScript - START

      2017-06-06 09:30:49,581 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData/data/scripts/event/BefProcMap.py

      2017-06-06 09:30:49,581 DEBUG [AIF]: Comm.executeVBScript - START

      2017-06-06 09:30:49,581 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData\data\scripts\event\BefProcMap.vbs

      2017-06-06 09:30:49,581 DEBUG [AIF]: Comm.executeVBScript - END

      2017-06-06 09:30:49,581 DEBUG [AIF]: Comm.executeScript - END

      2017-06-06 09:30:49,581 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 = 339

              AND atad.APPLICATION_ID = 2

              AND tdm.PARTITIONKEY = 8

              AND tdm.TDATAMAPTYPE = 'ERP'

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

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

              AND atad.APPLICATION_ID = 2

              AND tdm.PARTITIONKEY = 8

              AND tdm.TDATAMAPTYPE = 'ERP'

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

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

            ) q

            ORDER BY CALC_SEQ, DIMNAME, SEQUENCE, RULE_ID, SYSTEM_GENERATED_FLAG, SRCKEY

       

       

      2017-06-06 09:30:49,581 DEBUG [AIF]: SELECT VBSCRIPT FROM TDATAMAP_T WHERE LOADID = 339 AND PARTITIONKEY = 8 AND DATAKEY = 100

      2017-06-06 09:30:49,581 INFO  [AIF]:

      Map Data for Period 'M6 - 2017'

      2017-06-06 09:30:49,581 DEBUG [AIF]: Comm.updateProcessDetail - START

      2017-06-06 09:30:49,597 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 ('forensis' IS NULL) THEN LAST_UPDATED_BY ELSE 'forensis' END

             ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

          WHERE PROCESS_ID = 339 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'M6 - 2017'

       

       

      2017-06-06 09:30:49,597 DEBUG [AIF]: Comm.updateProcessDetail - END

      2017-06-06 09:30:49,597 DEBUG [AIF]:

            SELECT COUNT(*) ROW_COUNT

            FROM TDATASEG_T

            WHERE LOADID = 339

            AND (PARTITIONKEY = 8 AND CATKEY = 1 AND PERIODKEY = '2017-06-30' AND RULE_ID = 6 AND VALID_FLAG = 'Y')

       

       

      2017-06-06 09:30:49,597 INFO  [AIF]:

      Processing Mappings for Column 'ENTITY'

      2017-06-06 09:30:49,597 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 IS NULL

                                 AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )

                    ,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 IS NULL

                                 AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )

                    ,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 IS NULL

                                 AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )

                    ,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 IS NULL

                                 AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )

                    ,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 IS NULL

                                 AND tdm.TDATAMAPTYPE <> 'MULTIDIM' ) WHEN 'IGNORE' THEN 'I' ELSE VALID_FLAG END

                    WHERE LOADID = 339

                    AND PARTITIONKEY = 8

                    AND CATKEY = 1

                    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 IS NULL

                                 AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )

                    AND PERIODKEY = '2017-06-30'

      2017-06-06 09:30:49,597 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 1

      2017-06-06 09:30:49,597 INFO  [AIF]:

      Processing Mappings for Column 'ACCOUNT'

      2017-06-06 09:30:49,597 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET ACCOUNTX = SUBSTRING(ACCOUNT,1+1,LEN(ACCOUNT)-1)

                       ,ACCOUNTR = 101

                       ,ACCOUNTF = 3

                    WHERE LOADID = 339

                    AND PARTITIONKEY = 8

                    AND CATKEY = 1

                    AND (ACCOUNTX IS NULL OR ACCOUNTX = '')

                    AND (ACCOUNT LIKE 'L%')

                    AND PERIODKEY = '2017-06-30'

      2017-06-06 09:30:49,597 INFO  [AIF]: Data Rows Updated by Location Mapping '01_R_ACCLOGICGROUP' (LIKE): 0

      2017-06-06 09:30:49,597 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET ACCOUNTX = ACCOUNT

                       ,ACCOUNTR = 88

                       ,ACCOUNTF = 3

                    WHERE LOADID = 339

                    AND PARTITIONKEY = 8

                    AND CATKEY = 1

                    AND (ACCOUNTX IS NULL OR ACCOUNTX = '')

                    AND (1=1)

                    AND PERIODKEY = '2017-06-30'

      2017-06-06 09:30:49,612 INFO  [AIF]: Data Rows Updated by Location Mapping '02_R_ACC' (LIKE): 1

      2017-06-06 09:30:49,612 INFO  [AIF]:

      Processing Mappings for Column 'ICP'

      2017-06-06 09:30:49,612 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET ICPX = ICP

                       ,ICPR = 95

                       ,ICPF = 3

                    WHERE LOADID = 339

                    AND PARTITIONKEY = 8

                    AND CATKEY = 1

                    AND (ICPX IS NULL OR ICPX = '')

                    AND (1=1)

                    AND PERIODKEY = '2017-06-30'

      2017-06-06 09:30:49,612 INFO  [AIF]: Data Rows Updated by Location Mapping 'R_LI_ICP' (LIKE): 1

      2017-06-06 09:30:49,612 INFO  [AIF]:

      Processing Mappings for Column 'UD1'

      2017-06-06 09:30:49,612 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET UD1X = '[None]'

                       ,UD1R = 89

                       ,UD1F = 3

                    WHERE LOADID = 339

                    AND PARTITIONKEY = 8

                    AND CATKEY = 1

                    AND (UD1X IS NULL OR UD1X = '')

                    AND (1=1)

                    AND PERIODKEY = '2017-06-30'

      2017-06-06 09:30:49,612 INFO  [AIF]: Data Rows Updated by Location Mapping 'R_CUSTOM1' (LIKE): 1

      2017-06-06 09:30:49,612 INFO  [AIF]:

      Processing Mappings for Column 'UD2'

      2017-06-06 09:30:49,612 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET UD2X = '[None]'

                       ,UD2R = 90

                       ,UD2F = 3

                    WHERE LOADID = 339

                    AND PARTITIONKEY = 8

                    AND CATKEY = 1

                    AND (UD2X IS NULL OR UD2X = '')

                    AND (1=1)

                    AND PERIODKEY = '2017-06-30'

      2017-06-06 09:30:49,612 INFO  [AIF]: Data Rows Updated by Location Mapping 'R_CUSTOM2' (LIKE): 1

      2017-06-06 09:30:49,612 INFO  [AIF]:

      Processing Mappings for Column 'UD3'

      2017-06-06 09:30:49,612 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 IS NULL

                                 AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )

                    ,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 IS NULL

                                 AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )

                    ,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 IS NULL

                                 AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )

                    ,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 IS NULL

                                 AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )

                    ,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 IS NULL

                                 AND tdm.TDATAMAPTYPE <> 'MULTIDIM' ) WHEN 'IGNORE' THEN 'I' ELSE VALID_FLAG END

                    WHERE LOADID = 339

                    AND PARTITIONKEY = 8

                    AND CATKEY = 1

                    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 IS NULL

                                 AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )

                    AND PERIODKEY = '2017-06-30'

      2017-06-06 09:30:49,612 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 1

      2017-06-06 09:30:49,612 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET UD3X = CASE

      WHEN UD3='NOMOVE_L' THEN 'NOMOVE_L'

      END,

      AMOUNTX=

      CASE

      WHEN UD3='NOMOVE_L' THEN convert(float,replace(UD5,',',''))

      END

                       ,UD3R = 100

                       ,UD3F = 3

                    WHERE LOADID = 339

                    AND PARTITIONKEY = 8

                    AND CATKEY = 1

                    AND (UD3X IS NULL OR UD3X = '')

                    AND (UD3 IN ('NOMOVE_L'))

                    AND PERIODKEY = '2017-06-30'

      2017-06-06 09:30:49,628 INFO  [AIF]: Data Rows Updated by Location Mapping 'R_LI_CUSTOM3' (IN): 0

      2017-06-06 09:30:49,628 INFO  [AIF]:

      Processing Mappings for Column 'UD4'

      2017-06-06 09:30:49,628 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET UD4X = UD4

                       ,UD4R = 96

                       ,UD4F = 3

                    WHERE LOADID = 339

                    AND PARTITIONKEY = 8

                    AND CATKEY = 1

                    AND (UD4X IS NULL OR UD4X = '')

                    AND (1=1)

                    AND PERIODKEY = '2017-06-30'

      2017-06-06 09:30:49,628 INFO  [AIF]: Data Rows Updated by Location Mapping 'R_LI_C4' (LIKE): 1

      2017-06-06 09:30:49,628 INFO  [AIF]:

      Processing Mappings for Column 'UD5'

      2017-06-06 09:30:49,628 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET UD5X = '[None]'

                       ,UD5R = 97

                       ,UD5F = 3

                    WHERE LOADID = 339

                    AND PARTITIONKEY = 8

                    AND CATKEY = 1

                    AND (UD5X IS NULL OR UD5X = '')

                    AND (1=1)

                    AND PERIODKEY = '2017-06-30'

      2017-06-06 09:30:49,628 INFO  [AIF]: Data Rows Updated by Location Mapping 'R_LI_AMT2' (LIKE): 1

      2017-06-06 09:30:49,628 DEBUG [AIF]: Comm.updateProcessDetail - START

      2017-06-06 09:30:49,628 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 ('forensis' IS NULL) THEN LAST_UPDATED_BY ELSE 'forensis' END

             ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

          WHERE PROCESS_ID = 339 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'M6 - 2017'

       

       

      2017-06-06 09:30:49,628 DEBUG [AIF]: Comm.updateProcessDetail - END

      2017-06-06 09:30:49,628 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END

      2017-06-06 09:30:49,628 DEBUG [AIF]:

            UPDATE TDATASEG_T

            SET ATTR14 = DATAKEY

            WHERE LOADID = 339 AND PARTITIONKEY = 8 AND CATKEY = 1 AND PERIODKEY = '2017-06-30'

       

       

      2017-06-06 09:30:49,644 DEBUG [AIF]: CommData.updateYtdAmounts - START

      2017-06-06 09:30:49,644 DEBUG [AIF]: CommData.getLedgerListAndMap - START

      2017-06-06 09:30:49,644 DEBUG [AIF]: CommData.getLedgerSQL - START

      2017-06-06 09:30:49,644 DEBUG [AIF]: CommData.getLedgerSQL - END

      2017-06-06 09:30:49,644 DEBUG [AIF]:

                SELECT COALESCE(br.SOURCE_LEDGER_ID,0) SOURCE_LEDGER_ID, NULL SOURCE_LEDGER_NAME, NULL SOURCE_COA_ID

                      ,br.CALENDAR_ID, NULL SETID, NULL PERIOD_TYPE, NULL LEDGER_TABLE_NAME

                FROM AIF_BALANCE_RULES br

                WHERE br.RULE_ID = 6

         

      2017-06-06 09:30:49,644 DEBUG [AIF]: CommData.getLedgerListAndMap - END

      2017-06-06 09:30:49,644 DEBUG [AIF]:

                  SELECT brl.PARTITIONKEY, brl.CATKEY, pprd.YEARTARGET, pprd.PERIODTARGET, pprd.SOURCE_LEDGER_ID

                  FROM AIF_BAL_RULE_LOADS brl

                      ,AIF_PROCESS_PERIODS pprd

                  WHERE brl.LOADID = 339

                  AND pprd.PROCESS_ID = brl.LOADID

                  AND pprd.PRIOR_PERIOD_FLAG = 'N'

                  GROUP BY brl.PARTITIONKEY, brl.CATKEY, pprd.YEARTARGET, pprd.PERIODTARGET, pprd.SOURCE_LEDGER_ID

                  HAVING COUNT(*) > 1

           

      2017-06-06 09:30:49,644 DEBUG [AIF]: CommData.updateYtdAmounts - END

      2017-06-06 09:30:49,659 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START

      2017-06-06 09:30:49,659 INFO  [AIF]:

      Stage Data for Period 'M6 - 2017'

      2017-06-06 09:30:49,659 DEBUG [AIF]:

              DELETE FROM TDATAMAPSEG

              WHERE PARTITIONKEY = 8

              AND CATKEY = 1

              AND PERIODKEY = '2017-06-30'

              AND ( TDATAMAPTYPE = 'ERP'

                    OR

                    ( TDATAMAPTYPE = 'MULTIDIM'

                      AND EXISTS ( SELECT 1

                                   FROM TDATAMAPSEG parent

                                   WHERE parent.PARTITIONKEY = TDATAMAPSEG.PARTITIONKEY

                                   AND parent.DATAKEY = TDATAMAPSEG.TARGKEY

                                   AND parent.CATKEY = TDATAMAPSEG.CATKEY

                                   AND parent.PERIODKEY = TDATAMAPSEG.PERIODKEY

                                   AND parent.TDATAMAPTYPE = 'ERP' )

                    )

                  )

       

      2017-06-06 09:30:49,659 INFO  [AIF]: Number of Rows deleted from TDATAMAPSEG: 10

      2017-06-06 09:30:49,659 DEBUG [AIF]:

              INSERT INTO TDATAMAPSEG (

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

                     WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG

              )

              SELECT DATAKEY, PARTITIONKEY, 1, '2017-06-30', DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,

                     WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG

              FROM TDATAMAP_T

              WHERE LOADID = 339

       

      2017-06-06 09:30:49,675 INFO  [AIF]: Number of Rows inserted into TDATAMAPSEG: 10

      2017-06-06 09:30:49,675 DEBUG [AIF]:

              DELETE FROM TDATAMAP_T

              WHERE LOADID = 339

       

      2017-06-06 09:30:49,675 INFO  [AIF]: Number of Rows deleted from TDATAMAP_T: 10

      2017-06-06 09:30:49,675 DEBUG [AIF]:

                  DELETE FROM TDATASEG

                  WHERE LOADID < 339 AND PARTITIONKEY = 8 AND CATKEY = 1 AND RULE_ID = 6 AND PERIODKEY = '2017-06-30'

           

      2017-06-06 09:30:49,675 INFO  [AIF]: Number of Rows deleted from TDATASEG: 1

      2017-06-06 09:30:49,675 DEBUG [AIF]:

                  DELETE FROM TDATAMEMOITEMS

                  WHERE PARTITIONKEY = 8 AND PERIODKEY = '2017-06-30' AND CATKEY = 1 AND RULE_ID = 6

                  AND NOT EXISTS (SELECT 1 FROM TDATASEG WHERE TDATASEG.DATAKEY = TDATAMEMOITEMS.DATAKEY)

           

      2017-06-06 09:30:49,675 INFO  [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

      2017-06-06 09:30:49,675 DEBUG [AIF]:

                  DELETE FROM TDATAARCHIVE

                  WHERE PARTITIONKEY = 8 AND PERIODKEY = '2017-06-30' AND CATKEY = 1 AND RULE_ID = 6

                  AND ARCHIVEPROCTYPEID = 1

                  AND NOT EXISTS ( SELECT 1

                                   FROM TDATAMEMOITEMS

                                   WHERE TDATAMEMOITEMS.MEMOITEMSD1 = TDATAARCHIVE.ARCHIVEID

                                   OR TDATAMEMOITEMS.MEMOITEMSD2 = TDATAARCHIVE.ARCHIVEID                   

                                   OR TDATAMEMOITEMS.MEMOITEMSD3 = TDATAARCHIVE.ARCHIVEID                   

                                   OR TDATAMEMOITEMS.MEMOITEMSD4 = TDATAARCHIVE.ARCHIVEID                   

                                   OR TDATAMEMOITEMS.MEMOITEMSD5 = TDATAARCHIVE.ARCHIVEID                   

                                   OR TDATAMEMOITEMS.MEMOITEMSD6 = TDATAARCHIVE.ARCHIVEID                   

                                   OR TDATAMEMOITEMS.MEMOITEMSD7 = TDATAARCHIVE.ARCHIVEID                   

                                   OR TDATAMEMOITEMS.MEMOITEMSD8 = TDATAARCHIVE.ARCHIVEID                   

                                   OR TDATAMEMOITEMS.MEMOITEMSD9 = TDATAARCHIVE.ARCHIVEID                   

                                   OR TDATAMEMOITEMS.MEMOITEMSD10 = TDATAARCHIVE.ARCHIVEID )

           

      2017-06-06 09:30:49,675 INFO  [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

      2017-06-06 09:30:49,675 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 = 339 AND PARTITIONKEY = 8 AND CATKEY = 1 AND PERIODKEY = '2017-06-30'

         

      2017-06-06 09:30:49,675 INFO  [AIF]: Number of Rows inserted into TDATASEG: 1

      2017-06-06 09:30:49,675 DEBUG [AIF]:

              DELETE FROM TDATASEG_T

              WHERE LOADID = 339 AND PARTITIONKEY = 8 AND CATKEY = 1 AND PERIODKEY = '2017-06-30'

       

      2017-06-06 09:30:49,675 INFO  [AIF]: Number of Rows deleted from TDATASEG_T: 1

      2017-06-06 09:30:49,690 DEBUG [AIF]: CommData.updateWorkflow - START

      2017-06-06 09:30:49,690 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME=CURRENT_TIMESTAMP

                 ,PROCESSSTATUS=1,PROCESSIMP=1,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0

                 ,PROCESSIMPNOTE='AIF_WF_IMP_IMPORT_OK_TXT'

              WHERE PARTITIONKEY=8 AND CATKEY=1 AND PERIODKEY='2017-06-30' AND RULE_ID=6

       

      2017-06-06 09:30:49,690 DEBUG [AIF]: CommData.updateWorkflow - END

      2017-06-06 09:30:49,690 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END

      2017-06-06 09:30:49,690 DEBUG [AIF]: Comm.executeScript - START

      2017-06-06 09:30:49,690 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData/data/scripts/event/AftProcMap.py

      2017-06-06 09:30:49,690 DEBUG [AIF]: Comm.executeVBScript - START

      2017-06-06 09:30:49,690 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData\data\scripts\event\AftProcMap.vbs

      2017-06-06 09:30:49,690 DEBUG [AIF]: Comm.executeVBScript - END

      2017-06-06 09:30:49,690 DEBUG [AIF]: Comm.executeScript - END

      2017-06-06 09:30:49,690 DEBUG [AIF]: CommData.mapData - END

      2017-06-06 09:30:49,722 INFO  [AIF]: -------END IMPORT STEP-------

      2017-06-06 09:30:49,753 INFO  [AIF]: -------START VALIDATE STEP-------

      2017-06-06 09:30:49,800 DEBUG [AIF]: CommData.validateData - START

      2017-06-06 09:30:49,800 DEBUG [AIF]: Comm.executeScript - START

      2017-06-06 09:30:49,800 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData/data/scripts/event/BefValidate.py

      2017-06-06 09:30:49,800 DEBUG [AIF]: Comm.executeVBScript - START

      2017-06-06 09:30:49,800 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData\data\scripts\event\BefValidate.vbs

      2017-06-06 09:30:49,800 DEBUG [AIF]: Comm.executeVBScript - END

      2017-06-06 09:30:49,800 DEBUG [AIF]: Comm.executeScript - END

      2017-06-06 09:30:49,800 DEBUG [AIF]: CommMap.validateData - START

      2017-06-06 09:30:49,815 INFO  [AIF]:

      Validate Data Mappings for Period 'M6 - 2017'

      2017-06-06 09:30:49,815 DEBUG [AIF]:

            SELECT COUNT(*) ROW_COUNT

            FROM TDATASEG

            WHERE LOADID = 339

            AND (PARTITIONKEY = 8 AND CATKEY = 1 AND PERIODKEY = '2017-06-30' AND RULE_ID = 6 AND VALID_FLAG = 'Y')

       

       

      2017-06-06 09:30:49,815 DEBUG [AIF]: CommData.updateWorkflow - START

      2017-06-06 09:30:49,815 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 = 8 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2017-06-30' AND tlp.RULE_ID = 6 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

       

       

      2017-06-06 09:30:49,815 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=8 AND CATKEY=1 AND PERIODKEY='2017-06-30' AND RULE_ID=6

       

      2017-06-06 09:30:49,815 DEBUG [AIF]: CommData.updateWorkflow - END

      2017-06-06 09:30:49,815 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 = 339 AND PARTITIONKEY = 8 AND CATKEY = 1 AND PERIODKEY = '2017-06-30'

                      AND VALID_FLAG = 'Y'

                      AND CALCACCTTYPE > 0

               

      2017-06-06 09:30:49,815 INFO  [AIF]: Data Rows Marked as Invalid: 1

      2017-06-06 09:30:49,815 ERROR [AIF]: Error: Data rows with unmapped dimensions exist for Period 'M6 - 2017'

      2017-06-06 09:30:49,815 DEBUG [AIF]: CommData.updateWorkflow - START

      2017-06-06 09:30:49,815 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME=CURRENT_TIMESTAMP

                 ,PROCESSSTATUS=12,PROCESSVAL=0,BLNVALDIRTY=0

                 ,PROCESSVALNOTE='AIF_WF_VAL_VALIDATE_ERR;1'

              WHERE PARTITIONKEY=8 AND CATKEY=1 AND PERIODKEY='2017-06-30' AND RULE_ID=6

       

      2017-06-06 09:30:49,815 DEBUG [AIF]: CommData.updateWorkflow - END

      2017-06-06 09:30:49,815 INFO  [AIF]: Total Data Rows available for Export to Target: 0

      2017-06-06 09:30:49,815 FATAL [AIF]: Error in CommMap.validateData

      Traceback (most recent call last):

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

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

       

       

       

       

      2017-06-06 09:30:49,831 FATAL [AIF]: Error in CommData.validateData

      Traceback (most recent call last):

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

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

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

       

       

       

       

      2017-06-06 09:30:49,831 DEBUG [AIF]: Comm.executeScript - START

      2017-06-06 09:30:49,831 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData/data/scripts/event/AftValidate.py

      2017-06-06 09:30:49,831 DEBUG [AIF]: Comm.executeVBScript - START

      2017-06-06 09:30:49,831 DEBUG [AIF]: The following script does not exist: \\SVCHGVA1-429\FDMEEData\data\scripts\event\AftValidate.vbs

      2017-06-06 09:30:49,831 DEBUG [AIF]: Comm.executeVBScript - END

      2017-06-06 09:30:49,831 DEBUG [AIF]: Comm.executeScript - END

      2017-06-06 09:30:49,878 DEBUG [AIF]: Comm.finalizeProcess - START

      2017-06-06 09:30:49,878 DEBUG [AIF]: CommData.updateRuleStatus - START

      2017-06-06 09:30:49,878 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 = 339 AND pd.STATUS IN ('FAILED','WARNING') )

                WHEN 0 THEN 'SUCCESS'

                ELSE ( SELECT MIN(pd.STATUS) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 339 AND pd.STATUS IN ('FAILED','WARNING') ) END

            ELSE 'FAILED' END

          WHERE RULE_ID = 6

       

       

      2017-06-06 09:30:49,878 DEBUG [AIF]: CommData.updateRuleStatus - END

      2017-06-06 09:30:49,894 FATAL [AIF]: Error in COMM Validate Data

      2017-06-06 09:30:49,894 DEBUG [AIF]: Comm.updateProcess - START

      2017-06-06 09:30:49,894 DEBUG [AIF]: Comm.updateProcess - END

      2017-06-06 09:30:49,894 DEBUG [AIF]: The fdmAPI connection has been closed.

      2017-06-06 09:30:49,894 INFO  [AIF]: FDMEE Process End, Process ID: 339

        • 2. Re: FDMEE retrieving and storing global variable always returns no data
          3355552

          Hi everyone,

           

          I see that the problem lies because I am using "Delimited" text file and not "Fixed" file in import format. Once I change my file into "Fixed" file , it will work.

          Is there anyway that I can achieve this behaviour of taking stored variable using "delimited" text file????

           

          Tx.

          • 3. Re: FDMEE retrieving and storing global variable always returns no data
            SH_INT

            Just change your Put script as follows:

             

            ICPLeft = ""

            def ICPGetLeft (strfield, strrecord):

                strfields = strrecord.split(";")

                if strfields[0] == "Company:":

                    global ICPLeft

                    ICPLeft = strfields[4]

                return strfield

             

            ** Note: this assumes that the ICPLeft value is in the 5th field in the first line of the delimited file and your delimiter is a semi-colon **

            • 4. Re: FDMEE retrieving and storing global variable always returns no data
              3355552

              Hi @SH_INT I have tried this just now in my Get Script:

               

               

              ICPLeft = ""

              def ICPGetLeft (strField, strRecord):

                  strfields = strRecord.split(";")

                 

                  if strfields[0] == "Company:":

                      global ICPLeft  

                      ICPLeft = strfields[3]

                  #elif strRecord[0] == "Total" or strRecord [0:5] == "TOTAL" or strRecord == "":

                  #    fdmSkip

                  return strField

               

               

              because my ICP is on the 3 I put it in strfields 3 for the strfields.

              It still generates the same error logs though....

               

               

              2017-06-06 16:07:49,383 DEBUG [AIF]: EPMFDM-140275:Message - Script File encoding: UTF-8

              2017-06-06 16:07:49,383 DEBUG [AIF]: EPMFDM-140275:Message - ICPLeft = ""

              def ICPGetLeft (strField, strRecord):

                  strfields = strRecord.split(";")

                 

                  if strfields[0] == "Company:":

                      global ICPLeft  

                      ICPLeft = strfields[3]

                  #elif strRecord[0] == "Total" or strRecord [0:5] == "TOTAL" or strRecord == "":

                  #    fdmSkip

                  return strField

               

               

              2017-06-06 16:07:49,399 DEBUG [AIF]: EPMFDM-140274:Message - compiling script:ICPGetLeft(strField,strRecord)

              2017-06-06 16:07:49,399 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD5:ImpFieldText=null:StartPos=19:SourceClName=null

              2017-06-06 16:07:49,399 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=EFGH:StartPos=50:SourceClName=null

              2017-06-06 16:07:49,399 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=13:SourceClName=null

              2017-06-06 16:07:49,399 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ICP:ImpFieldText=Script=ICPPutLeft.py;:StartPos=51:SourceClName=null

              2017-06-06 16:07:49,399 DEBUG [AIF]: EPMFDM-140274:Message - Passing script file for execution to jython interpretor: \\SVCHGVA1-429\FDMEEData/data/scripts/import/ICPPutLeft.py

              2017-06-06 16:07:49,399 INFO  [AIF]: EPMFDM-140275:Message - Execute File: \\SVCHGVA1-429\FDMEEData/data/scripts/import/ICPPutLeft.py

              2017-06-06 16:07:49,399 DEBUG [AIF]: EPMFDM-140275:Message - LOG_LEVEL: 5

              2017-06-06 16:07:49,399 DEBUG [AIF]: EPMFDM-140275:Message - Script File encoding: UTF-8

              2017-06-06 16:07:49,399 DEBUG [AIF]: EPMFDM-140275:Message - def ICPPutLeft (strField, strRecord):

                  return ICPLeft

               

               

              2017-06-06 16:07:49,414 DEBUG [AIF]: EPMFDM-140274:Message - compiling script:ICPPutLeft(strField,strRecord)

              2017-06-06 16:07:49,414 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=-:StartPos=52:SourceClName=null

              2017-06-06 16:07:49,414 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=16:SourceClName=null

              2017-06-06 16:07:49,414 INFO  [AIF]: EPMFDM-140274:Message - File Name Master_ABCD_Partner_EFGH1.csv

              periodKey2017-06-30

              2017-06-06 16:07:49,414 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:[Company:;;;ABCD;;;;;;;;;Company:;;;EFGH;;;;;;;;;;;]

              2017-06-06 16:07:49,414 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying UD5 mapping on the row:[Company:;;;ABCD;;;;;;;;;Company:;;;EFGH;;;;;;;;;;;]

              2017-06-06 16:07:49,414 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying ENTITY mapping on the row:[Company:;;;ABCD;;;;;;;;;Company:;;;EFGH;;;;;;;;;;;]

              2017-06-06 16:07:49,414 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying ICP mapping on the row:[Company:;;;ABCD;;;;;;;;;Company:;;;EFGH;;;;;;;;;;;]

              2017-06-06 16:07:49,414 DEBUG [AIF]: EPMFDM-140274:Message - Error: nullcom.hyperion.aif.file.common.util.DataLoadEngine$ImportItemFileEntity.evaluateExpressions(DataLoadEngine.java:1072)

              com.hyperion.aif.file.common.util.DataLoadEngine.processFileRow(DataLoadEngine.java:842)

              com.hyperion.aif.file.common.util.DataLoadEngine.loadRow(DataLoadEngine.java:431)

              com.hyperion.aif.file.data.ImportTextData.performLoad(ImportTextData.java:456)

              sun.reflect.GeneratedMethodAccessor28862.invoke(Unknown Source)

              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              java.lang.reflect.Method.invoke(Method.java:597)

              org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:175)

              org.python.core.PyObject.__call__(PyObject.java:355)

              org.python.core.PyMethod.__call__(PyMethod.java:215)

              org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

              org.python.core.PyMethod.__call__(PyMethod.java:206)

              org.python.core.PyObject.__call__(PyObject.java:381)

              org.python.core.PyObject.__call__(PyObject.java:385)

              org.python.pycode._pyx2662.importData$2(<string>:119)

              org.python.pycode._pyx2662.call_function(<string>)

              org.python.core.PyTableCode.call(PyTableCode.java:165)

              org.python.core.PyBaseCode.call(PyBaseCode.java:297)

              org.python.core.PyBaseCode.call(PyBaseCode.java:191)

              org.python.core.PyFunction.__call__(PyFunction.java:385)

              org.python.core.PyMethod.__call__(PyMethod.java:215)

              org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

              org.python.core.PyMethod.__call__(PyMethod.java:206)

              org.python.core.PyObject.__call__(PyObject.java:432)

              org.python.core.PyObject.__call__(PyObject.java:436)

              org.python.pycode._pyx2665.f$0(<string>:5)

              org.python.pycode._pyx2665.call_function(<string>)

              org.python.core.PyTableCode.call(PyTableCode.java:165)

              org.python.core.PyCode.call(PyCode.java:18)

              org.python.core.Py.runCode(Py.java:1204)

              org.python.core.Py.exec(Py.java:1248)

              org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)

              org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)

              com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

              com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

              com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

              oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

              oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

              oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

              com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

              com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

              com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

              com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

              com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

              com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

              oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

              oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

              oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

              oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

              oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

              oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

              org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

              oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

              oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

              oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

              oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:79)

              oracle.odi.runtime.agent.invocation.support.InternalLocalRuntimeAgentInvoker.invoke(InternalLocalRuntimeAgentInvoker.java:49)

              oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:173)

              oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:140)

              com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:271)

              com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)

              com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)

              com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)

              oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)

              oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)

              oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

              com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

              com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

              com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

              com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

              com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

              com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

              oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

              oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

              oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

              oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

              oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

              oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

              org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

              oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

              oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

              oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

              oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

              oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:564)

              oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:518)

              • 5. Re: FDMEE retrieving and storing global variable always returns no data
                amith.madisetty

                ICPLeft = ""

                 

                def ICPGetLeft (strfield, strrecord):

                 

                    strfields = strrecord.split(";")

                 

                    if strfields[0] == "Company:":

                 

                        global ICPLeft

                 

                        ICPLeft = strfields[4]

                 

                    return strfield

                 

                You have strfield in ICPGetLeft and returning the same but should it not be ICPLeft ??

                 

                And u have strfield and strfields is it because of that ? Am not good at jython but guessing these.

                • 6. Re: FDMEE retrieving and storing global variable always returns no data
                  3355552

                  Hi Amith,

                   

                  ICPLeft is the variable and the ICPGetLeft is just the naming convention in the script. So that shall not be the case.

                   

                  strfields and strfield are also not the case. strfields in SH_INT code is to hold array value, and the strfield is to return the column just in case it does not fit in the "if" criteria.

                   

                  Tx.

                  • 7. Re: FDMEE retrieving and storing global variable always returns no data
                    amith.madisetty

                    Thanks for the clarification.

                     

                    But I assume that we are getting value into ICPLeft variable but why are we returning strfield ? Just to understand better.

                     

                    Thanks

                    Amith