10 Replies Latest reply on Feb 27, 2017 10:21 AM by Nishant Fukate

    EPMHFM-1057: The POV selected for this function is not valid ?

    Nishant Fukate

      Hello Experts

      We have various accounting entities in a source system and for loading data of those entities we are using Source Accounting Entity Group.

      When we are loading data from this group, it is getting failed at "Export Stage". Eventually Importing process is running well.

      In a log file, error statement and code is like: "EPMHFM-1057: The POV selected for this function is not valid".

      We are using Source System as EBS 12 and Target Application as HFM.

       

      Kindly assist what should be done in this case.

       

       

      Thanks

        • 2. Re: EPMHFM-1057: The POV selected for this function is not valid ?
          Francisco Amores

          can you attach the fdmee process log with level 5?

          • 3. Re: EPMHFM-1057: The POV selected for this function is not valid ?
            Nishant Fukate

            2016-12-28 00:14:40,185 INFO [AIF]: FDMEE Process: 7241, Log Level: 5, Log File: E:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\outbox\logs\UNICOMER_7241.log

            2016-12-28 00:14:40,185 INFO [AIF]: Location : CRP (Partitionkey:975)

            2016-12-28 00:14:40,185 INFO [AIF]: Period Name : MAR16 (Period Key:03-31-16 12:00 AM)

            2016-12-28 00:14:40,185 INFO [AIF]: Category Name: CORPORATE (Category key:3)

            2016-12-28 00:14:40,185 INFO [AIF]: Rule Name : CRP1 (Rule ID:2,663)

            2016-12-28 00:14:45,440 INFO [AIF]: FDM Version: 11.1.2.4.200

            2016-12-28 00:14:45,440 INFO [AIF]: Log File Encoding: UTF-8

            2016-12-28 00:14:47,673 INFO [AIF]: -------START IMPORT STEP-------

            2016-12-28 00:14:47,822 INFO [AIF]: -------END IMPORT STEP-------

            2016-12-28 00:14:47,939 INFO [AIF]: -------START EXPORT STEP-------

            2016-12-28 00:14:47,980 DEBUG [AIF]: CommData.exportData - START

            2016-12-28 00:14:47,986 DEBUG [AIF]: Comm.doScriptInit - START

            2016-12-28 00:14:48,086 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=E:\Oracle\Middleware\user_projects\epmsystem4\FinancialDataQuality, INBOXDIR=E:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\inbox, LOCNAME=CRP, SOURCENAME=EBS_12, APPID=71, SOURCEID=53, APPROOTDIR=E:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality, IMPORTFORMAT=CORPORATETB, SCRIPTSDIR=E:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\data\scripts, EPMORACLEHOME=E:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=2663, CATNAME=CORPORATE, EPMORACLEINSTANCEHOME=E:\Oracle\Middleware\user_projects\epmsystem4, LOADID=7241, PERIODNAME=MAR16, IMPORTMODE=null, SOURCETYPE=EBS_R12, PERIODKEY=2016-03-31, EXPORTFLAG=Y, TARGETAPPDB=null, TARGETAPPNAME=UNICOMER, LOCKEY=975, RULENAME=CRP1, OUTBOXDIR=E:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\outbox, MULTIPERIODLOAD=N, EXPORTMODE=Replace, CATKEY=3, USERNAME=admin, FILEDIR=null, IMPORTFLAG=N, USERLOCALE=null}

            2016-12-28 00:14:48,092 DEBUG [AIF]: The executeEventScript is set to: YES

            2016-12-28 00:14:48,092 DEBUG [AIF]: The AppRootFolder is set to: E:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality

            2016-12-28 00:14:48,092 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

            2016-12-28 00:14:48,092 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

            2016-12-28 00:14:48,092 DEBUG [AIF]: Comm.doScriptInit - END

            2016-12-28 00:14:48,092 DEBUG [AIF]: Comm.executeScript - START

            2016-12-28 00:14:48,093 DEBUG [AIF]: The following script does not exist: E:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality/data/scripts/event/BefExportToDat.py

            2016-12-28 00:14:48,096 DEBUG [AIF]: Comm.executeVBScript - START

            2016-12-28 00:14:48,096 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

            2016-12-28 00:14:48,097 DEBUG [AIF]: The following script does not exist: E:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\data\scripts\event\BefExportToDat.vbs

            2016-12-28 00:14:48,097 DEBUG [AIF]: Comm.executeVBScript - END

            2016-12-28 00:14:48,097 DEBUG [AIF]: Comm.executeScript - END

            2016-12-28 00:14:48,104 DEBUG [AIF]: CommData.getRuleInfo - START

            2016-12-28 00:14:48,111 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 = 71

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

              AND adim.BALANCE_COLUMN_NAME IS NOT NULL

              AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

              ORDER BY adim.BALANCE_COLUMN_NAME

              

            2016-12-28 00:14:48,144 DEBUG [AIF]: {'APPLICATION_ID': 71L, 'IMPORT_FROM_SOURCE_FLAG': u'N', 'PLAN_TYPE': None, 'RULE_NAME': u'CRP1', 'ACTUAL_FLAG': u'A', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'E:\\Oracle\\Middleware\\user_projects\\epmsystem4', 'CATKEY': 3L, 'BAL_SEG_VALUE_OPTION_CODE': u'ALL', 'INCLUDE_ADJ_PERIODS_FLAG': u'Y', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'EBS_R12', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'UNICOMER', 'RECALCULATE_FLAG': u'N', 'SOURCE_SYSTEM_ID': 53L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': u'BOTH', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': u'2065', 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5', u'UD6'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 101L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD6': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': u'SEGMENT6', 'DIMNAME': u'UD6', 'DIMENSION_ID': 758L}, u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': u'SEGMENT5', 'DIMNAME': u'UD3', 'DIMENSION_ID': 756L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME1': u'SEGMENT8', 'DIMNAME': u'ICP', 'DIMENSION_ID': 762L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME1': u'SEGMENT1', 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 755L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': u'SEGMENT4', 'DIMNAME': u'UD2', 'DIMENSION_ID': 759L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 760L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': u'SEGMENT7', 'DIMNAME': u'UD4', 'DIMENSION_ID': 761L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME1': u'SEGMENT6', 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 753L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': u'SEGMENT2', 'DIMNAME': u'UD1', 'DIMENSION_ID': 757L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 975L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'MULTI', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': None, 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'ERPI', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 2663L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': u'STANDARD', 'SIGNAGE_METHOD': u'SAME', 'WEB_SERVICE_URL': u'http://mlddcsvhpfdm-vm:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 71L, 'IMPTARGETSOURCESYSTEMID': 0L}

            2016-12-28 00:14:48,144 DEBUG [AIF]: CommData.getRuleInfo - END

            2016-12-28 00:14:48,167 DEBUG [AIF]: CommData.insertPeriods - START

            2016-12-28 00:14:48,169 DEBUG [AIF]: CommData.getLedgerListAndMap - START

            2016-12-28 00:14:48,171 DEBUG [AIF]: CommData.getLedgerSQL - START

            2016-12-28 00:14:48,171 DEBUG [AIF]: CommData.getLedgerSQL - END

            2016-12-28 00:14:48,171 DEBUG [AIF]:

              SELECT l.SOURCE_LEDGER_ID, l.SOURCE_LEDGER_NAME, l.SOURCE_COA_ID, l.CALENDAR_ID, '0' SETID, l.PERIOD_TYPE, NULL LEDGER_TABLE_NAME

              FROM AIF_BALANCE_RULES br

              ,AIF_LEDGER_GROUP_LEDGERS lgl

              ,AIF_COA_LEDGERS l

              WHERE br.RULE_ID = 2663

              AND lgl.LEDGER_GROUP_ID = br.LEDGER_GROUP_ID

              AND l.SOURCE_SYSTEM_ID = lgl.SOURCE_SYSTEM_ID

              AND l.SOURCE_LEDGER_ID = lgl.SOURCE_LEDGER_ID

              

            2016-12-28 00:14:48,194 DEBUG [AIF]: CommData.getLedgerListAndMap - END

            2016-12-28 00:14:48,198 DEBUG [AIF]: doAppPeriodMappingsExist - UNICOMER: Y

            2016-12-28 00:14:48,198 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,198 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,198 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,198 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,198 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,198 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,199 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,199 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,199 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,199 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,199 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,199 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,199 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,199 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,200 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,200 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,200 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,200 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,200 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,200 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,200 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,200 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,200 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,200 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,201 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,201 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,201 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,201 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,201 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,201 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,201 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,201 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,201 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,201 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,202 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,202 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,202 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,202 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,202 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,202 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,202 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,202 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,202 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,202 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,202 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,203 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,203 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,203 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,203 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,203 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,203 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

            2016-12-28 00:14:48,204 DEBUG [AIF]:

              INSERT INTO AIF_PROCESS_PERIODS (

              PROCESS_ID

              ,PERIODKEY

              ,PERIOD_ID

              ,ADJUSTMENT_PERIOD_FLAG

              ,GL_PERIOD_YEAR

              ,GL_PERIOD_NUM

              ,GL_PERIOD_NAME

              ,GL_PERIOD_CODE

              ,GL_EFFECTIVE_PERIOD_NUM

              ,YEARTARGET

              ,PERIODTARGET

              ,IMP_ENTITY_TYPE

              ,IMP_ENTITY_ID

              ,IMP_ENTITY_NAME

              ,TRANS_ENTITY_TYPE

              ,TRANS_ENTITY_ID

              ,TRANS_ENTITY_NAME

              ,PRIOR_PERIOD_FLAG

              ,SOURCE_LEDGER_ID

              )

              SELECT DISTINCT brl.LOADID PROCESS_ID

              ,pp.PERIODKEY PERIODKEY

              ,prd.PERIOD_ID

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

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

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

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

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

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

              ,pp.YEARTARGET YEARTARGET

              ,pp.PERIODTARGET PERIODTARGET

              ,'PROCESS_BAL_IMP' IMP_ENTITY_TYPE

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

              ,'EC_CORPORATE'||': '||COALESCE(prd.PERIOD_NAME, ppsrc.GL_PERIOD_NAME,'0') IMP_ENTITY_NAME

              ,'PROCESS_BAL_TRANS' TRANS_ENTITY_TYPE

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

              ,pp.PERIODDESC TRANS_ENTITY_NAME

              ,'N' PRIOR_PERIOD_FLAG

              ,2071 SOURCE_LEDGER_ID

              FROM (

              AIF_BAL_RULE_LOADS brl

              INNER JOIN TPOVCATEGORY pc

              ON pc.CATKEY = brl.CATKEY

              

              INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp

              ON pp.PERIODFREQ = pc.CATFREQ

              AND pp.PERIODKEY >= brl.START_PERIODKEY

              AND pp.PERIODKEY <= brl.END_PERIODKEY

              AND pp.INTSYSTEMKEY = 'UNICOMER'

              )

              INNER JOIN TPOVPERIODSOURCE ppsrc

              ON ppsrc.PERIODKEY = pp.PERIODKEY

              AND ppsrc.MAPPING_TYPE = 'EXPLICIT'

              AND ppsrc.SOURCE_SYSTEM_ID = 53

              AND ppsrc.CALENDAR_ID IN ('11000')

              LEFT OUTER JOIN AIF_GL_PERIODS_STG prd

              ON prd.PERIOD_ID = ppsrc.PERIOD_ID

              AND prd.SOURCE_SYSTEM_ID = ppsrc.SOURCE_SYSTEM_ID

              AND prd.CALENDAR_ID = ppsrc.CALENDAR_ID

              

              AND prd.SETID = '0'

              AND prd.PERIOD_TYPE = '21'

              

              AND prd.ADJUSTMENT_PERIOD_FLAG = 'N'

              WHERE brl.LOADID = 7241

              ORDER BY pp.PERIODKEY

              ,GL_EFFECTIVE_PERIOD_NUM

              

            2016-12-28 00:14:48,204 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'EC_CORPORATE', 'PROCESS_BAL_TRANS', 2071L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,233 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,233 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'VG_RWT CORPORATE', 'PROCESS_BAL_TRANS', 2286L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,237 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,237 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'PA_CORPORATE', 'PROCESS_BAL_TRANS', 2411L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,239 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,239 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'HN_CORPORATE', 'PROCESS_BAL_TRANS', 2023L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,241 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,241 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'VG_CCH CORPORATE', 'PROCESS_BAL_TRANS', 2109L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,243 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,243 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'BM_CANT CORPORATE', 'PROCESS_BAL_TRANS', 2242L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,245 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,245 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'NI_CORPORATE', 'PROCESS_BAL_TRANS', 2058L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,247 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,247 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'BVI_ULA CORPORATE', 'PROCESS_BAL_TRANS', 2037L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,249 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,249 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'TT_RI CORPORATE', 'PROCESS_BAL_TRANS', 2168L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,251 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,251 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'VC_CORPORATE', 'PROCESS_BAL_TRANS', 2272L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,253 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,253 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'TT_CORPORATE', 'PROCESS_BAL_TRANS', 2222L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,255 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,255 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'CR_RI CORPORATE', 'PROCESS_BAL_TRANS', 2082L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,257 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,257 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'XXXXXXX', 'PROCESS_BAL_TRANS', 2353L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,259 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,259 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'AW_CORPORATE', 'PROCESS_BAL_TRANS', 2261L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,261 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,261 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'LC_CORPORATE', 'PROCESS_BAL_TRANS', 2213L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,263 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,263 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'HN_RI CORPORATE', 'PROCESS_BAL_TRANS', 2226L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,265 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,265 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'DM_CORPORATE', 'PROCESS_BAL_TRANS', 2193L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,267 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,267 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'BZ_RI CORPORATE', 'PROCESS_BAL_TRANS', 2246L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,269 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,269 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'CR_CORPORATE', 'PROCESS_BAL_TRANS', 2031L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,271 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,271 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'TC_CORPORATE', 'PROCESS_BAL_TRANS', 2187L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,273 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,273 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'GD_CORPORATE', 'PROCESS_BAL_TRANS', 2217L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,275 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,275 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'BVI_ RFH CORPORATE', 'PROCESS_BAL_TRANS', 2035L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,277 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,277 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'LC_COH CORPORATE', 'PROCESS_BAL_TRANS', 2208L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,279 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,279 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'DO_CORPORATE', 'PROCESS_BAL_TRANS', 2278L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,281 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,281 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'JM_CORPORATE', 'PROCESS_BAL_TRANS', 2256L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,283 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,283 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'SV_CORPORATE', 'PROCESS_BAL_TRANS', 2049L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,285 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,285 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'BA_CORPORATE', 'PROCESS_BAL_TRANS', 2021L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,287 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,287 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'SV_INVA_CRED CORPORATE', 'PROCESS_BAL_TRANS', 2237L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,289 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,289 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'US_CORPORATE', 'PROCESS_BAL_TRANS', 2260L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,291 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,291 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'SV_UC_CORPORATE', 'PROCESS_BAL_TRANS', 2351L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,293 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,293 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'KN_CORPORATE', 'PROCESS_BAL_TRANS', 2167L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,295 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,295 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'TT_UCL CORPORATE', 'PROCESS_BAL_TRANS', 2231L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,297 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,297 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'PY_CORPORATE', 'PROCESS_BAL_TRANS', 2374L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,299 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,299 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'GT_CORPORATE', 'PROCESS_BAL_TRANS', 2078L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,301 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,301 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'AW_UNIV CORPORATE', 'PROCESS_BAL_TRANS', 2282L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,303 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,303 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'BB_CORPORATE', 'PROCESS_BAL_TRANS', 2196L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,305 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,305 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'US_RWT CORPORATE', 'PROCESS_BAL_TRANS', 2247L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,307 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,307 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'GY_CORPORATE', 'PROCESS_BAL_TRANS', 2252L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,309 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,309 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'BVI_FOH CORPORATE', 'PROCESS_BAL_TRANS', 2028L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,311 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,311 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'BB_CLC CORPORATE', 'PROCESS_BAL_TRANS', 2311L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,313 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,313 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'GY_RI CORPORATE', 'PROCESS_BAL_TRANS', 2086L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,315 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,315 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'LC_RI CORPORATE', 'PROCESS_BAL_TRANS', 2128L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,317 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,317 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'AG_CORPORATE', 'PROCESS_BAL_TRANS', 2065L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,319 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,319 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'BB_CXXXX', 'PROCESS_BAL_TRANS', 2203L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,321 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,321 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'PA_GFC CORPORATE', 'PROCESS_BAL_TRANS', 2240L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,323 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,323 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'BZ_CORPORATE', 'PROCESS_BAL_TRANS', 2228L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,325 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,325 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'VG_RI CORPORATE', 'PROCESS_BAL_TRANS', 2244L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,328 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,328 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'GT_CET CORPORATE', 'PROCESS_BAL_TRANS', 2063L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,330 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,330 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'PA_SAM CORPORATE', 'PROCESS_BAL_TRANS', 2041L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,332 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,332 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'CW_CORPORATE', 'PROCESS_BAL_TRANS', 2471L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,333 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,334 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', u'AW_CORPORATE 1', 'PROCESS_BAL_TRANS', 2431L, u'UNICOMER', u'EXPLICIT', 53L, u'11000', u'0', u'21', 'N', 7241]

            2016-12-28 00:14:48,335 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,336 DEBUG [AIF]:

              INSERT INTO AIF_PROCESS_PERIODS (

              PROCESS_ID

              ,PERIODKEY

              ,PERIOD_ID

              ,ADJUSTMENT_PERIOD_FLAG

              ,GL_PERIOD_YEAR

              ,GL_PERIOD_NUM

              ,GL_PERIOD_NAME

              ,GL_PERIOD_CODE

              ,GL_EFFECTIVE_PERIOD_NUM

              ,YEARTARGET

              ,PERIODTARGET

              ,IMP_ENTITY_TYPE

              ,IMP_ENTITY_ID

              ,IMP_ENTITY_NAME

              ,TRANS_ENTITY_TYPE

              ,TRANS_ENTITY_ID

              ,TRANS_ENTITY_NAME

              ,PRIOR_PERIOD_FLAG

              ,SOURCE_LEDGER_ID

              )

              SELECT DISTINCT brl.LOADID PROCESS_ID

              ,pp.PERIODKEY PERIODKEY

              ,prd.PERIOD_ID

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

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

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

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

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

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

              ,pp.YEARTARGET YEARTARGET

              ,pp.PERIODTARGET PERIODTARGET

              ,'PROCESS_BAL_IMP' IMP_ENTITY_TYPE

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

              ,'EC_CORPORATE'||': '||COALESCE(prd.PERIOD_NAME, ppsrc.GL_PERIOD_NAME,'0') IMP_ENTITY_NAME

              ,'PROCESS_BAL_TRANS' TRANS_ENTITY_TYPE

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

              ,pp.PERIODDESC TRANS_ENTITY_NAME

              ,'N' PRIOR_PERIOD_FLAG

              ,2071 SOURCE_LEDGER_ID

              FROM (

              AIF_BAL_RULE_LOADS brl

              INNER JOIN TPOVCATEGORY pc

              ON pc.CATKEY = brl.CATKEY

              

              INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp

              ON pp.PERIODFREQ = pc.CATFREQ

              AND pp.PERIODKEY >= brl.START_PERIODKEY

              AND pp.PERIODKEY <= brl.END_PERIODKEY

              AND pp.INTSYSTEMKEY = 'UNICOMER'

              )

              INNER JOIN TPOVPERIODSOURCE ppsrc

              ON ppsrc.PERIODKEY = pp.PERIODKEY

              AND ppsrc.MAPPING_TYPE = 'ADJUSTMENT'

              AND ppsrc.SOURCE_SYSTEM_ID = 53

              AND ppsrc.CALENDAR_ID IN ('11000')

              LEFT OUTER JOIN AIF_GL_PERIODS_STG prd

              ON prd.PERIOD_ID = ppsrc.PERIOD_ID

              AND prd.SOURCE_SYSTEM_ID = ppsrc.SOURCE_SYSTEM_ID

              AND prd.CALENDAR_ID = ppsrc.CALENDAR_ID

              

              AND prd.SETID = '0'

              AND prd.PERIOD_TYPE = '21'

              

              AND prd.ADJUSTMENT_PERIOD_FLAG = 'Y'

              WHERE brl.LOADID = 7241

              ORDER BY pp.PERIODKEY

              ,GL_EFFECTIVE_PERIOD_NUM

              

            2016-12-28 00:14:48,336 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'EC_CORPORATE', 'PROCESS_BAL_TRANS', 2071L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,338 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,338 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'VG_RWT CORPORATE', 'PROCESS_BAL_TRANS', 2286L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,339 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,340 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'PA_CORPORATE', 'PROCESS_BAL_TRANS', 2411L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,341 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,341 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'HN_CORPORATE', 'PROCESS_BAL_TRANS', 2023L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,342 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,342 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'VG_CCH CORPORATE', 'PROCESS_BAL_TRANS', 2109L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,343 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,343 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'BM_CANT CORPORATE', 'PROCESS_BAL_TRANS', 2242L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,345 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,345 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'NI_CORPORATE', 'PROCESS_BAL_TRANS', 2058L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,346 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,347 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'BVI_ULA CORPORATE', 'PROCESS_BAL_TRANS', 2037L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,348 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,348 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'TT_RI CORPORATE', 'PROCESS_BAL_TRANS', 2168L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,349 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,349 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'VC_CORPORATE', 'PROCESS_BAL_TRANS', 2272L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,350 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,350 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'TT_CORPORATE', 'PROCESS_BAL_TRANS', 2222L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,352 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,352 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'CR_RI CORPORATE', 'PROCESS_BAL_TRANS', 2082L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,353 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,353 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'XXXXXXX', 'PROCESS_BAL_TRANS', 2353L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,354 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,354 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'AW_CORPORATE', 'PROCESS_BAL_TRANS', 2261L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,355 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,356 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'LC_CORPORATE', 'PROCESS_BAL_TRANS', 2213L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,357 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,357 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'HN_RI CORPORATE', 'PROCESS_BAL_TRANS', 2226L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,358 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,359 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'DM_CORPORATE', 'PROCESS_BAL_TRANS', 2193L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,360 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,360 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'BZ_RI CORPORATE', 'PROCESS_BAL_TRANS', 2246L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,361 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,361 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'CR_CORPORATE', 'PROCESS_BAL_TRANS', 2031L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,362 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,362 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'TC_CORPORATE', 'PROCESS_BAL_TRANS', 2187L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,364 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,364 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'GD_CORPORATE', 'PROCESS_BAL_TRANS', 2217L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,365 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,365 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'BVI_ RFH CORPORATE', 'PROCESS_BAL_TRANS', 2035L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,366 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,366 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'LC_COH CORPORATE', 'PROCESS_BAL_TRANS', 2208L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,368 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,368 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'DO_CORPORATE', 'PROCESS_BAL_TRANS', 2278L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,369 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,369 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'JM_CORPORATE', 'PROCESS_BAL_TRANS', 2256L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,370 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,370 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'SV_CORPORATE', 'PROCESS_BAL_TRANS', 2049L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,371 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,372 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'BA_CORPORATE', 'PROCESS_BAL_TRANS', 2021L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,373 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,373 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'SV_INVA_CRED CORPORATE', 'PROCESS_BAL_TRANS', 2237L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,374 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,374 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'US_CORPORATE', 'PROCESS_BAL_TRANS', 2260L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,375 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,375 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'SV_UC_CORPORATE', 'PROCESS_BAL_TRANS', 2351L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,376 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,377 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'KN_CORPORATE', 'PROCESS_BAL_TRANS', 2167L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,378 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,378 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'TT_UCL CORPORATE', 'PROCESS_BAL_TRANS', 2231L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,379 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,379 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'PY_CORPORATE', 'PROCESS_BAL_TRANS', 2374L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,380 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,380 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'GT_CORPORATE', 'PROCESS_BAL_TRANS', 2078L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,382 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,382 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'AW_UNIV CORPORATE', 'PROCESS_BAL_TRANS', 2282L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,383 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,383 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'BB_CORPORATE', 'PROCESS_BAL_TRANS', 2196L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,384 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,384 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'US_RWT CORPORATE', 'PROCESS_BAL_TRANS', 2247L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,386 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,386 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'GY_CORPORATE', 'PROCESS_BAL_TRANS', 2252L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,387 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,387 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'BVI_FOH CORPORATE', 'PROCESS_BAL_TRANS', 2028L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,388 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,389 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'BB_CLC CORPORATE', 'PROCESS_BAL_TRANS', 2311L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,390 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,390 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'GY_RI CORPORATE', 'PROCESS_BAL_TRANS', 2086L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,391 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,391 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'LC_RI CORPORATE', 'PROCESS_BAL_TRANS', 2128L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,393 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,393 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'AG_CORPORATE', 'PROCESS_BAL_TRANS', 2065L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,394 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,394 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'BB_CXXXX', 'PROCESS_BAL_TRANS', 2203L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,395 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,395 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'PA_GFC CORPORATE', 'PROCESS_BAL_TRANS', 2240L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,396 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,397 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'BZ_CORPORATE', 'PROCESS_BAL_TRANS', 2228L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,398 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,398 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'VG_RI CORPORATE', 'PROCESS_BAL_TRANS', 2244L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,399 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,399 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'GT_CET CORPORATE', 'PROCESS_BAL_TRANS', 2063L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,401 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,401 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'PA_SAM CORPORATE', 'PROCESS_BAL_TRANS', 2041L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,402 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,402 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'CW_CORPORATE', 'PROCESS_BAL_TRANS', 2471L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,404 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,404 DEBUG [AIF]: periodSQL - periodParams: ['Y', 'PROCESS_BAL_IMP', u'AW_CORPORATE 1', 'PROCESS_BAL_TRANS', 2431L, u'UNICOMER', 'ADJUSTMENT', 53L, u'11000', u'0', u'21', 'Y', 7241]

            2016-12-28 00:14:48,405 DEBUG [AIF]: insertRowCount: 1

            2016-12-28 00:14:48,412 DEBUG [AIF]: CommData.insertPeriods - END

            2016-12-28 00:14:48,417 DEBUG [AIF]: CommData.moveData - START

            2016-12-28 00:14:48,420 DEBUG [AIF]: CommData.getPovList - START

            2016-12-28 00:14:48,421 DEBUG [AIF]:

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

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

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

              FROM AIF_BAL_RULE_LOADS brl

              INNER JOIN AIF_BALANCE_RULES br

              ON br.RULE_ID = brl.RULE_ID

              INNER JOIN TPOVPARTITION part

              ON part.PARTITIONKEY = brl.PARTITIONKEY

              INNER JOIN TPOVCATEGORY cat

              ON cat.CATKEY = brl.CATKEY

              INNER JOIN AIF_PROCESS_PERIODS pprd

              ON pprd.PROCESS_ID = brl.LOADID

              LEFT OUTER JOIN TPOVPERIODADAPTOR pp

              ON pp.PERIODKEY = pprd.PERIODKEY AND pp.INTSYSTEMKEY = 'UNICOMER'

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

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

              

            2016-12-28 00:14:48,426 DEBUG [AIF]: CommData.getPovList - END

            2016-12-28 00:14:48,428 INFO [AIF]:

            Move Data for Period 'MAR16'

            2016-12-28 00:14:48,428 DEBUG [AIF]:

              UPDATE TDATASEG

              SET LOADID = 7241

              WHERE PARTITIONKEY = 975

              AND CATKEY = 3

              AND RULE_ID = 2663

              AND LOADID < 7241

              

              AND PERIODKEY = '2016-03-31'

            2016-12-28 00:14:53,352 DEBUG [AIF]: Number of Rows updated on TDATASEG: 179755

            2016-12-28 00:14:53,352 DEBUG [AIF]:

              INSERT INTO AIF_APPL_LOAD_AUDIT (

              LOADID, TARGET_APPLICATION_TYPE, TARGET_APPLICATION_NAME, PLAN_TYPE, SOURCE_LEDGER_ID, EPM_YEAR, EPM_PERIOD,

              SNAPSHOT_FLAG, SEGMENT_FILTER_FLAG, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY, EXPORT_TO_TARGET_FLAG

              )

              SELECT DISTINCT

              7241, TARGET_APPLICATION_TYPE, TARGET_APPLICATION_NAME, PLAN_TYPE, SOURCE_LEDGER_ID, EPM_YEAR, EPM_PERIOD,

              SNAPSHOT_FLAG, SEGMENT_FILTER_FLAG, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY, 'Y'

              FROM AIF_APPL_LOAD_AUDIT

              WHERE PARTITIONKEY = 975 AND CATKEY = 3 AND RULE_ID = 2663 AND LOADID < 7241

              

              AND PERIODKEY = '2016-03-31'

            2016-12-28 00:14:53,373 DEBUG [AIF]: Number of Rows inserted into AIF_APPL_LOAD_AUDIT: 48

            2016-12-28 00:14:53,373 DEBUG [AIF]:

              INSERT INTO AIF_APPL_LOAD_PRD_AUDIT (

              LOADID, SOURCE_LEDGER_ID, GL_PERIOD_ID, GL_PERIOD_YEAR, DELTA_RUN_ID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

              )

              SELECT DISTINCT

              7241, SOURCE_LEDGER_ID, GL_PERIOD_ID, GL_PERIOD_YEAR, DELTA_RUN_ID, PARTITIONKEY, CATKEY, RULE_ID, PERIODKEY

              FROM AIF_APPL_LOAD_PRD_AUDIT

              WHERE PARTITIONKEY = 975 AND CATKEY = 3 AND RULE_ID = 2663 AND LOADID < 7241

              

              AND PERIODKEY = '2016-03-31'

            2016-12-28 00:14:53,416 DEBUG [AIF]: Number of Rows inserted into AIF_APPL_LOAD_PRD_AUDIT: 96

            2016-12-28 00:14:53,429 DEBUG [AIF]: CommData.moveData - END

            2016-12-28 00:14:53,441 DEBUG [AIF]: CommData.updateWorkflow - START

            2016-12-28 00:14:53,441 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 = 975 AND tlp.CATKEY = 3 AND tlp.PERIODKEY = '2016-03-31' AND tlp.RULE_ID = 2663 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

              

            2016-12-28 00:14:53,476 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME=CURRENT_TIMESTAMP

              ,PROCESSSTATUS=20,PROCESSEXP=0,PROCESSENTLOAD=0,PROCESSENTVAL=0

              ,PROCESSEXPNOTE=NULL,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL

              WHERE PARTITIONKEY=975 AND CATKEY=3 AND PERIODKEY='2016-03-31' AND RULE_ID=2663

              

            2016-12-28 00:14:53,485 DEBUG [AIF]: CommData.updateWorkflow - END

            2016-12-28 00:14:53,487 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - START

            2016-12-28 00:14:53,489 DEBUG [AIF]:

              DELETE FROM TDATASEG

              WHERE LOADID = 7241

              

              AND (

              

              PARTITIONKEY = 975

              AND CATKEY = 3

              AND PERIODKEY = '2016-03-31'

              AND RULE_ID = 2663

              AND VALID_FLAG = 'N'

              

              )

            2016-12-28 00:14:53,733 DEBUG [AIF]: Number of Rows deleted from TDATASEG: 0

            2016-12-28 00:14:53,733 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - END

            2016-12-28 00:14:53,735 DEBUG [AIF]: CommData.updateAppLoadAudit - START

            2016-12-28 00:14:53,735 DEBUG [AIF]:

              UPDATE AIF_APPL_LOAD_AUDIT

              SET EXPORT_TO_TARGET_FLAG = 'Y'

              WHERE LOADID = 7241

              AND PARTITIONKEY = 975

              AND CATKEY = 3

              AND PERIODKEY= '2016-03-31'

              AND RULE_ID = 2663

              

            2016-12-28 00:14:53,748 DEBUG [AIF]: Number of Rows updated on AIF_APPL_LOAD_AUDIT: 48

            2016-12-28 00:14:53,748 DEBUG [AIF]: CommData.updateAppLoadAudit - END

            2016-12-28 00:14:53,749 DEBUG [AIF]: CommData.updateWorkflow - START

            2016-12-28 00:14:53,749 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME=CURRENT_TIMESTAMP

              ,PROCESSSTATUS=21,PROCESSEXP=1

              ,PROCESSEXPNOTE='AIF_WF_EXP_EXPORT_OK_TXT'

              WHERE PARTITIONKEY=975 AND CATKEY=3 AND PERIODKEY='2016-03-31' AND RULE_ID=2663

              

            2016-12-28 00:14:53,754 DEBUG [AIF]: CommData.updateWorkflow - END

            2016-12-28 00:14:53,756 DEBUG [AIF]: Comm.executeJythonScript - START

            2016-12-28 00:14:53,757 INFO [AIF]: Executing the following script: E:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_EXPORT.py

            2016-12-28 00:14:53,854 DEBUG [AIF]: ************************************************************************************

            2016-12-28 00:14:53,854 DEBUG [AIF]: * HFM_EXPORT.py Started for LoadID: 7241

            2016-12-28 00:14:53,854 DEBUG [AIF]: ************************************************************************************

            2016-12-28 00:14:53,877 DEBUG [AIF]: User Locale is not set. Defaulting to: en_US

            2016-12-28 00:15:36,054 INFO [AIF]: Cluster name: mlddcsvhphfm-vm

            2016-12-28 00:15:36,084 DEBUG [AIF]: Global User ID:

            2016-12-28 00:16:39,347 DEBUG [AIF]: Session ID = 0f08bba6-9ffb-43a4-b912-304ad19b46da

            2016-12-28 00:16:39,357 DEBUG [AIF]: Connected to: UNICOMER

            2016-12-28 00:16:39,366 DEBUG [AIF]: ***Export data and Journals as data***

            2016-12-28 00:17:03,704 DEBUG [AIF]: Data Protection is on.

            2016-12-28 00:17:06,794 DEBUG [AIF]: Slice String : S#CORPORATE.Y#2015.P#MAR.W#Periodic;YTD.V#<Entity Currency>.E#1001;1002;1003;1004;1005;1201;1202;1203;1301;1302;1401;1402;1501;1502;1503;1504;1505;1506;1601;1602;1603;1701;1702;1801;1802;1803;1804;1805;2401;2402;2501;2502;2601;3701;3801;4001;4002;4003;4004;4005;4006;4101;4201;4301;4401;4501;4601;4602;4605;4606;4701;4801;4802;4901;4902;5001;5002;5004;5101;5107;5108;5109;5110;5111;5112;5201;5301;5401.A#{[Base]}.I#{[Base]}.LOB#{[Base]}.PC#{[Base]}.CC#{[Base]}.SA#{[Base]}.RP#{[Base]}.MV#{[Base]}

            2016-12-28 00:17:06,809 ERROR [AIF]: Error while extracting data

            2016-12-28 00:17:06,809 ERROR [AIF]: EPMHFM-1057: El POV seleccionado para esta función no es válido.

            2016-12-28 00:17:06,809 ERROR [AIF]: java.lang.Exception: Error while extracting data

            2016-12-28 00:17:06,940 ERROR [AIF]: The script has failed to execute:

            2016-12-28 00:17:06,942 FATAL [AIF]: Error in Comm.executeJythonScript

            Traceback (most recent call last):

              File "<string>", line 528, in executeJythonScript

              File "E:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_EXPORT.py", line 799, in <module>

              raise Exception("An error occurred during the Export.")

            Exception: An error occurred during the Export.

             

            2016-12-28 00:17:06,943 FATAL [AIF]: Error in CommData.exportData

            Traceback (most recent call last):

              File "<string>", line 4624, in exportData

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

              File "<string>", line 528, in executeJythonScript

              File "E:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_EXPORT.py", line 799, in <module>

              raise Exception("An error occurred during the Export.")

            Exception: An error occurred during the Export.

             

            2016-12-28 00:17:06,943 DEBUG [AIF]: CommData.updateWorkflow - START

            2016-12-28 00:17:06,943 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME=CURRENT_TIMESTAMP

              ,PROCESSSTATUS=22,PROCESSEXP=0

              ,PROCESSEXPNOTE='AIF_WF_EXP_EXPORT_ERR'

              WHERE PARTITIONKEY=975 AND CATKEY=3 AND PERIODKEY='2016-03-31' AND RULE_ID=2663

              

            2016-12-28 00:17:06,946 DEBUG [AIF]: CommData.updateWorkflow - END

            2016-12-28 00:17:06,946 DEBUG [AIF]: Comm.executeScript - START

            2016-12-28 00:17:06,946 DEBUG [AIF]: The following script does not exist: E:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality/data/scripts/event/AftExportToDat.py

            2016-12-28 00:17:06,947 DEBUG [AIF]: Comm.executeVBScript - START

            2016-12-28 00:17:06,947 DEBUG [AIF]: The following script does not exist: E:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\data\scripts\event\AftExportToDat.vbs

            2016-12-28 00:17:06,947 DEBUG [AIF]: Comm.executeVBScript - END

            2016-12-28 00:17:06,947 DEBUG [AIF]: Comm.executeScript - END

            2016-12-28 00:17:07,104 DEBUG [AIF]: Comm.finalizeProcess - START

            2016-12-28 00:17:07,105 DEBUG [AIF]: CommData.updateRuleStatus - START

            2016-12-28 00:17:07,105 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 = 7241 AND pd.STATUS IN ('FAILED','WARNING') )

              WHEN 0 THEN 'SUCCESS'

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

              ELSE 'FAILED' END

              WHERE RULE_ID = 2663

              

            2016-12-28 00:17:07,125 DEBUG [AIF]: CommData.updateRuleStatus - END

            2016-12-28 00:17:07,125 FATAL [AIF]: Error in COMM Export Data

            2016-12-28 00:17:07,127 DEBUG [AIF]: Comm.updateProcess - START

            2016-12-28 00:17:07,136 DEBUG [AIF]: Comm.updateProcess - END

            2016-12-28 00:17:07,138 DEBUG [AIF]: The fdmAPI connection has been closed.

            2016-12-28 00:17:07,139 INFO [AIF]: FDMEE Process End, Process ID: 7241

            • 4. Re: EPMHFM-1057: The POV selected for this function is not valid ?
              3239022

              Hi All,

               

              We are also facing similar kind of issues in HFM-11.1.2.4.203 version

               

              We have tested it,the issue is with [hierachy] function in POV.

               

              Back end Log:The POV selected for this function is invalid. [[Member lists are no longer supported, Please select individual members.]

               

              Please test from your end,so far the issue is still there,we have raised an Oracle SR.

              • 5. Re: EPMHFM-1057: The POV selected for this function is not valid ?
                Francisco Amores

                are all members in this slice correct?

                 

                S#CORPORATE.Y#2015.P#MAR.W#Periodic;YTD.V#<Entity Currency>.E#1001;1002;1003;1004;1005;1201;1202;1203;1301;1302;1401;1402;1501;1502;1503;1504;1505;1506;1601;1602;1603;1701;1702;1801;1802;1803;1804;1805;2401;2402;2501;2502;2601;3701;3801;4001;4002;4003;4004;4005;4006;4101;4201;4301;4401;4501;4601;4602;4605;4606;4701;4801;4802;4901;4902;5001;5002;5004;5101;5107;5108;5109;5110;5111;5112;5201;5301;5401.A#{[Base]}.I#{[Base]}.LOB#{[Base]}.PC#{[Base]}.CC#{[Base]}.SA#{[Base]}.RP#{[Base]}.MV#{[Base]}

                • 6. Re: EPMHFM-1057: The POV selected for this function is not valid ?
                  Francisco Amores

                  can i see your data load rule configuration for source filters?

                  • 10. Re: EPMHFM-1057: The POV selected for this function is not valid ?
                    Nishant Fukate

                    Hello All,

                     

                    Its been resolved. Source Filters were not properly defined.

                     

                    Please find the doc for detailed solution:

                    " FDMEE EPM Data Sync failed with Error: The POV selected for this function is invalid ( Doc ID 2027164.1 )"

                     

                    https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=190368064098221&parent=SrDetailText&sourceId=3-14235838181&id=2027164.1&_afrWindowMode=0&_adf.ctrl-state=1n2zyytko_520

                     

                    Thanks

                    Nishant