Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
FDMEE Jython Error
I need some assistance. I am new to Jython. We have a script we wrote where if certain accounts match then use the ICP partner else put everything to ICP None. This script is failing in Jython and I have gone through it numerous times. Here are the errors I am getting
#Purpose: To tag all intercompany accounts with corresponding ICP partners
str1 = ""
StrMain = ""
strDelim = "\t"
def PAR_ICP(strField, strRecord):
str1 = strRecord.split(strDelim)[1] #split take charater in 0 1 2 3 order
StrMain = str1[0:8]
if strMain in ("11100001","11100003","11100002", "11100006","11100007","11100010","11100011","11100012","11100014","11350001","11350002","15510001","15520004","25710001","25710002","25720001","25720002","25720003","25720004","25720005","30100003","31000001","31000002","31000008","31000022","70200003","70200007","70200008"):
return strField
else:
return "[ICP None]"
2015-11-03 12:24:35,289 INFO [AIF]: FDMEE Process Start, Process ID: 376
2015-11-03 12:24:35,289 INFO [AIF]: FDMEE Logging Level: 5
2015-11-03 12:24:35,289 INFO [AIF]: FDMEE Log File: \\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\outbox\logs\TEST_376.log
2015-11-03 12:24:35,290 INFO [AIF]: User:admin
2015-11-03 12:24:35,290 INFO [AIF]: Location:CORP_DOM_ACT (Partitionkey:32)
2015-11-03 12:24:35,290 INFO [AIF]: Period Name:SEP2015 (Period Key:9/30/15 12:00 AM)
2015-11-03 12:24:35,290 INFO [AIF]: Category Name:ACT (Category key:4)
2015-11-03 12:24:35,291 INFO [AIF]: Rule Name:test (Rule ID:3)
2015-11-03 12:24:36,868 INFO [AIF]: FDM Version: 11.1.2.4.000
2015-11-03 12:24:36,868 INFO [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)
[Oracle JRockit(R) (Oracle Corporation)]
2015-11-03 12:24:36,868 INFO [AIF]: Java Platform: java1.6.0_37
2015-11-03 12:24:36,868 INFO [AIF]: Log File Encoding: UTF-8
2015-11-03 12:24:38,832 INFO [AIF]: -------START IMPORT STEP-------
2015-11-03 12:24:38,918 DEBUG [AIF]: CommData.preImportData - START
2015-11-03 12:24:38,925 DEBUG [AIF]: CommData.getRuleInfo - START
2015-11-03 12:24:38,926 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 = 'FILE' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' 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 WHEN 'PLAN6' THEN 6 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 ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'NONE'
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, imp.IMPSOURCELEDGERID
,imp.IMPGROUPFILETYPE, imp.IMPTARGETSOURCESYSTEMID, imp.IMPSOURCECOAID, part.PARTTARGETAPPLICATIONID
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 = 376
2015-11-03 12:24:38,932 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 DISTINCT 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 = 20
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 = 32
AND adim.BALANCE_COLUMN_NAME IS NOT NULL
AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
ORDER BY adim.BALANCE_COLUMN_NAME
2015-11-03 12:24:38,934 DEBUG [AIF]: {'APPLICATION_ID': 20L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'test', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 4L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'TEST', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 7L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'CORP_DOM_ACT', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 165L}, 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': 162L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 159L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 164L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 166L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 161L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 163L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 32L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 3L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://orcl-hfm-dev01.mtvn.ad.viacom.com:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 20L, 'IMPTARGETSOURCESYSTEMID': 0L}
2015-11-03 12:24:38,934 DEBUG [AIF]: CommData.getRuleInfo - END
2015-11-03 12:24:38,938 DEBUG [AIF]: CommData.insertFilePeriods - START
2015-11-03 12:24:38,941 DEBUG [AIF]: doAppPeriodMappingsExist - TEST: Y
2015-11-03 12:24:38,941 DEBUG [AIF]:
select PERIODKEY,PERIODDESC,YEARTARGET,PERIODTARGET,FILE_NAME_STATIC,FILE_NAME_SUFFIX_TYPE,FILE_NAME_DATE_FORMAT,GL_EFFECTIVE_PERIOD_NUM
from (
SELECT pp.PERIODKEY
,pp.PERIODDESC
,pp.YEARTARGET YEARTARGET
,pp.PERIODTARGET PERIODTARGET
,brl.FILE_NAME_STATIC
,brl.FILE_NAME_SUFFIX_TYPE
,brl.FILE_NAME_DATE_FORMAT
,coalesce(brp.parameter_id,0) GL_EFFECTIVE_PERIOD_NUM
FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl
INNER JOIN TPOVCATEGORY pc
ON pc.CATKEY = brl.CATKEY
INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp
ON pp.PERIODFREQ = pc.CATFREQ
AND pp.INTSYSTEMKEY = 'TEST'
INNER JOIN AIF_BAL_RULE_LOAD_PARAMS brp
ON brp.loadid = brl.loadid
AND convert(varchar,brp.parameter_value,111) = pp.periodkey
WHERE brl.LOADID = 376
AND br.rule_id = brl.rule_id
AND br.MULTI_PERIOD_FILE_FLAG in ('T','H')
AND brp.parameter_name like 'AMOUNT%'
UNION
SELECT pp.PERIODKEY
,pp.PERIODDESC
,pp.YEARTARGET YEARTARGET
,pp.PERIODTARGET PERIODTARGET
,brl.FILE_NAME_STATIC
,brl.FILE_NAME_SUFFIX_TYPE
,brl.FILE_NAME_DATE_FORMAT
,0 GL_EFFECTIVE_PERIOD_NUM
FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl
INNER JOIN TPOVCATEGORY pc
ON pc.CATKEY = brl.CATKEY
INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp
ON pp.PERIODFREQ = pc.CATFREQ
AND pp.INTSYSTEMKEY = 'TEST'
AND pp.PERIODKEY >= brl.START_PERIODKEY
AND pp.PERIODKEY <= brl.END_PERIODKEY
WHERE brl.LOADID = 376
AND br.rule_id = brl.rule_id
AND br.MULTI_PERIOD_FILE_FLAG in( 'Y', 'X','E')
) qrslt
UNION
SELECT pp.PERIODKEY
,pp.PERIODDESC
,pp.YEARTARGET YEARTARGET
,pp.PERIODTARGET PERIODTARGET
,brl.FILE_NAME_STATIC
,brl.FILE_NAME_SUFFIX_TYPE
,brl.FILE_NAME_DATE_FORMAT
, 0 GL_EFFECTIVE_PERIOD_NUM
FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl
INNER JOIN TPOVCATEGORY pc
ON pc.CATKEY = brl.CATKEY
INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp
ON pp.PERIODFREQ = pc.CATFREQ
AND pp.INTSYSTEMKEY = 'TEST'
AND pp.PERIODKEY >= brl.START_PERIODKEY
AND pp.PERIODKEY <= brl.END_PERIODKEY
WHERE brl.LOADID = 376
AND (br.MULTI_PERIOD_FILE_FLAG is null or br.MULTI_PERIOD_FILE_FLAG = 'N' )
AND br.rule_id = brl.rule_id
ORDER BY PERIODKEY
2015-11-03 12:24:38,943 INFO [AIF]: File Name: HFM_Actual_201512_Version 5.TXT
2015-11-03 12:24:38,943 DEBUG [AIF]:
INSERT INTO AIF_PROCESS_PERIODS (
PROCESS_ID
,PERIODKEY
,ADJUSTMENT_PERIOD_FLAG
,GL_PERIOD_YEAR
,GL_PERIOD_CODE
,GL_PERIOD_NAME
,GL_PERIOD_NUM
,GL_EFFECTIVE_PERIOD_NUM
,YEARTARGET
,PERIODTARGET
,IMP_ENTITY_TYPE
,IMP_ENTITY_NAME
,TRANS_ENTITY_TYPE
,TRANS_ENTITY_NAME
,PRIOR_PERIOD_FLAG
) VALUES (376,'2015-09-30','N',0,'0' ,'0',0,1,'2015','SEP', 'PROCESS_BAL_IMP_FILE','HFM_Actual_201512_Version 5.TXT','PROCESS_BAL_TRANS','SEP2015','N' )
2015-11-03 12:24:38,945 DEBUG [AIF]: CommData.insertFilePeriods - END
2015-11-03 12:24:38,948 DEBUG [AIF]: CommData.getPovList - START
2015-11-03 12:24:38,948 DEBUG [AIF]:
SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY
,COALESCE(pp.PERIODDESC, CONVERT(VARCHAR,pprd.PERIODKEY,120)) PERIODDESC
,brl.RULE_ID, br.RULE_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG
FROM AIF_BAL_RULE_LOADS brl
INNER JOIN AIF_BALANCE_RULES br
ON br.RULE_ID = brl.RULE_ID
INNER JOIN TPOVPARTITION part
ON part.PARTITIONKEY = brl.PARTITIONKEY
INNER JOIN TPOVCATEGORY cat
ON cat.CATKEY = brl.CATKEY
INNER JOIN AIF_PROCESS_PERIODS pprd
ON pprd.PROCESS_ID = brl.LOADID
LEFT OUTER JOIN TPOVPERIODADAPTOR pp
ON pp.PERIODKEY = pprd.PERIODKEY
AND pp.INTSYSTEMKEY = 'TEST'
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 = 376
ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID
2015-11-03 12:24:38,949 DEBUG [AIF]: CommData.getPovList - END
2015-11-03 12:24:38,950 DEBUG [AIF]: CommData.insertImportProcessDetails - START
2015-11-03 12:24:38,951 DEBUG [AIF]:
INSERT INTO AIF_PROCESS_DETAILS (
PROCESS_ID
,ENTITY_TYPE
,ENTITY_ID
,ENTITY_NAME
,ENTITY_NAME_ORDER
,TARGET_TABLE_NAME
,EXECUTION_START_TIME
,EXECUTION_END_TIME
,RECORDS_PROCESSED
,STATUS
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
)
SELECT PROCESS_ID
,ENTITY_TYPE
,ENTITY_ID
,ENTITY_NAME
,ENTITY_NAME_ORDER
,'TDATASEG' TARGET_TABLE_NAME
,CURRENT_TIMESTAMP EXECUTION_START_TIME
,NULL EXECUTION_END_TIME
,0 RECORDS_PROCESSED
,'PENDING' STATUS
,'admin' LAST_UPDATED_BY
,CURRENT_TIMESTAMP LAST_UPDATE_DATE
FROM (
SELECT 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 = 376
) q
ORDER BY ENTITY_NAME_ORDER
2015-11-03 12:24:38,954 DEBUG [AIF]: CommData.insertImportProcessDetails - END
2015-11-03 12:24:38,960 DEBUG [AIF]: Comm.doScriptInit - START
2015-11-03 12:24:39,166 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=\\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\inbox, LOCNAME=CORP_DOM_ACT, SOURCENAME=File System, APPID=20, SOURCEID=7, APPROOTDIR=\\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST, IMPORTFORMAT=CORP_DOM_ACT, SCRIPTSDIR=\\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=3, CATNAME=ACT, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=376, PERIODNAME=SEP2015, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2015-09-30, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=TEST, FILENAME=HFM_Actual_201512_Version 5.TXT, LOCKEY=32, RULENAME=test, OUTBOXDIR=\\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=4, USERNAME=admin, FILEDIR=, IMPORTFLAG=Y, USERLOCALE=en}
2015-11-03 12:24:39,166 DEBUG [AIF]: The EpmOracleHome is set to: 
\Oracle\Middleware\EPMSystem11R1
2015-11-03 12:24:39,166 DEBUG [AIF]: The EpmOracleInstance is set to: \Oracle\Middleware\user_projects\epmsystem1
2015-11-03 12:24:39,167 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35
2015-11-03 12:24:39,167 DEBUG [AIF]: The executeEventScript is set to: YES
2015-11-03 12:24:39,167 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB
2015-11-03 12:24:39,167 DEBUG [AIF]: The AppRootFolder is set to: \\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST
2015-11-03 12:24:39,167 DEBUG [AIF]: Comm.doScriptInit - END
2015-11-03 12:24:39,167 DEBUG [AIF]: Comm.executeScript - START
2015-11-03 12:24:39,168 DEBUG [AIF]: The following script does not exist: \\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST/data/scripts/event/BefImport.py
2015-11-03 12:24:39,171 DEBUG [AIF]: Comm.executeVBScript - START
2015-11-03 12:24:39,171 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp
2015-11-03 12:24:39,171 DEBUG [AIF]: The following script does not exist: \\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\data\scripts\event\BefImport.vbs
2015-11-03 12:24:39,171 DEBUG [AIF]: Comm.executeVBScript - END
2015-11-03 12:24:39,172 DEBUG [AIF]: Comm.executeScript - END
2015-11-03 12:24:39,172 DEBUG [AIF]: CommData.preImportData - END
2015-11-03 12:24:42,821 DEBUG [AIF]: FileData.importData - START
2015-11-03 12:24:42,822 DEBUG [AIF]: Importing data for load id: 376
2015-11-03 12:24:42,823 DEBUG [AIF]: SELECT a.partitionkey,
a.catkey,
a.start_periodkey,
b.perioddesc,
coalesce(a.journal_flag,'N') JOURNAL_FLAG,
c.last_updated_by,
coalesce(a.FILE_NAME_STATIC,'') FILE_NAME_STATIC,
a.FILE_PATH,
a.RULE_ID,
a.application_id,
coalesce(br.MULTI_PERIOD_FILE_FLAG, 'N') MULTI_PERIOD_FILE_FLAG
FROM aif_bal_rule_loads a,
aif_balance_rules br,
tpovperiod b,
aif_processes c
WHERE a.loadid = 376
AND a.start_periodkey=b.periodkey
AND a.loadid =c.process_id
AND br.rule_id = a.rule_id
2015-11-03 12:24:42,825 DEBUG [AIF]: FileData.py: Importing Text data for load id: 376
2015-11-03 12:24:42,841 INFO [AIF]: EPMFDM-140274:Message - Log File Name ![:\](https://community.oracle.com/tech/resources/emoji/confused.png ":\"){kind=small}
\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\outbox\logs\TEST_376.log
2015-11-03 12:24:42,841 DEBUG [AIF]: EPMFDM-140274:Message - SELECT COALESCE(p.partitionkey,0) PARTITIONKEY,
COALESCE(brl.catkey,0) CATKEY,
COALESCE(p.rule_id,0) RULE_ID,
part.PARTCURRENCYKEY PARTCURRENCYKEY,
dir.FILE_PATH,
p.CLUSTER_NAME,
p.APPLICATION_ID
FROM aif_processes p,
aif_bal_rule_loads brl,
tpovpartition part,
(SELECT COALESCE(
(SELECT PROFILE_OPTION_VALUE
+ '/'
FROM AIF_PROFILE_OPTION_VALUES
WHERE PROFILE_OPTION_NAME = 'PROFILE_APP_ROOT_DIRECTORY'
AND LEVEL_ID = 1005
AND LEVEL_VALUE = brl.APPLICATION_ID
) ,COALESCE(
(SELECT PROFILE_OPTION_VALUE
+ '/'
FROM AIF_PROFILE_OPTION_VALUES
WHERE PROFILE_OPTION_NAME = 'PROFILE_APP_ROOT_DIRECTORY'
AND LEVEL_ID = 1000
) ,'' ) ,'' )
+ COALESCE(brl.FILE_PATH, '') FILE_PATH,
brl.LOADID
FROM AIF_BAL_RULE_LOADS brl
) dir
WHERE p.process_id = ?
AND p.process_id = dir.loadid
AND brl.loadid = p.process_id
AND part.partitionkey = p.partitionkey
2015-11-03 12:24:42,842 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH::376;32:4:3:[NONE]:\\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST/
2015-11-03 12:24:42,847 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8
2015-11-03 12:24:42,848 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start
2015-11-03 12:24:42,848 DEBUG [AIF]: EPMFDM-140274:Message - SELECT pp.PERIODKEY,
pp.PERIODTARGET,
pp.GL_PERIOD_NAME,
en.FILE_ENTITY_NAME,
en.ENTITY_NAME_ORDER,
br.MULTI_PERIOD_FILE_FLAG,
pp.TRANS_ENTITY_NAME,
pp.GL_PERIOD_YEAR_CHAR
FROM AIF_PROCESS_PERIODS pp,
AIF_BALANCE_RULES br,
AIF_PROCESSES p,
(SELECT DISTINCT entity_name FILE_ENTITY_NAME,
pd.process_id,
pd.entity_name_order
FROM aif_process_details pd
WHERE pd.entity_type = 'PROCESS_BAL_IMP_FILE'
AND pd.target_table_name = 'TDATASEG'
AND pd.status = 'PENDING'
) en
WHERE pp.PROCESS_ID = ?
AND p.process_id = pp.process_id
AND en.process_id = pp.process_id
AND pp.IMP_ENTITY_NAME = en.file_entity_name
AND br.rule_id = p.rule_id
AND en.entity_name_order = pp.GL_EFFECTIVE_PERIOD_NUM
AND ((br.MULTI_PERIOD_FILE_FLAG in ( 'Y','T','X','E','H') )
OR
(br.MULTI_PERIOD_FILE_FLAG is null OR br.MULTI_PERIOD_FILE_FLAG = 'N')
Answers
-
Hi,
What is the error you are seeing?
-
str1 = ""
StrMain = ""
def PAR_ICP(strField, strrecord):
str1 = strrecord.split("\t")
str2 = str1[1].strip()
StrMain = str2[0:8]
if (StrMain == '11100001' or StrMain == '11100003') Try this for all the other accounts
return strField
else:
return "[ICP None]"
-
This should work. Test it for 2 accounts and if it works you can include all other accounts.
-
str1 = ""
str2 = ""
StrMain = ""
def PAR_ICP(strField, strrecord):
str1 = strrecord.split("\t")
str2 = str1[1].strip()
StrMain = str2[0:8]
if (StrMain == '11100001' or StrMain == '11100003') Try this for all the other accounts
return strField
else:
return "[ICP None]"
-
I tried and still does not work. I am not able to even import the data file when I attach a script to any of the dimensions. For example I am attaching the script you advised and the one I had and whenever i attache the script, the import fails. When I take script out, it does not fail
HEre is the erros
2015-11-04 12:25:49,137 INFO [AIF]: FDMEE Process Start, Process ID: 383
2015-11-04 12:25:49,137 INFO [AIF]: FDMEE Logging Level: 5
2015-11-04 12:25:49,137 INFO [AIF]: FDMEE Log File: \\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\outbox\logs\TEST_383.log
2015-11-04 12:25:49,138 INFO [AIF]: User:admin
2015-11-04 12:25:49,138 INFO [AIF]: Location:CORP_DOM_ACT (Partitionkey:32)
2015-11-04 12:25:49,138 INFO [AIF]: Period Name:SEP2015 (Period Key:9/30/15 12:00 AM)
2015-11-04 12:25:49,139 INFO [AIF]: Category Name:ACT (Category key:4)
2015-11-04 12:25:49,139 INFO [AIF]: Rule Name:test (Rule ID:3)
2015-11-04 12:25:50,553 INFO [AIF]: FDM Version: 11.1.2.4.000
2015-11-04 12:25:50,553 INFO [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)
[Oracle JRockit(R) (Oracle Corporation)]
2015-11-04 12:25:50,553 INFO [AIF]: Java Platform: java1.6.0_37
2015-11-04 12:25:50,553 INFO [AIF]: Log File Encoding: UTF-8
2015-11-04 12:25:52,398 INFO [AIF]: -------START IMPORT STEP-------
2015-11-04 12:25:52,467 DEBUG [AIF]: CommData.preImportData - START
2015-11-04 12:25:52,473 DEBUG [AIF]: CommData.getRuleInfo - START
2015-11-04 12:25:52,475 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 = 'FILE' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' 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 WHEN 'PLAN6' THEN 6 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 ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'NONE'
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, imp.IMPSOURCELEDGERID
,imp.IMPGROUPFILETYPE, imp.IMPTARGETSOURCESYSTEMID, imp.IMPSOURCECOAID, part.PARTTARGETAPPLICATIONID
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 = 383
2015-11-04 12:25:52,480 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 DISTINCT 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 = 20
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 = 32
AND adim.BALANCE_COLUMN_NAME IS NOT NULL
AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
ORDER BY adim.BALANCE_COLUMN_NAME
2015-11-04 12:25:52,482 DEBUG [AIF]: {'APPLICATION_ID': 20L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'test', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 4L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'TEST', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 7L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'CORP_DOM_ACT', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 165L}, 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': 162L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 159L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 164L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 166L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 161L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 163L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 32L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 3L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://orcl-hfm-dev01.mtvn.ad.viacom.com:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 20L, 'IMPTARGETSOURCESYSTEMID': 0L}
2015-11-04 12:25:52,482 DEBUG [AIF]: CommData.getRuleInfo - END
2015-11-04 12:25:52,486 DEBUG [AIF]: CommData.insertFilePeriods - START
2015-11-04 12:25:52,490 DEBUG [AIF]: doAppPeriodMappingsExist - TEST: Y
2015-11-04 12:25:52,490 DEBUG [AIF]:
select PERIODKEY,PERIODDESC,YEARTARGET,PERIODTARGET,FILE_NAME_STATIC,FILE_NAME_SUFFIX_TYPE,FILE_NAME_DATE_FORMAT,GL_EFFECTIVE_PERIOD_NUM
from (
SELECT pp.PERIODKEY
,pp.PERIODDESC
,pp.YEARTARGET YEARTARGET
,pp.PERIODTARGET PERIODTARGET
,brl.FILE_NAME_STATIC
,brl.FILE_NAME_SUFFIX_TYPE
,brl.FILE_NAME_DATE_FORMAT
,coalesce(brp.parameter_id,0) GL_EFFECTIVE_PERIOD_NUM
FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl
INNER JOIN TPOVCATEGORY pc
ON pc.CATKEY = brl.CATKEY
INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp
ON pp.PERIODFREQ = pc.CATFREQ
AND pp.INTSYSTEMKEY = 'TEST'
INNER JOIN AIF_BAL_RULE_LOAD_PARAMS brp
ON brp.loadid = brl.loadid
AND convert(varchar,brp.parameter_value,111) = pp.periodkey
WHERE brl.LOADID = 383
AND br.rule_id = brl.rule_id
AND br.MULTI_PERIOD_FILE_FLAG in ('T','H')
AND brp.parameter_name like 'AMOUNT%'
UNION
SELECT pp.PERIODKEY
,pp.PERIODDESC
,pp.YEARTARGET YEARTARGET
,pp.PERIODTARGET PERIODTARGET
,brl.FILE_NAME_STATIC
,brl.FILE_NAME_SUFFIX_TYPE
,brl.FILE_NAME_DATE_FORMAT
,0 GL_EFFECTIVE_PERIOD_NUM
FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl
INNER JOIN TPOVCATEGORY pc
ON pc.CATKEY = brl.CATKEY
INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp
ON pp.PERIODFREQ = pc.CATFREQ
AND pp.INTSYSTEMKEY = 'TEST'
AND pp.PERIODKEY >= brl.START_PERIODKEY
AND pp.PERIODKEY <= brl.END_PERIODKEY
WHERE brl.LOADID = 383
AND br.rule_id = brl.rule_id
AND br.MULTI_PERIOD_FILE_FLAG in( 'Y', 'X','E')
) qrslt
UNION
SELECT pp.PERIODKEY
,pp.PERIODDESC
,pp.YEARTARGET YEARTARGET
,pp.PERIODTARGET PERIODTARGET
,brl.FILE_NAME_STATIC
,brl.FILE_NAME_SUFFIX_TYPE
,brl.FILE_NAME_DATE_FORMAT
, 0 GL_EFFECTIVE_PERIOD_NUM
FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl
INNER JOIN TPOVCATEGORY pc
ON pc.CATKEY = brl.CATKEY
INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp
ON pp.PERIODFREQ = pc.CATFREQ
AND pp.INTSYSTEMKEY = 'TEST'
AND pp.PERIODKEY >= brl.START_PERIODKEY
AND pp.PERIODKEY <= brl.END_PERIODKEY
WHERE brl.LOADID = 383
AND (br.MULTI_PERIOD_FILE_FLAG is null or br.MULTI_PERIOD_FILE_FLAG = 'N' )
AND br.rule_id = brl.rule_id
ORDER BY PERIODKEY
2015-11-04 12:25:52,491 INFO [AIF]: File Name: HFM_Actual_201512_Version (FDMEE).TXT
2015-11-04 12:25:52,492 DEBUG [AIF]:
INSERT INTO AIF_PROCESS_PERIODS (
PROCESS_ID
,PERIODKEY
,ADJUSTMENT_PERIOD_FLAG
,GL_PERIOD_YEAR
,GL_PERIOD_CODE
,GL_PERIOD_NAME
,GL_PERIOD_NUM
,GL_EFFECTIVE_PERIOD_NUM
,YEARTARGET
,PERIODTARGET
,IMP_ENTITY_TYPE
,IMP_ENTITY_NAME
,TRANS_ENTITY_TYPE
,TRANS_ENTITY_NAME
,PRIOR_PERIOD_FLAG
) VALUES (383,'2015-09-30','N',0,'0' ,'0',0,1,'2015','SEP', 'PROCESS_BAL_IMP_FILE','HFM_Actual_201512_Version (FDMEE).TXT','PROCESS_BAL_TRANS','SEP2015','N' )
2015-11-04 12:25:52,494 DEBUG [AIF]: CommData.insertFilePeriods - END
2015-11-04 12:25:52,496 DEBUG [AIF]: CommData.getPovList - START
2015-11-04 12:25:52,496 DEBUG [AIF]:
SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY
,COALESCE(pp.PERIODDESC, CONVERT(VARCHAR,pprd.PERIODKEY,120)) PERIODDESC
,brl.RULE_ID, br.RULE_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG
FROM AIF_BAL_RULE_LOADS brl
INNER JOIN AIF_BALANCE_RULES br
ON br.RULE_ID = brl.RULE_ID
INNER JOIN TPOVPARTITION part
ON part.PARTITIONKEY = brl.PARTITIONKEY
INNER JOIN TPOVCATEGORY cat
ON cat.CATKEY = brl.CATKEY
INNER JOIN AIF_PROCESS_PERIODS pprd
ON pprd.PROCESS_ID = brl.LOADID
LEFT OUTER JOIN TPOVPERIODADAPTOR pp
ON pp.PERIODKEY = pprd.PERIODKEY
AND pp.INTSYSTEMKEY = 'TEST'
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 = 383
ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID
2015-11-04 12:25:52,498 DEBUG [AIF]: CommData.getPovList - END
2015-11-04 12:25:52,499 DEBUG [AIF]: CommData.insertImportProcessDetails - START
2015-11-04 12:25:52,499 DEBUG [AIF]:
INSERT INTO AIF_PROCESS_DETAILS (
PROCESS_ID
,ENTITY_TYPE
,ENTITY_ID
,ENTITY_NAME
,ENTITY_NAME_ORDER
,TARGET_TABLE_NAME
,EXECUTION_START_TIME
,EXECUTION_END_TIME
,RECORDS_PROCESSED
,STATUS
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
)
SELECT PROCESS_ID
,ENTITY_TYPE
,ENTITY_ID
,ENTITY_NAME
,ENTITY_NAME_ORDER
,'TDATASEG' TARGET_TABLE_NAME
,CURRENT_TIMESTAMP EXECUTION_START_TIME
,NULL EXECUTION_END_TIME
,0 RECORDS_PROCESSED
,'PENDING' STATUS
,'admin' LAST_UPDATED_BY
,CURRENT_TIMESTAMP LAST_UPDATE_DATE
FROM (
SELECT 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 = 383
) q
ORDER BY ENTITY_NAME_ORDER
2015-11-04 12:25:52,501 DEBUG [AIF]: CommData.insertImportProcessDetails - END
2015-11-04 12:25:52,507 DEBUG [AIF]: Comm.doScriptInit - START
2015-11-04 12:25:52,631 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=\\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\inbox, LOCNAME=CORP_DOM_ACT, SOURCENAME=File System, APPID=20, SOURCEID=7, APPROOTDIR=\\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST, IMPORTFORMAT=CORP_DOM_ACT, SCRIPTSDIR=\\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=3, CATNAME=ACT, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=383, PERIODNAME=SEP2015, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2015-09-30, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=TEST, FILENAME=HFM_Actual_201512_Version (FDMEE).TXT, LOCKEY=32, RULENAME=test, OUTBOXDIR=\\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=4, USERNAME=admin, FILEDIR=, IMPORTFLAG=Y, USERLOCALE=en}
2015-11-04 12:25:52,631 DEBUG [AIF]: The EpmOracleHome is set to:
\Oracle\Middleware\EPMSystem11R12015-11-04 12:25:52,631 DEBUG [AIF]: The EpmOracleInstance is set to:
\Oracle\Middleware\user_projects\epmsystem12015-11-04 12:25:52,631 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35
2015-11-04 12:25:52,631 DEBUG [AIF]: The executeEventScript is set to: YES
2015-11-04 12:25:52,631 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB
2015-11-04 12:25:52,632 DEBUG [AIF]: The AppRootFolder is set to: \\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST
2015-11-04 12:25:52,632 DEBUG [AIF]: Comm.doScriptInit - END
2015-11-04 12:25:52,632 DEBUG [AIF]: Comm.executeScript - START
2015-11-04 12:25:52,632 DEBUG [AIF]: The following script does not exist: \\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST/data/scripts/event/BefImport.py
2015-11-04 12:25:52,635 DEBUG [AIF]: Comm.executeVBScript - START
2015-11-04 12:25:52,636 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp
2015-11-04 12:25:52,636 DEBUG [AIF]: The following script does not exist: \\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\data\scripts\event\BefImport.vbs
2015-11-04 12:25:52,636 DEBUG [AIF]: Comm.executeVBScript - END
2015-11-04 12:25:52,636 DEBUG [AIF]: Comm.executeScript - END
2015-11-04 12:25:52,636 DEBUG [AIF]: CommData.preImportData - END
2015-11-04 12:25:56,132 DEBUG [AIF]: FileData.importData - START
2015-11-04 12:25:56,132 DEBUG [AIF]: Importing data for load id: 383
2015-11-04 12:25:56,134 DEBUG [AIF]: SELECT a.partitionkey,
a.catkey,
a.start_periodkey,
b.perioddesc,
coalesce(a.journal_flag,'N') JOURNAL_FLAG,
c.last_updated_by,
coalesce(a.FILE_NAME_STATIC,'') FILE_NAME_STATIC,
a.FILE_PATH,
a.RULE_ID,
a.application_id,
coalesce(br.MULTI_PERIOD_FILE_FLAG, 'N') MULTI_PERIOD_FILE_FLAG
FROM aif_bal_rule_loads a,
aif_balance_rules br,
tpovperiod b,
aif_processes c
WHERE a.loadid = 383
AND a.start_periodkey=b.periodkey
AND a.loadid =c.process_id
AND br.rule_id = a.rule_id
2015-11-04 12:25:56,136 DEBUG [AIF]: FileData.py: Importing Text data for load id: 383
2015-11-04 12:25:56,151 INFO [AIF]: EPMFDM-140274:Message - Log File Name
\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\outbox\logs\TEST_383.log2015-11-04 12:25:56,151 DEBUG [AIF]: EPMFDM-140274:Message - SELECT COALESCE(p.partitionkey,0) PARTITIONKEY,
COALESCE(brl.catkey,0) CATKEY,
COALESCE(p.rule_id,0) RULE_ID,
part.PARTCURRENCYKEY PARTCURRENCYKEY,
dir.FILE_PATH,
p.CLUSTER_NAME,
p.APPLICATION_ID
FROM aif_processes p,
aif_bal_rule_loads brl,
tpovpartition part,
(SELECT COALESCE(
(SELECT PROFILE_OPTION_VALUE
+ '/'
FROM AIF_PROFILE_OPTION_VALUES
WHERE PROFILE_OPTION_NAME = 'PROFILE_APP_ROOT_DIRECTORY'
AND LEVEL_ID = 1005
AND LEVEL_VALUE = brl.APPLICATION_ID
) ,COALESCE(
(SELECT PROFILE_OPTION_VALUE
+ '/'
FROM AIF_PROFILE_OPTION_VALUES
WHERE PROFILE_OPTION_NAME = 'PROFILE_APP_ROOT_DIRECTORY'
AND LEVEL_ID = 1000
) ,'' ) ,'' )
+ COALESCE(brl.FILE_PATH, '') FILE_PATH,
brl.LOADID
FROM AIF_BAL_RULE_LOADS brl
) dir
WHERE p.process_id = ?
AND p.process_id = dir.loadid
AND brl.loadid = p.process_id
AND part.partitionkey = p.partitionkey
2015-11-04 12:25:56,152 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH::383;32:4:3:[NONE]:\\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST/
2015-11-04 12:25:56,159 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8
2015-11-04 12:25:56,159 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start
2015-11-04 12:25:56,160 DEBUG [AIF]: EPMFDM-140274:Message - SELECT pp.PERIODKEY,
pp.PERIODTARGET,
pp.GL_PERIOD_NAME,
en.FILE_ENTITY_NAME,
en.ENTITY_NAME_ORDER,
br.MULTI_PERIOD_FILE_FLAG,
pp.TRANS_ENTITY_NAME,
pp.GL_PERIOD_YEAR_CHAR
FROM AIF_PROCESS_PERIODS pp,
AIF_BALANCE_RULES br,
AIF_PROCESSES p,
(SELECT DISTINCT entity_name FILE_ENTITY_NAME,
pd.process_id,
pd.entity_name_order
FROM aif_process_details pd
WHERE pd.entity_type = 'PROCESS_BAL_IMP_FILE'
AND pd.target_table_name = 'TDATASEG'
AND pd.status = 'PENDING'
) en
WHERE pp.PROCESS_ID = ?
AND p.process_id = pp.process_id
AND en.process_id = pp.process_id
AND pp.IMP_ENTITY_NAME = en.file_entity_name
AND br.rule_id = p.rule_id
AND en.entity_name_order = pp.GL_EFFECTIVE_PERIOD_NUM
AND ((br.MULTI_PERIOD_FILE_FLAG in ( 'Y','T','X','E','H') )
OR
(br.MULTI_PERIOD_FILE_FLAG is null OR br.MULTI_PERIOD_FILE_FLAG = 'N')
)
ORDER BY en.entity_name_order
2015-11-04 12:25:56,161 DEBUG [AIF]: EPMFDM-140274:Message - update aif_process_details set status = ? , records_processed = ?, EXECUTION_END_TIME = CURRENT_TIMESTAMP where process_id = ? and entity_type = ? and entity_name = ?
2015-11-04 12:25:56,266 INFO [AIF]: EPMFDM-140274:Message - Log File Name
\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\outbox\logs\TEST_383.log2015-11-04 12:25:56,266 DEBUG [AIF]: EPMFDM-140274:Message - select 1 from aif_balance_rules br,aif_processes p where p.process_id = ? and p.rule_id = br.rule_id and br.multi_period_file_flag = 'Y'
2015-11-04 12:25:56,267 DEBUG [AIF]: EPMFDM-140274:Message - select ata.TARGET_APPLICATION_TYPE,ata.APPLICATION_NAME from aif_processes p inner join tpovpartition tpov on tpov.partitionkey = p.partitionkey and p.process_id=? left outer join AIF_TARGET_APPLICATIONS ata on ata.APPLICATION_ID = tpov.PARTSOURCEAPPLICATIONID
2015-11-04 12:25:56,268 DEBUG [AIF]: EPMFDM-140274:Message - SELECT impgroupkey,
impfldfieldname,
impfldfixedtext,
impfldstartpos,
impfldlength,
impfldsourcecolname,
impgroupfiletype,
impgroupdelimiter,
impseq,
LOG_SEQUENCE,
calc_seq
FROM
(SELECT fl.impgroupkey,
fl.impfldfieldname,
fl.impfldfixedtext,
fl.impfldstartpos,
fl.impfldlength,
fl.impfldsourcecolname,
ig.impgroupfiletype,
ig.impgroupdelimiter,
fl.impseq,
0 LOG_SEQUENCE,
COALESCE(calc_seq,0) CALC_SEQ
FROM
tbhvimpgroup ig,
tbhvimpitemfile fl,
AIF_TARGET_APPL_DIMENSIONS td,
aif_processes pr,
aif_bal_rule_loads brl
WHERE pr.process_id = ?
and pr.process_id = brl.loadid
and pr.application_id = brl.application_id
and pr.partitionkey = pr.partitionkey
AND ig.impgroupkey = brl.impgroupkey
AND ig.impgroupkey = fl.impgroupkey
AND td.application_id = ig.imptargetapplicationid
AND fl.impfldfieldname = td.balance_column_name
UNION ALL
SELECT fl.impgroupkey,
fl.impfldfieldname,
fl.impfldfixedtext,
fl.impfldstartpos,
fl.impfldlength,
fl.impfldsourcecolname,
ig.impgroupfiletype,
ig.impgroupdelimiter,
fl.impseq,
0 LOG_SEQUENCE,
-1 CALC_SEQ
FROM tbhvimpgroup ig,
tbhvimpitemfile fl,
aif_processes pr,
aif_bal_rule_loads brl
WHERE pr.process_id = ?
and pr.process_id = brl.loadid
and pr.application_id = brl.application_id
AND ig.impgroupkey = brl.impgroupkey
AND ig.impgroupkey = fl.impgroupkey
AND fl.impfldfieldname NOT IN
(SELECT td.balance_column_name
FROM AIF_TARGET_APPL_DIMENSIONS td
WHERE td.application_id = ig.imptargetapplicationid
AND fl.impfldfieldname = td.balance_column_name
)
) qrslt
ORDER BY calc_seq,
impseq
2015-11-04 12:25:56,269 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=5:SourceClName=Amount
2015-11-04 12:25:56,269 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DESC1:ImpFieldText=null:StartPos=3:SourceClName=Description
2015-11-04 12:25:56,270 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=2:SourceClName=Account
2015-11-04 12:25:56,270 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=1:SourceClName=UserDefined1
2015-11-04 12:25:56,270 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=Entity
2015-11-04 12:25:56,270 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=1:SourceClName=UserDefined2
2015-11-04 12:25:56,270 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ICP:ImpFieldText=Script=null.vbs:StartPos=4:SourceClName=IC Counter Party
2015-11-04 12:25:56,270 INFO [AIF]: EPMFDM-140274:Message - Instantiating JythonInterpreter
2015-11-04 12:25:56,405 INFO [AIF]: EPMFDM-140275:Message - Log File Name
\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\outbox\logs\TEST_383.log2015-11-04 12:25:56,407 DEBUG [AIF]: EPMFDM-140274:Message - Passing script file for execution to jython interpretor: \\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST/data/scripts/import/null.vbs
2015-11-04 12:25:56,408 INFO [AIF]: EPMFDM-140275:Message - Execute File: \\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST/data/scripts/import/null.vbs
2015-11-04 12:25:56,409 DEBUG [AIF]: EPMFDM-140275:Message - LOG_LEVEL: 5
2015-11-04 12:25:56,409 DEBUG [AIF]: EPMFDM-140275:Message - Script File encoding: UTF-8
2015-11-04 12:25:56,412 DEBUG [AIF]: EPMFDM-140275:Message - StrMain = Left(DW.Utilities.fParseString (strRecord,8,2,vbTab),8)
Select Case strMain
Case "11100001","11100003","11100002", "11100006","11100007","11100010","11100011","11100012","11100014","11350001","11350002","15510001","15520004","25710001","25710002","25720001","25720002","25720003","25720004","25720005","30100003","31000001","31000002","31000008","31000022","70200003","70200007","70200008"
COR_ICP = strField
Case Else
COR_ICP = "[ICP None]"
End Select
End Function
2015-11-04 12:25:56,413 ERROR [AIF]: EPMFDM-140275:Message - EPMFDM-140130:Error compiling the script.
null
2015-11-04 12:25:56,413 ERROR [AIF]: EPMFDM-140274:Message - SyntaxError: ("mismatched input 'Case' expecting NEWLINE", ('<string>', 2, 7, 'Select Case strMain\n'))
2015-11-04 12:25:56,414 DEBUG [AIF]: EPMFDM-140274:Message - update aif_process_details set status = ? , records_processed = ?, EXECUTION_END_TIME = CURRENT_TIMESTAMP where process_id = ? and entity_type = ? and entity_name = ?
2015-11-04 12:25:56,417 ERROR [AIF]: EPMFDM-140274:Message - EPMFDM-140274:Message - {0}
2015-11-04 12:25:56,419 FATAL [AIF]: Error in FileData.importData
Traceback (most recent call last):
File "<string>", line 84, in importData
RuntimeException: java.lang.RuntimeException: EPMFDM-140274:Message - {0}
2015-11-04 12:25:56,461 DEBUG [AIF]: CommData.postImportData - START
2015-11-04 12:25:56,467 DEBUG [AIF]: CommData.getRuleInfo - START
2015-11-04 12:25:56,467 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 = 'FILE' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' 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 WHEN 'PLAN6' THEN 6 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 ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'NONE'
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, imp.IMPSOURCELEDGERID
,imp.IMPGROUPFILETYPE, imp.IMPTARGETSOURCESYSTEMID, imp.IMPSOURCECOAID, part.PARTTARGETAPPLICATIONID
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 = 383
2015-11-04 12:25:56,473 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 DISTINCT 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 = 20
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 = 32
AND adim.BALANCE_COLUMN_NAME IS NOT NULL
AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
ORDER BY adim.BALANCE_COLUMN_NAME
2015-11-04 12:25:56,475 DEBUG [AIF]: {'APPLICATION_ID': 20L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'test', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 4L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'TEST', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 7L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'CORP_DOM_ACT', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 165L}, 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': 162L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 159L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 164L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 166L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 161L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 163L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 32L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 3L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://orcl-hfm-dev01.mtvn.ad.viacom.com:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 20L, 'IMPTARGETSOURCESYSTEMID': 0L}
2015-11-04 12:25:56,475 DEBUG [AIF]: CommData.getRuleInfo - END
2015-11-04 12:25:56,481 DEBUG [AIF]: CommData.updateTDATASEG_T - START
2015-11-04 12:25:56,483 DEBUG [AIF]: CommData.getLedgerListAndMap - START
2015-11-04 12:25:56,483 DEBUG [AIF]: CommData.getLedgerSQL - START
2015-11-04 12:25:56,484 DEBUG [AIF]: CommData.getLedgerSQL - END
2015-11-04 12:25:56,484 DEBUG [AIF]:
SELECT COALESCE(br.SOURCE_LEDGER_ID,0) SOURCE_LEDGER_ID
,NULL SOURCE_LEDGER_NAME
,NULL SOURCE_COA_ID
,br.CALENDAR_ID
,NULL SETID
,NULL PERIOD_TYPE
,NULL LEDGER_TABLE_NAME
FROM AIF_BALANCE_RULES br
WHERE br.RULE_ID = 3
2015-11-04 12:25:56,485 DEBUG [AIF]: CommData.getLedgerListAndMap - END
2015-11-04 12:25:56,487 DEBUG [AIF]: CommData.getPovList - START
2015-11-04 12:25:56,490 DEBUG [AIF]: doAppPeriodMappingsExist - TEST: Y
2015-11-04 12:25:56,490 DEBUG [AIF]:
SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY
,COALESCE(pp.PERIODDESC, CONVERT(VARCHAR,pprd.PERIODKEY,120)) PERIODDESC
,brl.RULE_ID, br.RULE_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG
FROM AIF_BAL_RULE_LOADS brl
INNER JOIN AIF_BALANCE_RULES br
ON br.RULE_ID = brl.RULE_ID
INNER JOIN TPOVPARTITION part
ON part.PARTITIONKEY = brl.PARTITIONKEY
INNER JOIN TPOVCATEGORY cat
ON cat.CATKEY = brl.CATKEY
INNER JOIN AIF_PROCESS_PERIODS pprd
ON pprd.PROCESS_ID = brl.LOADID
LEFT OUTER JOIN TPOVPERIODADAPTOR pp
ON pp.PERIODKEY = pprd.PERIODKEY
AND pp.INTSYSTEMKEY = 'TEST'
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 = 383
ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID
2015-11-04 12:25:56,491 DEBUG [AIF]: CommData.getPovList - END
2015-11-04 12:25:56,491 DEBUG [AIF]: SELECT pp.PERIODKEY
FROM AIF_PROCESS_PERIODS pp,
(SELECT entity_name FILE_ENTITY_NAME,
pd.process_id,pd.entity_name_order
FROM aif_process_details pd
WHERE pd.entity_type = 'PROCESS_BAL_IMP_FILE'
AND pd.target_table_name = 'TDATASEG'
AND pd.status = 'FAILED'
) en
WHERE pp.PROCESS_ID = 383
AND en.process_id = pp.process_id
AND pp.IMP_ENTITY_NAME = en.file_entity_name
order by en.entity_name_order
2015-11-04 12:25:56,494 INFO [AIF]:
Import Data from Source for Period 'SEP2015'
2015-11-04 12:25:56,498 DEBUG [AIF]: CommData.updateWorkflow - START
2015-11-04 12:25:56,499 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 = 32
AND tlp.CATKEY = 4
AND tlp.PERIODKEY = '2015-09-30'
AND tlp.RULE_ID = 3
AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS
2015-11-04 12:25:56,500 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 = 32 AND CATKEY = 4 AND PERIODKEY = '2015-09-30' AND RULE_ID = 3
2015-11-04 12:25:56,517 DEBUG [AIF]: CommData.updateWorkflow - END
2015-11-04 12:25:56,558 FATAL [AIF]: Error in CommData.updateTDATASEG_T
Traceback (most recent call last):
File "<string>", line 1010, in updateTDATASEG_T
Import Error
2015-11-04 12:25:56,560 DEBUG [AIF]: CommData.updateWorkflow - START
2015-11-04 12:25:56,560 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME = CURRENT_TIMESTAMP
,PROCESSSTATUS = 2
,PROCESSIMP = 0
,BLNWCDIRTY = 0
,BLNLOGICDIRTY = 0
,BLNVALDIRTY = 0
,PROCESSIMPNOTE = 'AIF_WF_IMP_IMPORT_ERR'
WHERE PARTITIONKEY = 32 AND CATKEY = 4 AND PERIODKEY = '2015-09-30' AND RULE_ID = 3
2015-11-04 12:25:56,562 DEBUG [AIF]: CommData.updateWorkflow - END
2015-11-04 12:25:56,609 DEBUG [AIF]: Comm.doScriptInit - START
2015-11-04 12:25:56,730 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=\\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\inbox, LOCNAME=CORP_DOM_ACT, SOURCENAME=File System, APPID=20, SOURCEID=7, APPROOTDIR=\\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST, IMPORTFORMAT=CORP_DOM_ACT, SCRIPTSDIR=\\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=3, CATNAME=ACT, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=383, PERIODNAME=SEP2015, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2015-09-30, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=TEST, FILENAME=HFM_Actual_201512_Version (FDMEE).TXT, LOCKEY=32, RULENAME=test, OUTBOXDIR=\\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=4, USERNAME=admin, FILEDIR=, IMPORTFLAG=Y, USERLOCALE=en}
2015-11-04 12:25:56,730 DEBUG [AIF]: The EpmOracleHome is set to:
\Oracle\Middleware\EPMSystem11R12015-11-04 12:25:56,730 DEBUG [AIF]: The EpmOracleInstance is set to:
\Oracle\Middleware\user_projects\epmsystem12015-11-04 12:25:56,730 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35
2015-11-04 12:25:56,730 DEBUG [AIF]: The executeEventScript is set to: YES
2015-11-04 12:25:56,730 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB
2015-11-04 12:25:56,731 DEBUG [AIF]: The AppRootFolder is set to: \\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST
2015-11-04 12:25:56,731 DEBUG [AIF]: Comm.doScriptInit - END
2015-11-04 12:25:56,731 DEBUG [AIF]: Comm.executeScript - START
2015-11-04 12:25:56,731 DEBUG [AIF]: The following script does not exist: \\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST/data/scripts/event/AftImport.py
2015-11-04 12:25:56,735 DEBUG [AIF]: Comm.executeVBScript - START
2015-11-04 12:25:56,735 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp
2015-11-04 12:25:56,735 DEBUG [AIF]: The following script does not exist: \\orcl-hfm-dev01\d$\Oracle\Middleware\user_projects\domains\EPMSystem\fdmee\TEST\data\scripts\event\AftImport.vbs
2015-11-04 12:25:56,735 DEBUG [AIF]: Comm.executeVBScript - END
2015-11-04 12:25:56,735 DEBUG [AIF]: Comm.executeScript - END
2015-11-04 12:25:56,814 FATAL [AIF]: Error in COMM Post Import Data
2015-11-04 12:25:56,918 INFO [AIF]: FDMEE Process End, Process ID: 383
-
You cannot execute import script in vb mode. Please use jython for this. Your syntax is in vb mode and it will not work. Only for event script you can use vbs. Change your code to jython py format then execute it. Please check indentation.
Script File encoding: UTF-8
2015-11-04 12:25:56,412 DEBUG [AIF]: EPMFDM-140275:Message - StrMain = Left(DW.Utilities.fParseString (strRecord,8,2,vbTab),8)
Select Case strMain
Case "11100001","11100003","11100002", "11100006","11100007","11100010","11100011","11100012","11100014","11350001","11350002","15510001","15520004","25710001","25710002","25720001","25720002","25720003","25720004","25720005","30100003","31000001","31000002","31000008","31000022","70200003","70200007","70200008"
COR_ICP = strField
Case Else
COR_ICP = "[ICP None]"
End Select
End Function
2015-11-04 12:25:56,413 ERROR [AIF]: EPMFDM-140275:Message - EPMFDM-140130:Error compiling the script.
null
2015-11-04 12:25:56,413 ERROR [AIF]: EPMFDM-140274:Message - SyntaxError: ("mismatched input 'Case' expecting NEWLINE", ('<string>', 2, 7, 'Select Case strMain\n'))
2015-11-04 12:25:56,414 DEBUG [AIF]: EPMFDM-140274:Message - update aif_process_details set status = ? , records_processed = ?, EXECUTION_END_TIME = CURRENT_TIMESTAMP where process_id = ? and entity_type = ? and entity_name = ?
2015-11-04 12:25:56,417 ERROR [AIF]: EPMFDM-140274:Message - EPMFDM-140274:Message - {0}
2015-11-04 12:25:56,419 FATAL [AIF]: Error in FileData.importData
Traceback (most recent call last):
File "<string>", line 84, in importData
RuntimeException: java.lang.RuntimeException: EPMFDM-140274:Message - {0}
-
Why are you doing this in an import script? It could be handled in a multi-dimensional mapping.
-
can you advise more. Our main scope is to only let the accounts identified as ICP be mapped to specific ICP target identified in the mapping table and all else to ICP NONE.