Hi ,
I am facing the issue while loading the data from oracle ebs to hfm application ,
import successful but validation error.. Below is the log file ...
Error in COMM Validate Data,
Error: ActiveX component can't create object:,
ERROR [AIF]: The script has failed to execute:
2014-07-03 21:00:09,897 INFO [AIF]: FDMEE Process Start, Process ID: 339
2014-07-03 21:00:09,898 INFO [AIF]: FDMEE Logging Level: 5
2014-07-03 21:00:09,898 INFO [AIF]: FDMEE Log File: C:\Oracle\FDMEE\outbox\logs\POC9_339.log
2014-07-03 21:00:09,898 INFO [AIF]: User:admin
2014-07-03 21:00:09,898 INFO [AIF]: Location:POC9_LOC (Partitionkey:22)
2014-07-03 21:00:09,898 INFO [AIF]: Period Name:Aug-13 (Period Key:8/31/13 12:00 AM)
2014-07-03 21:00:09,898 INFO [AIF]: Category Name:ACTUALS (Category key:7)
2014-07-03 21:00:09,898 INFO [AIF]: Rule Name:POC9_DLR (Rule ID:34)
2014-07-03 21:00:10,466 INFO [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)
[Oracle JRockit(R) (Oracle Corporation)]
2014-07-03 21:00:10,466 INFO [AIF]: Java Platform: java1.6.0_37
2014-07-03 21:00:10,466 INFO [AIF]: Log File Encoding: UTF-8
2014-07-03 21:00:11,673 INFO [AIF]: -------START IMPORT STEP-------
2014-07-03 21:00:13,791 DEBUG [AIF]: CommData.preImportData - START
2014-07-03 21:00:13,794 DEBUG [AIF]: CommData.getRuleInfo - START
2014-07-03 21:00:13,794 DEBUG [AIF]:
SELECT brl.RULE_ID
,br.RULE_NAME
,brl.PARTITIONKEY
,brl.CATKEY
,part.PARTVALGROUP
,br.SOURCE_SYSTEM_ID
,ss.SOURCE_SYSTEM_TYPE
,CASE
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'EBS%' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'PS%' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FUSION%' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FILE%' THEN 'N'
ELSE 'Y'
END SOURCE_ADAPTER_FLAG
,app.APPLICATION_ID
,app.TARGET_APPLICATION_NAME
,app.TARGET_APPLICATION_TYPE
,app.DATA_LOAD_METHOD
,brl.PLAN_TYPE
,CASE brl.PLAN_TYPE
WHEN 'PLAN1' THEN 1
WHEN 'PLAN2' THEN 2
WHEN 'PLAN3' THEN 3
WHEN 'PLAN4' THEN 4
WHEN 'PLAN5' THEN 5
ELSE 0
END PLAN_NUMBER
,br.INCL_ZERO_BALANCE_FLAG
,br.PERIOD_MAPPING_TYPE
,br.INCLUDE_ADJ_PERIODS_FLAG
,br.BALANCE_TYPE ACTUAL_FLAG
,br.AMOUNT_TYPE
,br.BALANCE_SELECTION
,br.BALANCE_METHOD_CODE
,COALESCE(br.SIGNAGE_METHOD, 'ABSOLUTE') SIGNAGE_METHOD
,br.CURRENCY_CODE
,br.BAL_SEG_VALUE_OPTION_CODE
,brl.EXECUTION_MODE
,COALESCE(brl.IMPORT_FROM_SOURCE_FLAG, 'Y') IMPORT_FROM_SOURCE_FLAG
,COALESCE(brl.RECALCULATE_FLAG, 'N') RECALCULATE_FLAG
,COALESCE(brl.EXPORT_TO_TARGET_FLAG, 'N') EXPORT_TO_TARGET_FLAG
,COALESCE(brl.CHECK_FLAG, 'N') CHECK_FLAG
,CASE
WHEN (br.LEDGER_GROUP_ID IS NOT NULL) THEN 'MULTI'
WHEN (br.SOURCE_LEDGER_ID IS NOT NULL) THEN 'SINGLE'
ELSE 'NONE'
END LEDGER_GROUP_CODE
,COALESCE(br.BALANCE_AMOUNT_BS, 'YTD') BALANCE_AMOUNT_BS
,COALESCE(br.BALANCE_AMOUNT_IS, 'PERIODIC') BALANCE_AMOUNT_IS
,br.LEDGER_GROUP
,(SELECT brd.DETAIL_CODE
FROM AIF_BAL_RULE_DETAILS brd
WHERE brd.RULE_ID = br.RULE_ID
AND brd.DETAIL_TYPE = 'LEDGER'
) PS_LEDGER
,CASE lg.LEDGER_TEMPLATE
WHEN 'COMMITMENT' THEN 'Y'
ELSE 'N'
END KK_FLAG
,p.LAST_UPDATED_BY
,p.AIF_WEB_SERVICE_URL WEB_SERVICE_URL
,p.EPM_ORACLE_INSTANCE
,brl.JOURNAL_FLAG
,br.MULTI_PERIOD_FILE_FLAG
,br.IMPGROUPKEY
FROM AIF_PROCESSES p
INNER JOIN AIF_BAL_RULE_LOADS brl
ON brl.LOADID = p.PROCESS_ID
INNER JOIN AIF_BALANCE_RULES br
ON br.RULE_ID = brl.RULE_ID
INNER JOIN AIF_SOURCE_SYSTEMS ss
ON ss.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID
INNER JOIN AIF_TARGET_APPLICATIONS app
ON app.APPLICATION_ID = brl.APPLICATION_ID
INNER JOIN TPOVPARTITION part
ON part.PARTITIONKEY = br.PARTITIONKEY
INNER JOIN TBHVIMPGROUP imp
ON imp.IMPGROUPKEY = part.PARTIMPGROUP
LEFT OUTER JOIN AIF_COA_LEDGERS l
ON l.SOURCE_SYSTEM_ID = p.SOURCE_SYSTEM_ID
AND l.SOURCE_LEDGER_ID = COALESCE(br.SOURCE_LEDGER_ID,imp.IMPSOURCELEDGERID)
LEFT OUTER JOIN AIF_PS_SET_CNTRL_REC_STG scr
ON scr.SOURCE_SYSTEM_ID = l.SOURCE_SYSTEM_ID
AND scr.SETCNTRLVALUE = l.SOURCE_LEDGER_NAME
AND scr.RECNAME = 'LED_GRP_TBL'
LEFT OUTER JOIN AIF_PS_LED_GRP_TBL_STG lg
ON lg.SOURCE_SYSTEM_ID = scr.SOURCE_SYSTEM_ID
AND lg.SETID = scr.SETID
AND lg.LEDGER_GROUP = br.LEDGER_GROUP
WHERE p.PROCESS_ID = 339
2014-07-03 21:00:13,798 DEBUG [AIF]:
SELECT adim.BALANCE_COLUMN_NAME DIMNAME
,adim.DIMENSION_ID
,dim.TARGET_DIMENSION_CLASS_NAME
,(SELECT COA_SEGMENT_NAME
FROM AIF_COA_SEGMENTS cs
WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1
) COA_SEGMENT_NAME1
,(SELECT COA_SEGMENT_NAME
FROM AIF_COA_SEGMENTS cs
WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID2
) COA_SEGMENT_NAME2
,(SELECT COA_SEGMENT_NAME
FROM AIF_COA_SEGMENTS cs
WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID3
) COA_SEGMENT_NAME3
,(SELECT COA_SEGMENT_NAME
FROM AIF_COA_SEGMENTS cs
WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID4
) COA_SEGMENT_NAME4
,(SELECT COA_SEGMENT_NAME
FROM AIF_COA_SEGMENTS cs
WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID5
) COA_SEGMENT_NAME5
,(SELECT CASE mdd.ORPHAN_OPTION_CODE
WHEN 'CHILD' THEN 'N'
WHEN 'ROOT' THEN 'N'
ELSE 'Y'
END DIMENSION_FILTER_FLAG
FROM AIF_MAP_DIM_DETAILS_V mdd
,AIF_MAPPING_RULES mr
WHERE mr.PARTITIONKEY = tpp.PARTITIONKEY
AND mdd.RULE_ID = mr.RULE_ID
AND mdd.DIMENSION_ID = adim.DIMENSION_ID
) DIMENSION_FILTER_FLAG
,tiie.IMPCONCATCHAR
FROM TPOVPARTITION tpp
INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim
ON adim.APPLICATION_ID = 18
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 = 22
AND adim.BALANCE_COLUMN_NAME IS NOT NULL
AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
ORDER BY adim.BALANCE_COLUMN_NAME
2014-07-03 21:00:13,800 DEBUG [AIF]: {'APPLICATION_ID': 18L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'POC9_DLR', 'ACTUAL_FLAG': u'A', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'C:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 7L, 'BAL_SEG_VALUE_OPTION_CODE': u'ALL', 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'EBS_R12', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'POC9', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 14L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2'], 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 113L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT1', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 110L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT5', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 112L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT3', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 108L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT2', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 111L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 22L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'SINGLE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': u'SNAPSHOT', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 34L, 'BALANCE_AMOUNT_BS': u'PERIODIC', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': u'STANDARD', 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://epmvirtual:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI'}
2014-07-03 21:00:13,800 DEBUG [AIF]: CommData.getRuleInfo - END
2014-07-03 21:00:13,818 DEBUG [AIF]: CommData.insertPeriods - START
2014-07-03 21:00:13,821 DEBUG [AIF]: CommData.getLedgerListAndMap - START
2014-07-03 21:00:13,821 DEBUG [AIF]: CommData.getLedgerSQL - START
2014-07-03 21:00:13,821 DEBUG [AIF]: CommData.getLedgerSQL - END
2014-07-03 21:00:13,821 DEBUG [AIF]:
SELECT l.SOURCE_LEDGER_ID
,l.SOURCE_LEDGER_NAME
,l.SOURCE_COA_ID
,l.CALENDAR_ID
,'0' SETID
,l.PERIOD_TYPE
,NULL LEDGER_TABLE_NAME
FROM AIF_BALANCE_RULES br
,AIF_COA_LEDGERS l
WHERE br.RULE_ID = 34
AND l.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID
AND l.SOURCE_LEDGER_ID = br.SOURCE_LEDGER_ID
2014-07-03 21:00:13,822 DEBUG [AIF]: CommData.getLedgerListAndMap - END
2014-07-03 21:00:13,824 DEBUG [AIF]: commAppPeriodMappingExists: Y
2014-07-03 21:00:13,824 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY
2014-07-03 21:00:13,824 DEBUG [AIF]:
INSERT INTO AIF_PROCESS_PERIODS (
PROCESS_ID
,PERIODKEY
,PERIOD_ID
,ADJUSTMENT_PERIOD_FLAG
,GL_PERIOD_YEAR
,GL_PERIOD_NUM
,GL_PERIOD_NAME
,GL_PERIOD_CODE
,GL_EFFECTIVE_PERIOD_NUM
,YEARTARGET
,PERIODTARGET
,IMP_ENTITY_TYPE
,IMP_ENTITY_ID
,IMP_ENTITY_NAME
,TRANS_ENTITY_TYPE
,TRANS_ENTITY_ID
,TRANS_ENTITY_NAME
,PRIOR_PERIOD_FLAG
,SOURCE_LEDGER_ID
)
SELECT DISTINCT brl.LOADID PROCESS_ID
,pp.PERIODKEY PERIODKEY
,prd.PERIOD_ID
,COALESCE(prd.ADJUSTMENT_PERIOD_FLAG, 'N') ADJUSTMENT_PERIOD_FLAG
,COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) GL_PERIOD_YEAR
,COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0) GL_PERIOD_NUM
,COALESCE(prd.PERIOD_NAME, ppsrc.GL_PERIOD_NAME,'0') GL_PERIOD_NAME
,COALESCE(prd.PERIOD_CODE, CAST(COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0) AS VARCHAR(38)),'0') GL_PERIOD_CODE
,(COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) * 10000 + COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0)) GL_EFFECTIVE_PERIOD_NUM
,pp.YEARTARGET YEARTARGET
,pp.PERIODTARGET PERIODTARGET
,'PROCESS_BAL_IMP' IMP_ENTITY_TYPE
,(COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) * 10000 + COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0)) IMP_ENTITY_ID
,COALESCE(prd.PERIOD_NAME, ppsrc.GL_PERIOD_NAME,'0') IMP_ENTITY_NAME
,'PROCESS_BAL_TRANS' TRANS_ENTITY_TYPE
,(COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) * 10000 + COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0)) TRANS_ENTITY_ID
,pp.PERIODDESC TRANS_ENTITY_NAME
,'N' PRIOR_PERIOD_FLAG
,1 SOURCE_LEDGER_ID
FROM (
AIF_BAL_RULE_LOADS brl
INNER JOIN TPOVCATEGORY pc
ON pc.CATKEY = brl.CATKEY
INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp
ON pp.PERIODFREQ = pc.CATFREQ
AND pp.PERIODKEY >= brl.START_PERIODKEY
AND pp.PERIODKEY <= brl.END_PERIODKEY
AND pp.INTSYSTEMKEY = 'POC9'
)
INNER JOIN TPOVPERIODSOURCE ppsrc
ON ppsrc.PERIODKEY = pp.PERIODKEY
AND ppsrc.MAPPING_TYPE = 'EXPLICIT'
AND ppsrc.SOURCE_SYSTEM_ID = 14
AND ppsrc.CALENDAR_ID IN ('10000')
LEFT OUTER JOIN AIF_GL_PERIODS_STG prd
ON prd.PERIOD_ID = ppsrc.PERIOD_ID
AND prd.SOURCE_SYSTEM_ID = ppsrc.SOURCE_SYSTEM_ID
AND prd.CALENDAR_ID = ppsrc.CALENDAR_ID
AND prd.SETID = '0'
AND prd.PERIOD_TYPE = 'Month'
AND prd.ADJUSTMENT_PERIOD_FLAG = 'N'
WHERE brl.LOADID = 339
ORDER BY pp.PERIODKEY
,GL_EFFECTIVE_PERIOD_NUM
2014-07-03 21:00:13,825 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', 'PROCESS_BAL_TRANS', 1L, u'POC9', u'EXPLICIT', 14L, u'10000', u'0', u'Month', 'N', 339]
2014-07-03 21:00:13,826 DEBUG [AIF]: CommData.insertPeriods - END
2014-07-03 21:00:13,828 DEBUG [AIF]: CommData.insertImportProcessDetails - START
2014-07-03 21:00:13,828 DEBUG [AIF]:
INSERT INTO AIF_PROCESS_DETAILS (
PROCESS_ID
,ENTITY_TYPE
,ENTITY_ID
,ENTITY_NAME
,ENTITY_NAME_ORDER
,TARGET_TABLE_NAME
,EXECUTION_START_TIME
,EXECUTION_END_TIME
,RECORDS_PROCESSED
,STATUS
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
)
SELECT PROCESS_ID
,ENTITY_TYPE
,ENTITY_ID
,ENTITY_NAME
,ENTITY_NAME_ORDER
,'AIF_EBS_GL_BALANCES_STG' TARGET_TABLE_NAME
,CURRENT_TIMESTAMP EXECUTION_START_TIME
,NULL EXECUTION_END_TIME
,0 RECORDS_PROCESSED
,'PENDING' STATUS
,'admin' 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
2014-07-03 21:00:13,830 DEBUG [AIF]: CommData.insertImportProcessDetails - END
2014-07-03 21:00:13,835 DEBUG [AIF]: Comm.doScriptInit - START
2014-07-03 21:00:13,993 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=C:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=C:\Oracle\FDMEE\inbox, LOCNAME=POC9_LOC, SOURCENAME=POC9_SRC, APPID=18, IMPORTFORMAT=POC9_IMF, SCRIPTSDIR=C:\Oracle\FDMEE\data\scripts, EPMORACLEHOME=C:\Oracle\Middleware\EPMSystem11R1, RULEID=34, CATNAME=ACTUALS, EPMORACLEINSTANCEHOME=C:\Oracle\Middleware\user_projects\epmsystem1, LOADID=339, PERIODNAME=Aug-13, IMPORTMODE=SNAPSHOT, SOURCETYPE=EBS_R12, PERIODKEY=2013-08-31, TARGETAPPDB=NA, EXPORTFLAG=Y, TARGETAPPNAME=POC9, LOCKEY=22, RULENAME=POC9_DLR, OUTBOXDIR=C:\Oracle\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=Replace, CATKEY=7, FILEDIR=null, IMPORTFLAG=Y}
2014-07-03 21:00:13,993 DEBUG [AIF]: The EpmOracleHome is set to: C:\Oracle\Middleware\EPMSystem11R1
2014-07-03 21:00:13,993 DEBUG [AIF]: The EpmOracleInstance is set to: C:\Oracle\Middleware\user_projects\epmsystem1
2014-07-03 21:00:13,993 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35
2014-07-03 21:00:13,994 DEBUG [AIF]: The executeEventScript is set to: YES
2014-07-03 21:00:13,994 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB
2014-07-03 21:00:13,994 DEBUG [AIF]: The AppRootFolder is set to: C:\Oracle\FDMEE
2014-07-03 21:00:13,994 DEBUG [AIF]: Comm.doScriptInit - END
2014-07-03 21:00:13,994 DEBUG [AIF]: Comm.executeScript - START
2014-07-03 21:00:13,995 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/BefImport.py
2014-07-03 21:00:13,997 DEBUG [AIF]: Comm.executeVBScript - START
2014-07-03 21:00:13,997 DEBUG [AIF]: The WindowsTempFolder is set to: c:\temp
2014-07-03 21:00:13,997 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\BefImport.vbs
2014-07-03 21:00:13,998 DEBUG [AIF]: Comm.executeVBScript - END
2014-07-03 21:00:13,998 DEBUG [AIF]: Comm.executeScript - END
2014-07-03 21:00:13,998 DEBUG [AIF]: CommData.preImportData - END
2014-07-03 21:00:16,267 DEBUG [AIF]:
EBS/FS GL Balances Print Variables
==================================
p_process_id: 339
p_sql_db_type: SQLSERVER
p_partitionkey: 22
p_rule_id: 34
p_source_system_id: 14
p_application_id: 18
p_target_application_type: HFM
p_is_multi_currency: true
p_data_load_method: CLASSIC_VIA_EPMI
p_bal_balance_method_code: STANDARD
p_bal_ledger_group_code: SINGLE
p_bal_amount_type: MONETARY
p_prd_entity_name: Aug-13
p_prd_period_id: 35961
p_prd_gl_period_name: Aug-13
p_prd_source_ledger_id: 1
p_prd_source_coa_id: 101
p_source_ledger_id: 1
p_source_coa_id: 101
p_bal_actual_flag: A
p_bal_seg_column_name: SEGMENT1
p_max_ccid_loaded_to_stg: 890060
p_count_ccid_loaded_to_stg: 7629
2014-07-03 21:00:16,761 DEBUG [AIF]: LKM EBS/FS Extract Type - Load Audit and Full Refresh - START
2014-07-03 21:00:16,762 DEBUG [AIF]:
SELECT p.PROCESS_ID
,br.RULE_NAME
,l.SOURCE_LEDGER_NAME
FROM AIF_GL_LOAD_AUDIT aud
,AIF_PROCESSES p
,AIF_BALANCE_RULES br
,AIF_COA_LEDGERS l
WHERE aud.SOURCE_SYSTEM_ID = 14
AND aud.SOURCE_LEDGER_ID = 1
AND aud.GL_PERIOD_ID = 35961
AND aud.BALANCE_TYPE = 'A'
AND p.PROCESS_ID = aud.LAST_LOADID
AND p.STATUS = 'RUNNING'
AND p.PROCESS_ID <> 339
AND br.RULE_ID = p.RULE_ID
AND l.SOURCE_SYSTEM_ID = aud.SOURCE_SYSTEM_ID
AND l.SOURCE_LEDGER_ID = aud.SOURCE_LEDGER_ID
2014-07-03 21:00:16,763 DEBUG [AIF]:
SELECT 'Y' VALID_FLAG
FROM GL_PERIOD_STATUSES
WHERE APPLICATION_ID = 101
AND LEDGER_ID = 1
AND PERIOD_NAME = 'Aug-13'
AND CLOSING_STATUS IN ('O','C','P')
2014-07-03 21:00:16,961 DEBUG [AIF]:
SELECT 'Y' EXISTS_FLAG
FROM GL_TRACK_DELTA_BALANCES
WHERE LEDGER_ID = 1
AND PROGRAM_CODE = 'FEM'
AND PERIOD_NAME = 'Aug-13'
AND ACTUAL_FLAG = 'A'
AND EXTRACT_LEVEL_CODE = 'DTL'
AND CURRENCY_TYPE_CODE = 'B'
AND ENABLED_FLAG = 'Y'
2014-07-03 21:00:17,151 DEBUG [AIF]:
SELECT MAX(DELTA_RUN_ID) MAX_DELTA_RUN_ID
FROM GL_BALANCES_DELTA
WHERE LEDGER_ID = 1
AND PERIOD_NAME = 'Aug-13'
AND ACTUAL_FLAG = 'A'
2014-07-03 21:00:17,562 DEBUG [AIF]:
SELECT brl.EXECUTION_MODE
,(SELECT CASE COUNT(aud.DELTA_RUN_ID) WHEN 0 THEN 'N' ELSE 'Y' END
FROM AIF_GL_LOAD_AUDIT aud
WHERE aud.SOURCE_SYSTEM_ID = 14
AND aud.SOURCE_LEDGER_ID = 1
AND aud.GL_PERIOD_ID = 35961
AND aud.BALANCE_TYPE = 'A'
AND aud.LAST_LOADID <> brl.LOADID
AND COALESCE(aud.STATUS, 'SUCCESS') = 'SUCCESS'
) GL_LOAD_AUDIT_SUCCESS_FLAG
,(SELECT CASE COUNT(aud.DELTA_RUN_ID) WHEN 0 THEN 'N' ELSE 'Y' END
FROM AIF_GL_LOAD_AUDIT aud
WHERE aud.SOURCE_SYSTEM_ID = 14
AND aud.SOURCE_LEDGER_ID = 1
AND aud.GL_PERIOD_ID = 35961
AND aud.BALANCE_TYPE = 'A'
AND aud.LAST_LOADID <> brl.LOADID
AND aud.STATUS = 'RUNNING'
) GL_LOAD_AUDIT_RUNNING_FLAG
FROM AIF_BAL_RULE_LOADS brl
WHERE brl.LOADID = 339
2014-07-03 21:00:17,565 DEBUG [AIF]:
INSERT INTO AIF_GL_LOAD_AUDIT (
LAST_LOADID
,DELTA_RUN_ID
,SOURCE_SYSTEM_ID
,SOURCE_LEDGER_ID
,GL_PERIOD_ID
,BALANCE_TYPE
,GL_EXTRACT_TYPE
,STATUS
) VALUES (
339
,1410719
,14
,1
,35961
,'A'
,'INCREMENTAL'
,'RUNNING'
)
2014-07-03 21:00:17,566 DEBUG [AIF]: LKM EBS/FS Extract Type - Load Audit and Full Refresh - END
2014-07-03 21:00:17,853 DEBUG [AIF]: Comm.updateProcessDetail - START
2014-07-03 21:00:17,854 DEBUG [AIF]:
UPDATE AIF_PROCESS_DETAILS
SET STATUS = 'SUCCESS'
,RECORDS_PROCESSED = CASE
WHEN RECORDS_PROCESSED IS NULL THEN 0
ELSE RECORDS_PROCESSED
END + 0
,EXECUTION_END_TIME = CURRENT_TIMESTAMP
,LAST_UPDATED_BY = CASE
WHEN ('admin' IS NULL) THEN LAST_UPDATED_BY
ELSE 'admin'
END
,LAST_UPDATE_DATE = CURRENT_TIMESTAMP
WHERE PROCESS_ID = 339
AND ENTITY_TYPE = 'PROCESS_BAL_IMP'
AND ENTITY_NAME = 'Aug-13'
2014-07-03 21:00:17,856 DEBUG [AIF]: Comm.updateProcessDetail - END
2014-07-03 21:00:17,945 DEBUG [AIF]: EbsData.postImportData - START
2014-07-03 21:00:17,946 DEBUG [AIF]: CommData.postImportData - START
2014-07-03 21:00:17,946 DEBUG [AIF]: CommData.postImportData - END
2014-07-03 21:00:17,968 DEBUG [AIF]: EBS/FS Load Data - Load TDATASEG_T - START
2014-07-03 21:00:17,970 DEBUG [AIF]: CommData.getLedgerListAndMap - START
2014-07-03 21:00:17,970 DEBUG [AIF]: CommData.getLedgerSQL - START
2014-07-03 21:00:17,970 DEBUG [AIF]: CommData.getLedgerSQL - END
2014-07-03 21:00:17,970 DEBUG [AIF]:
SELECT l.SOURCE_LEDGER_ID
,l.SOURCE_LEDGER_NAME
,l.SOURCE_COA_ID
,l.CALENDAR_ID
,'0' SETID
,l.PERIOD_TYPE
,NULL LEDGER_TABLE_NAME
FROM AIF_BALANCE_RULES br
,AIF_COA_LEDGERS l
WHERE br.RULE_ID = 34
AND l.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID
AND l.SOURCE_LEDGER_ID = br.SOURCE_LEDGER_ID
2014-07-03 21:00:17,971 DEBUG [AIF]: CommData.getLedgerListAndMap - END
2014-07-03 21:00:17,972 DEBUG [AIF]: CommData.getPovList - START
2014-07-03 21:00:17,972 DEBUG [AIF]:
SELECT PARTITIONKEY
,PARTNAME
,CATKEY
,CATNAME
,PERIODKEY
,COALESCE(PERIODDESC, CONVERT(VARCHAR,PERIODKEY,120)) PERIODDESC
,RULE_ID
,RULE_NAME
FROM (
SELECT DISTINCT brl.PARTITIONKEY
,part.PARTNAME
,brl.CATKEY
,cat.CATNAME
,pprd.PERIODKEY
,pp.PERIODDESC
,brl.RULE_ID
,br.RULE_NAME
FROM AIF_BAL_RULE_LOADS brl
INNER JOIN AIF_BALANCE_RULES br
ON br.RULE_ID = brl.RULE_ID
INNER JOIN TPOVPARTITION part
ON part.PARTITIONKEY = brl.PARTITIONKEY
INNER JOIN TPOVCATEGORY cat
ON cat.CATKEY = brl.CATKEY
INNER JOIN AIF_PROCESS_PERIODS pprd
ON pprd.PROCESS_ID = brl.LOADID
LEFT OUTER JOIN TPOVPERIODADAPTOR pp
ON pp.PERIODKEY = pprd.PERIODKEY
AND pp.INTSYSTEMKEY = 'POC9'
WHERE brl.LOADID = 339
) q
ORDER BY PARTITIONKEY
,CATKEY
,PERIODKEY
,RULE_ID
2014-07-03 21:00:17,973 DEBUG [AIF]: CommData.getPovList - END
2014-07-03 21:00:17,974 INFO [AIF]:
Import Data from Source for Period 'Aug-13'
2014-07-03 21:00:17,979 DEBUG [AIF]: CommData.updateWorkflow - START
2014-07-03 21:00:17,980 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 = 22
AND tlp.CATKEY = 7
AND tlp.PERIODKEY = '2013-08-31'
AND tlp.RULE_ID = 34
AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS
2014-07-03 21:00:17,981 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 = 22
AND CATKEY = 7
AND PERIODKEY = '2013-08-31'
AND RULE_ID = 34
2014-07-03 21:00:17,983 DEBUG [AIF]: CommData.updateWorkflow - END
2014-07-03 21:00:17,983 INFO [AIF]:
Import Data from Source for Ledger 'Vision Operations (USA)'
2014-07-03 21:00:17,983 DEBUG [AIF]:
SELECT COA_SEGMENT_NAME
,ACCOUNT_TYPE_FLAG
,BALANCE_TYPE_FLAG
FROM AIF_COA_SEGMENTS
WHERE SOURCE_SYSTEM_ID = 14
AND SOURCE_COA_ID = '101'
AND (
ACCOUNT_TYPE_FLAG = 'Y'
OR BALANCE_TYPE_FLAG = 'Y'
)
2014-07-03 21:00:17,984 DEBUG [AIF]:
SELECT adim.BALANCE_COLUMN_NAME DIMNAME
,adim.DIMENSION_ID
,dim.TARGET_DIMENSION_CLASS_NAME
,(SELECT COA_SEGMENT_NAME
FROM AIF_COA_SEGMENTS cs
WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1
) COA_SEGMENT_NAME1
,(SELECT COA_SEGMENT_NAME
FROM AIF_COA_SEGMENTS cs
WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID2
) COA_SEGMENT_NAME2
,(SELECT COA_SEGMENT_NAME
FROM AIF_COA_SEGMENTS cs
WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID3
) COA_SEGMENT_NAME3
,(SELECT COA_SEGMENT_NAME
FROM AIF_COA_SEGMENTS cs
WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID4
) COA_SEGMENT_NAME4
,(SELECT COA_SEGMENT_NAME
FROM AIF_COA_SEGMENTS cs
WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID5
) COA_SEGMENT_NAME5
,(SELECT CASE mdd.ORPHAN_OPTION_CODE
WHEN 'CHILD' THEN 'N'
WHEN 'ROOT' THEN 'N'
ELSE 'Y'
END DIMENSION_FILTER_FLAG
FROM AIF_MAP_DIM_DETAILS_V mdd
,AIF_MAPPING_RULES mr
WHERE mr.PARTITIONKEY = tpp.PARTITIONKEY
AND mdd.RULE_ID = mr.RULE_ID
AND mdd.DIMENSION_ID = adim.DIMENSION_ID
) DIMENSION_FILTER_FLAG
,tiie.IMPCONCATCHAR
FROM TPOVPARTITION tpp
INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim
ON adim.APPLICATION_ID = 18
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 = 22
AND adim.BALANCE_COLUMN_NAME IS NOT NULL
AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
ORDER BY adim.BALANCE_COLUMN_NAME
2014-07-03 21:00:17,986 DEBUG [AIF]:
INSERT INTO TDATASEG_T (
LOADID
,PARTITIONKEY
,CATKEY
,RULE_ID
,PERIODKEY
,VALID_FLAG
,CHANGESIGN
,CODE_COMBINATION_ID
,SOURCE_LEDGER_ID
,GL_PERIOD_YEAR
,GL_PERIOD_NUM
,YEAR
,PERIOD
,ATTR1
,ATTR2
,ATTR3
,ATTR4
,ATTR5
,ATTR6
,ATTR7
,ATTR8
,ATTR9
,ATTR10
,ATTR11
,ATTR12
,ATTR13
,ATTR14
,ACCOUNT
,ACCOUNTX
,ENTITY
,ENTITYX
,ICP
,ICPX
,UD1
,UD1X
,UD2
,UD2X
,DATAVIEW
,STAT_BALANCE_FLAG
,CURKEY
,AMOUNT_PTD
,AMOUNT_YTD
,AMOUNT
,AMOUNTX
)
SELECT bal.PROCESS_ID LOADID
,22 PARTITIONKEY
,7 CATKEY
,34 RULE_ID
,bal.PERIODKEY
,'Y' VALID_FLAG
,0 CHANGESIGN
,ccid.CODE_COMBINATION_ID
,bal.SOURCE_LEDGER_ID
,bal.GL_PERIOD_YEAR
,bal.GL_PERIOD_NUM
,bal.YEARTARGET YEAR
,bal.PERIODTARGET PERIOD
,bal.PROCESS_ID ATTR1
,bal.SOURCE_SYSTEM_ID ATTR2
,bal.SOURCE_LEDGER_ID ATTR3
,bal.GL_PERIOD_YEAR ATTR4
,bal.GL_PERIOD_NAME ATTR5
,bal.ACTUAL_FLAG ATTR6
,bal.BUDGET_VERSION_ID ATTR7
,bal.ENCUMBRANCE_TYPE_ID ATTR8
,ccid.ACCOUNT_TYPE ATTR9
,NULL ATTR10
,NULL ATTR11
,NULL ATTR12
,NULL ATTR13
,NULL ATTR14
,ccid.SEGMENT3 ACCOUNT
,NULL ACCOUNTX
,ccid.SEGMENT1 ENTITY
,NULL ENTITYX
,NULL ICP
,NULL ICPX
,ccid.SEGMENT2 UD1
,NULL UD1X
,ccid.SEGMENT5 UD2
,NULL UD2X
,'Periodic' DATAVIEW
,'N' STAT_BALANCE_FLAG
,bal.CURRENCY_CODE CURKEY
,( CASE WHEN ccid.ACCOUNT_TYPE IN ('A','E','D') THEN 1 ELSE -1 END ) * bal.AMOUNT_PTD AMOUNT_PTD
,( CASE WHEN ccid.ACCOUNT_TYPE IN ('A','E','D') THEN 1 ELSE -1 END ) * bal.AMOUNT_YTD AMOUNT_YTD
,( CASE WHEN ccid.ACCOUNT_TYPE IN ('A','E','D') THEN 1 ELSE -1 END ) * bal.AMOUNT_PTD AMOUNT
,( CASE WHEN ccid.ACCOUNT_TYPE IN ('A','E','D') THEN 1 ELSE -1 END ) * bal.AMOUNT_PTD AMOUNTX
FROM (
SELECT gb.SOURCE_SYSTEM_ID
,gb.SOURCE_COA_ID
,gb.SOURCE_LEDGER_ID
,gb.CODE_COMBINATION_ID
,gb.ACTUAL_FLAG
,gb.BUDGET_VERSION_ID
,gb.ENCUMBRANCE_TYPE_ID
,pprd.PROCESS_ID
,pprd.PERIODKEY
,pprd.PERIOD_ID
,pprd.GL_PERIOD_YEAR
,pprd.GL_PERIOD_NAME
,pprd.GL_PERIOD_NUM
,pprd.YEARTARGET
,pprd.PERIODTARGET
,MAX( gb.DELTA_RUN_ID ) DELTA_RUN_ID
,gb.CURRENCY_CODE
,SUM( gb.PERIOD_NET_DR - gb.PERIOD_NET_CR ) AMOUNT_PTD
,SUM( gb.BEGIN_BALANCE_DR - gb.BEGIN_BALANCE_CR + gb.PERIOD_NET_DR - gb.PERIOD_NET_CR ) AMOUNT_YTD
FROM AIF_EBS_GL_BALANCES_STG gb
,AIF_PROCESS_PERIODS pprd
,AIF_EBS_GL_CCID_STG ccid
WHERE gb.SOURCE_SYSTEM_ID = 14
AND gb.SOURCE_LEDGER_ID = 1
AND gb.ACTUAL_FLAG = 'A'
AND pprd.PROCESS_ID = 339
AND pprd.PERIODKEY = '2013-08-31'
AND pprd.SOURCE_LEDGER_ID = gb.SOURCE_LEDGER_ID
AND pprd.GL_PERIOD_NAME = gb.PERIOD_NAME
AND ccid.SOURCE_SYSTEM_ID = gb.SOURCE_SYSTEM_ID
AND ccid.SOURCE_COA_ID = gb.SOURCE_COA_ID
AND ccid.CODE_COMBINATION_ID = gb.CODE_COMBINATION_ID
AND (
gb.PERIOD_NET_DR <> 0
OR gb.PERIOD_NET_CR <> 0
)
AND gb.CURRENCY_CODE <> 'STAT'
AND gb.TRANSLATED_FLAG IS NULL
GROUP BY gb.SOURCE_SYSTEM_ID
,gb.SOURCE_COA_ID
,gb.SOURCE_LEDGER_ID
,gb.CODE_COMBINATION_ID
,gb.ACTUAL_FLAG
,gb.BUDGET_VERSION_ID
,gb.ENCUMBRANCE_TYPE_ID
,pprd.PROCESS_ID
,pprd.PERIODKEY
,pprd.PERIOD_ID
,pprd.GL_PERIOD_YEAR
,pprd.GL_PERIOD_NAME
,pprd.GL_PERIOD_NUM
,pprd.YEARTARGET
,pprd.PERIODTARGET
,gb.CURRENCY_CODE
) bal
,AIF_EBS_GL_CCID_STG ccid
WHERE ccid.SOURCE_SYSTEM_ID = bal.SOURCE_SYSTEM_ID
AND ccid.SOURCE_COA_ID = bal.SOURCE_COA_ID
AND ccid.CODE_COMBINATION_ID = bal.CODE_COMBINATION_ID
2014-07-03 21:00:17,993 INFO [AIF]: Monetary Data Rows Imported from Source: 5
2014-07-03 21:00:17,994 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
,'POC9' TARGET_APPLICATION_NAME
,NULL PLAN_TYPE
,SOURCE_LEDGER_ID
,YEARTARGET EPM_YEAR
,PERIODTARGET EPM_PERIOD
,'Y' SNAPSHOT_FLAG
,22 PARTITIONKEY
,7 CATKEY
,34 RULE_ID
,PERIODKEY
,'N' EXPORT_TO_TARGET_FLAG
FROM AIF_PROCESS_PERIODS
WHERE PROCESS_ID = 339
AND PERIODKEY = '2013-08-31'
AND SOURCE_LEDGER_ID = 1
2014-07-03 21:00:17,994 DEBUG [AIF]:
INSERT INTO AIF_APPL_LOAD_PRD_AUDIT (
LOADID
,SOURCE_LEDGER_ID
,GL_PERIOD_ID
,DELTA_RUN_ID
,PARTITIONKEY
,CATKEY
,RULE_ID
,PERIODKEY
)
SELECT DISTINCT pprd.PROCESS_ID LOADID
,pprd.SOURCE_LEDGER_ID
,pprd.PERIOD_ID GL_PERIOD_ID
,(SELECT MAX(gl.DELTA_RUN_ID)
FROM AIF_GL_LOAD_AUDIT gl
WHERE gl.SOURCE_SYSTEM_ID = 14
AND gl.SOURCE_LEDGER_ID = pprd.SOURCE_LEDGER_ID
AND gl.BALANCE_TYPE = 'A'
AND gl.GL_PERIOD_ID = pprd.PERIOD_ID
) DELTA_RUN_ID
,22 PARTITIONKEY
,7 CATKEY
,34 RULE_ID
,pprd.PERIODKEY
FROM AIF_PROCESS_PERIODS pprd
WHERE pprd.PROCESS_ID = 339
AND pprd.PERIODKEY = '2013-08-31'
AND pprd.SOURCE_LEDGER_ID = 1
2014-07-03 21:00:17,996 INFO [AIF]: Total Data Rows Imported from Source: 5
2014-07-03 21:00:17,996 DEBUG [AIF]: EBS/FS Load Data - Load TDATASEG_T - END
2014-07-03 21:00:17,996 DEBUG [AIF]: Comm.executeScript - START
2014-07-03 21:00:17,996 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/AftImport.py
2014-07-03 21:00:17,996 DEBUG [AIF]: Comm.executeVBScript - START
2014-07-03 21:00:17,996 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\AftImport.vbs
2014-07-03 21:00:17,996 DEBUG [AIF]: Comm.executeVBScript - END
2014-07-03 21:00:17,996 DEBUG [AIF]: Comm.executeScript - END
2014-07-03 21:00:17,996 DEBUG [AIF]: EbsData.postImportData - END
2014-07-03 21:00:18,286 DEBUG [AIF]: LogicGroup.createLogicAccounts - START
2014-07-03 21:00:18,292 DEBUG [AIF]: Comm.doScriptInit - START
2014-07-03 21:00:18,456 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=C:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=C:\Oracle\FDMEE\inbox, LOCNAME=POC9_LOC, SOURCENAME=POC9_SRC, APPID=18, IMPORTFORMAT=POC9_IMF, SCRIPTSDIR=C:\Oracle\FDMEE\data\scripts, EPMORACLEHOME=C:\Oracle\Middleware\EPMSystem11R1, RULEID=34, CATNAME=ACTUALS, EPMORACLEINSTANCEHOME=C:\Oracle\Middleware\user_projects\epmsystem1, LOADID=339, PERIODNAME=Aug-13, IMPORTMODE=SNAPSHOT, SOURCETYPE=EBS_R12, PERIODKEY=2013-08-31, TARGETAPPDB=NA, EXPORTFLAG=Y, TARGETAPPNAME=POC9, LOCKEY=22, RULENAME=POC9_DLR, OUTBOXDIR=C:\Oracle\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=Replace, CATKEY=7, FILEDIR=null, IMPORTFLAG=Y}
2014-07-03 21:00:18,456 DEBUG [AIF]: The EpmOracleHome is set to: C:\Oracle\Middleware\EPMSystem11R1
2014-07-03 21:00:18,456 DEBUG [AIF]: The EpmOracleInstance is set to: C:\Oracle\Middleware\user_projects\epmsystem1
2014-07-03 21:00:18,456 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35
2014-07-03 21:00:18,456 DEBUG [AIF]: The executeEventScript is set to: YES
2014-07-03 21:00:18,456 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB
2014-07-03 21:00:18,456 DEBUG [AIF]: The AppRootFolder is set to: C:\Oracle\FDMEE
2014-07-03 21:00:18,457 DEBUG [AIF]: Comm.doScriptInit - END
2014-07-03 21:00:18,457 DEBUG [AIF]: Comm.executeScript - START
2014-07-03 21:00:18,457 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/BefProcLogicGrp.py
2014-07-03 21:00:18,458 DEBUG [AIF]: Comm.executeVBScript - START
2014-07-03 21:00:18,459 DEBUG [AIF]: The WindowsTempFolder is set to: c:\temp
2014-07-03 21:00:18,459 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\BefProcLogicGrp.vbs
2014-07-03 21:00:18,459 DEBUG [AIF]: Comm.executeVBScript - END
2014-07-03 21:00:18,459 DEBUG [AIF]: Comm.executeScript - END
2014-07-03 21:00:18,460 DEBUG [AIF]: CommData.getRuleInfo - START
2014-07-03 21:00:18,464 DEBUG [AIF]: CommData.getRuleInfo - START
2014-07-03 21:00:18,466 DEBUG [AIF]:
SELECT brl.RULE_ID
,br.RULE_NAME
,brl.PARTITIONKEY
,brl.CATKEY
,part.PARTVALGROUP
,br.SOURCE_SYSTEM_ID
,ss.SOURCE_SYSTEM_TYPE
,CASE
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'EBS%' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'PS%' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FUSION%' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FILE%' THEN 'N'
ELSE 'Y'
END SOURCE_ADAPTER_FLAG
,app.APPLICATION_ID
,app.TARGET_APPLICATION_NAME
,app.TARGET_APPLICATION_TYPE
,app.DATA_LOAD_METHOD
,brl.PLAN_TYPE
,CASE brl.PLAN_TYPE
WHEN 'PLAN1' THEN 1
WHEN 'PLAN2' THEN 2
WHEN 'PLAN3' THEN 3
WHEN 'PLAN4' THEN 4
WHEN 'PLAN5' THEN 5
ELSE 0
END PLAN_NUMBER
,br.INCL_ZERO_BALANCE_FLAG
,br.PERIOD_MAPPING_TYPE
,br.INCLUDE_ADJ_PERIODS_FLAG
,br.BALANCE_TYPE ACTUAL_FLAG
,br.AMOUNT_TYPE
,br.BALANCE_SELECTION
,br.BALANCE_METHOD_CODE
,COALESCE(br.SIGNAGE_METHOD, 'ABSOLUTE') SIGNAGE_METHOD
,br.CURRENCY_CODE
,br.BAL_SEG_VALUE_OPTION_CODE
,brl.EXECUTION_MODE
,COALESCE(brl.IMPORT_FROM_SOURCE_FLAG, 'Y') IMPORT_FROM_SOURCE_FLAG
,COALESCE(brl.RECALCULATE_FLAG, 'N') RECALCULATE_FLAG
,COALESCE(brl.EXPORT_TO_TARGET_FLAG, 'N') EXPORT_TO_TARGET_FLAG
,COALESCE(brl.CHECK_FLAG, 'N') CHECK_FLAG
,CASE
WHEN (br.LEDGER_GROUP_ID IS NOT NULL) THEN 'MULTI'
WHEN (br.SOURCE_LEDGER_ID IS NOT NULL) THEN 'SINGLE'
ELSE 'NONE'
END LEDGER_GROUP_CODE
,COALESCE(br.BALANCE_AMOUNT_BS, 'YTD') BALANCE_AMOUNT_BS
,COALESCE(br.BALANCE_AMOUNT_IS, 'PERIODIC') BALANCE_AMOUNT_IS
,br.LEDGER_GROUP
,(SELECT brd.DETAIL_CODE
FROM AIF_BAL_RULE_DETAILS brd
WHERE brd.RULE_ID = br.RULE_ID
AND brd.DETAIL_TYPE = 'LEDGER'
) PS_LEDGER
,CASE lg.LEDGER_TEMPLATE
WHEN 'COMMITMENT' THEN 'Y'
ELSE 'N'
END KK_FLAG
,p.LAST_UPDATED_BY
,p.AIF_WEB_SERVICE_URL WEB_SERVICE_URL
,p.EPM_ORACLE_INSTANCE
,brl.JOURNAL_FLAG
,br.MULTI_PERIOD_FILE_FLAG
,br.IMPGROUPKEY
FROM AIF_PROCESSES p
INNER JOIN AIF_BAL_RULE_LOADS brl
ON brl.LOADID = p.PROCESS_ID
INNER JOIN AIF_BALANCE_RULES br
ON br.RULE_ID = brl.RULE_ID
INNER JOIN AIF_SOURCE_SYSTEMS ss
ON ss.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID
INNER JOIN AIF_TARGET_APPLICATIONS app
ON app.APPLICATION_ID = brl.APPLICATION_ID
INNER JOIN TPOVPARTITION part
ON part.PARTITIONKEY = br.PARTITIONKEY
INNER JOIN TBHVIMPGROUP imp
ON imp.IMPGROUPKEY = part.PARTIMPGROUP
LEFT OUTER JOIN AIF_COA_LEDGERS l
ON l.SOURCE_SYSTEM_ID = p.SOURCE_SYSTEM_ID
AND l.SOURCE_LEDGER_ID = COALESCE(br.SOURCE_LEDGER_ID,imp.IMPSOURCELEDGERID)
LEFT OUTER JOIN AIF_PS_SET_CNTRL_REC_STG scr
ON scr.SOURCE_SYSTEM_ID = l.SOURCE_SYSTEM_ID
AND scr.SETCNTRLVALUE = l.SOURCE_LEDGER_NAME
AND scr.RECNAME = 'LED_GRP_TBL'
LEFT OUTER JOIN AIF_PS_LED_GRP_TBL_STG lg
ON lg.SOURCE_SYSTEM_ID = scr.SOURCE_SYSTEM_ID
AND lg.SETID = scr.SETID
AND lg.LEDGER_GROUP = br.LEDGER_GROUP
WHERE p.PROCESS_ID = 339
2014-07-03 21:00:18,469 DEBUG [AIF]:
SELECT adim.BALANCE_COLUMN_NAME DIMNAME
,adim.DIMENSION_ID
,dim.TARGET_DIMENSION_CLASS_NAME
,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1
,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID2) COA_SEGMENT_NAME2
,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID3) COA_SEGMENT_NAME3
,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID4) COA_SEGMENT_NAME4
,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID5) COA_SEGMENT_NAME5
,(SELECT CASE mdd.ORPHAN_OPTION_CODE
WHEN 'CHILD' THEN 'N'
WHEN 'ROOT' THEN 'N'
ELSE 'Y'
END DIMENSION_FILTER_FLAG
FROM AIF_MAP_DIM_DETAILS_V mdd
,AIF_MAPPING_RULES mr
WHERE mr.PARTITIONKEY = tpp.PARTITIONKEY
AND mdd.RULE_ID = mr.RULE_ID
AND mdd.DIMENSION_ID = adim.DIMENSION_ID
) DIMENSION_FILTER_FLAG
,tiie.IMPCONCATCHAR
FROM TPOVPARTITION tpp
INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim
ON adim.APPLICATION_ID = 18
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 = 22
AND adim.BALANCE_COLUMN_NAME IS NOT NULL
AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
ORDER BY adim.BALANCE_COLUMN_NAME
2014-07-03 21:00:18,471 DEBUG [AIF]: {'APPLICATION_ID': 18L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'POC9_DLR', 'ACTUAL_FLAG': u'A', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'C:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 7L, 'BAL_SEG_VALUE_OPTION_CODE': u'ALL', 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'EBS_R12', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'POC9', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 14L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2'], 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 113L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT1', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 110L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT5', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 112L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT3', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 108L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': u'SEGMENT2', 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 111L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 22L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'SINGLE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': u'SNAPSHOT', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 34L, 'BALANCE_AMOUNT_BS': u'PERIODIC', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': u'STANDARD', 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://epmvirtual:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI'}
2014-07-03 21:00:18,471 DEBUG [AIF]: CommData.getRuleInfo - END
2014-07-03 21:00:18,471 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
2014-07-03 21:00:18,472 DEBUG [AIF]: CommData.getRuleInfo - END
2014-07-03 21:00:18,472 DEBUG [AIF]: Comm.executeScript - START
2014-07-03 21:00:18,473 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/AftProcLogicGrp.py
2014-07-03 21:00:18,473 DEBUG [AIF]: Comm.executeVBScript - START
2014-07-03 21:00:18,473 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\AftProcLogicGrp.vbs
2014-07-03 21:00:18,473 DEBUG [AIF]: Comm.executeVBScript - END
2014-07-03 21:00:18,473 DEBUG [AIF]: Comm.executeScript - END
2014-07-03 21:00:18,473 DEBUG [AIF]: LogicGroup.createLogicAccounts - END
2014-07-03 21:00:18,490 DEBUG [AIF]: CommData.mapData - START
2014-07-03 21:00:18,490 DEBUG [AIF]: Comm.executeScript - START
2014-07-03 21:00:18,490 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE/data/scripts/event/BefProcMap.py
2014-07-03 21:00:18,490 DEBUG [AIF]: Comm.executeVBScript - START
2014-07-03 21:00:18,490 DEBUG [AIF]: The following script does not exist: C:\Oracle\FDMEE\data\scripts\event\BefProcMap.vbs
2014-07-03 21:00:18,490 DEBUG [AIF]: Comm.executeVBScript - END
2014-07-03 21:00:18,490 DEBUG [AIF]: Comm.executeScript - END
2014-07-03 21:00:18,490 DEBUG [AIF]: CommData.getRuleInfo - START
2014-07-03 21:00:18,490 DEBUG [AIF]:
SELECT brl.RULE_ID
,br.RULE_NAME
,brl.PARTITIONKEY
,brl.CATKEY
,part.PARTVALGROUP
,br.SOURCE_SYSTEM_ID
,ss.SOURCE_SYSTEM_TYPE
,CASE
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'EBS%' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'PS%' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FUSION%' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FILE%' THEN 'N'
ELSE 'Y'
END SOURCE_ADAPTER_FLAG
,app.APPLICATION_ID
,app.TARGET_APPLICATION_NAME
,app.TARGET_APPLICATION_TYPE
,app.DATA_LOAD_METHOD
,brl.PLAN_TYPE
,CASE brl.PLAN_TYPE
WHEN 'PLAN1' THEN 1
WHEN 'PLAN2' THEN 2
WHEN 'PLAN3' THEN 3
WHEN 'PLAN4' THEN 4
WHEN 'PLAN5' THEN 5
ELSE 0
END PLAN_NUMBER
,br.INCL_ZERO_BALANCE_FLAG
,br.PERIOD_MAPPING_TYPE
,br.INCLUDE_ADJ_PERIODS_FLAG
,br.BALANCE_TYPE ACTUAL_FLAG
,br.AMOUNT_TYPE
,br.BALANCE_SELECTION
,br.BALANCE_METHOD_CODE
,COALESCE(br.SIGNAGE_METHO