Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to map the period dimension in Data Management

Priyanka MuttannavarNov 6 2017 — edited Nov 17 2017

Hi,

we are working on writing back EPM cloud Budget Balances to the Budgetary Control in this process we have mapped period mapping with Budgetary Control both in Global and Application Mapping but once we execute the rule it will be running with warnings. As we have mapped the periods correctly but still we are unable to export the balances.

we have a budget balances in Total_Year Period in pbcs but in the ERP we have period called PRD_01-02 both the periods we mapped in period mapping but no luck.

And we have defined periods separately in source mapping as well but its not taking that source periods only taking Application mapping periods.

once the Rule executes it will be executed with warnings, below is my log.

2017-11-06 07:13:23,999 INFO [AIF]: FDMEE Process: 856, Log Level: 5

2017-11-06 07:13:23,999 INFO [AIF]: Location : Export-PBCS to BC (Partitionkey:31)

2017-11-06 07:13:23,999 INFO [AIF]: Period Name : PRD_01-02 (Period Key:3/31/18 12:00 AM)

2017-11-06 07:13:23,999 INFO [AIF]: Category Name: Budget (Category key:3)

2017-11-06 07:13:23,999 INFO [AIF]: Rule Name : Export-PBCS to BC (Rule ID:46)

2017-11-06 07:13:25,564 INFO [AIF]: FDM Version: 11.1.2.4.220

2017-11-06 07:13:25,564 INFO [AIF]: Log File Encoding: UTF-8

2017-11-06 07:13:26,508 INFO [AIF]: -------START IMPORT STEP-------

2017-11-06 07:13:26,640 DEBUG [AIF]: CommData.preImportData - START

2017-11-06 07:13:26,640 DEBUG [AIF]: CommData.getRuleInfo - START

2017-11-06 07:13:26,643 DEBUG [AIF]:

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

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

FROM TPOVPARTITION tpp

INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

ON adim.APPLICATION_ID = 38

LEFT OUTER JOIN TBHVIMPITEMERPI tiie

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

WHERE tpp.PARTITIONKEY = 31

AND adim.BALANCE_COLUMN_NAME IS NOT NULL

AND adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

ORDER BY adim.BALANCE_COLUMN_NAME

2017-11-06 07:13:26,644 DEBUG [AIF]: {'EXPORT_TO_TARGET_FLAG': u'N', 'PLAN_NUMBER': 0L, 'SRC_TARGET_APP_NAME': u'BVBudget', 'JOURNAL_FLAG': None, 'DIMNAME_MAP': {u'UD1': {'DIMNAME': u'UD1', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD3': {'DIMNAME': u'UD3', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'ACCOUNT': {'DIMNAME': u'ACCOUNT', 'TARGET_DIMENSION_CLASS_NAME': u'Account'}}, 'CATKEY': 3L, 'TGT_APP_SUB_TYPE': u'FUSION', 'TGT_APP_ID': 38L, 'DIMNAME_LIST': [u'ACCOUNT', u'UD1', u'UD3'], 'SRC_SOURCE_SYSTEM_ID': 0L, 'TGT_SOURCE_SYSTEM_TYPE': u'FUSION_GL_CLOUD', 'TGT_APP_TYPE': u'ESSBASE', 'CALENDAR_ID': None, 'TGT_TARGET_APP_NAME': u'XCC_BVBudget7_2', 'PARTITIONKEY': 31L, 'EXECUTION_MODE': u'REPLACE', 'LEDGER_GROUP_CODE': u'NONE', 'PS_LEDGER': None, 'SRC_DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTVALGROUP': u'[NONE]', 'WEB_SERVICE_URL': u'http://ap1pbcsr302111.audc1.oraclecloud.com:9000/aif', 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'IS_INCREMENTAL_LOAD': False, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'SRC_APP_NAME': u'BVBudget', 'FCI_FLAG': 'N', 'KK_FLAG': u'N', 'LAST_UPDATED_BY': u'raghunandan.rao@bharatividyapeeth.edu', 'CHECK_FLAG': u'N', 'RULE_ID': 46L, 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SRC_APP_ID': u'4', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'IMPGROUPKEY': u'Export-PBCS to BC', 'TGT_SOURCE_SYSTEM_ID': 19L, 'SRC_APP_TYPE': u'HPL', 'TGT_APP_NAME': u'XCC_BVBudget7_2', 'IMPGROUPFILETYPE': u'EPM_EPM', 'LEDGER_GROUP': None, 'TGT_COA_ID': 0L, 'SOURCE_ADAPTER_FLAG': u'N', 'RECALCULATE_FLAG': u'Y', 'TGT_DATA_LOAD_METHOD': u'FUSION_GL_CLOUD', 'SRC_SOURCE_SYSTEM_TYPE': u'EPM', 'PLAN_TYPE': None}

2017-11-06 07:13:26,645 DEBUG [AIF]: {u'AccountingPeriod': {'BCN': None, 'DCN': u'Period'}, u'COURSE': {'BCN': u'UD1', 'DCN': u'Generic'}, u'Control Budget': {'BCN': u'ACCOUNT', 'DCN': u'Account'}, u'ACCOUNT': {'BCN': u'UD3', 'DCN': u'Generic'}, u'Balance Amount': {'BCN': None, 'DCN': u'Generic'}, u'Amount Type': {'BCN': None, 'DCN': u'Generic'}}

2017-11-06 07:13:26,646 DEBUG [AIF]: {u'UD1': {'IMPFLDSOURCECOLNAME': u'Entity'}, u'UD3': {'IMPFLDSOURCECOLNAME': u'Account'}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': u'Version'}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': u'Amount'}}

2017-11-06 07:13:26,646 DEBUG [AIF]: CommData.getRuleInfo - END

2017-11-06 07:13:26,647 DEBUG [AIF]: CommData.insertEpmPeriods - START

2017-11-06 07:13:26,648 DEBUG [AIF]: doAppPeriodMappingsExist - XCC_BVBudget7_2: Y

2017-11-06 07:13:26,648 DEBUG [AIF]: doAppPeriodMappingsExist - BVBudget: Y

2017-11-06 07:13:26,648 DEBUG [AIF]: Period mapping section: DEFAULT

2017-11-06 07:13:26,649 DEBUG [AIF]:

INSERT INTO AIF_PROCESS_PERIODS (

PROCESS_ID, PERIODKEY, ADJUSTMENT_PERIOD_FLAG, GL_PERIOD_YEAR, GL_PERIOD_YEAR_CHAR, GL_PERIOD_NUM, GL_PERIOD_NAME, GL_PERIOD_CODE

,GL_EFFECTIVE_PERIOD_NUM, YEARTARGET, PERIODTARGET, IMP_ENTITY_TYPE, IMP_ENTITY_NAME, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME, PRIOR_PERIOD_FLAG

)

SELECT DISTINCT brl.LOADID PROCESS_ID

,tpp.PERIODKEY PERIODKEY

,'N' ADJUSTMENT_PERIOD_FLAG

,0 GL_PERIOD_YEAR

,spp.YEARTARGET GL_PERIOD_YEAR_CHAR

,0 GL_PERIOD_NUM

,spp.PERIODTARGET GL_PERIOD_NAME

,spp.PERIODKEY GL_PERIOD_CODE

,0 GL_EFFECTIVE_PERIOD_NUM

,tpp.YEARTARGET YEARTARGET

,tpp.PERIODTARGET PERIODTARGET

,'PROCESS_BAL_IMP_FILE' IMP_ENTITY_TYPE

,'BVBudget_856.dat'

,'PROCESS_BAL_TRANS' TRANS_ENTITY_TYPE

,tpp.PERIODDESC TRANS_ENTITY_NAME

,'N' PRIOR_PERIOD_FLAG

FROM (

AIF_BAL_RULE_LOADS brl

INNER JOIN TPOVCATEGORY pc

ON pc.CATKEY = brl.CATKEY

INNER JOIN TPOVPERIODADAPTOR_FLAT_V tpp

ON tpp.PERIODFREQ = pc.CATFREQ

AND tpp.PERIODKEY >= brl.START_PERIODKEY

AND tpp.PERIODKEY <= brl.END_PERIODKEY

AND tpp.INTSYSTEMKEY = 'XCC_BVBudget7_2'

)

INNER JOIN TPOVPERIODADAPTOR_FLAT_V spp

ON spp.PERIODFREQ = pc.CATFREQ

AND spp.PERIODKEY > tpp.PRIORPERIODKEY

AND spp.PERIODKEY <= tpp.PERIODKEY

AND spp.INTSYSTEMKEY = 'BVBudget'

WHERE brl.LOADID = 856

ORDER BY tpp.PERIODKEY, spp.PERIODKEY

2017-11-06 07:13:26,649 DEBUG [AIF]: periodSQL - periodParams: [u'BVBudget_856.dat', u'XCC_BVBudget7_2', u'BVBudget', 856]

2017-11-06 07:13:26,651 DEBUG [AIF]: insertRowCount: 5

2017-11-06 07:13:26,652 DEBUG [AIF]: CommData.insertEpmPeriods - END

2017-11-06 07:13:26,652 DEBUG [AIF]: CommData.updateBalRuleLoadParams - START

2017-11-06 07:13:26,655 DEBUG [AIF]: yearDimensionName=Years, yearFilter="FY18"

2017-11-06 07:13:26,655 DEBUG [AIF]: periodDimensionName=Period, periodFilter="FY18"

2017-11-06 07:13:26,657 DEBUG [AIF]: CommData.updateBalRuleLoadParams - END

2017-11-06 07:13:26,657 DEBUG [AIF]: CommData.getPovList - START

2017-11-06 07:13:26,657 DEBUG [AIF]:

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

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

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

FROM AIF_BAL_RULE_LOADS brl

INNER JOIN AIF_BALANCE_RULES br

ON br.RULE_ID = brl.RULE_ID

INNER JOIN TPOVPARTITION part

ON part.PARTITIONKEY = brl.PARTITIONKEY

INNER JOIN TPOVCATEGORY cat

ON cat.CATKEY = brl.CATKEY

INNER JOIN AIF_PROCESS_PERIODS pprd

ON pprd.PROCESS_ID = brl.LOADID

LEFT OUTER JOIN TPOVPERIODADAPTOR pp

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

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

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

2017-11-06 07:13:26,658 DEBUG [AIF]: CommData.getPovList - END

2017-11-06 07:13:26,658 DEBUG [AIF]: Comm.doScriptInit - START

2017-11-06 07:13:26,699 DEBUG [AIF]: fdmContext: {PERIODKEY=2018-03-31, CATKEY=3, APPNAME=XCC_BVBudget7_2, EXPORTFLAG=N, SOURCEID=0, TARGETAPPNAME=XCC_BVBudget7_2, USERLOCALE=en, IMPORTFLAG=Y, SCRIPTSDIR=/u03/inbox/data/scripts, SOURCENAME=EPM, PERIODNAME=PRD_01-02, BATCHSCRIPTDIR=/u02/user_projects/instance0/FinancialDataQuality, LOCNAME=Export-PBCS to BC, USERNAME=raghunandan.rao@bharatividyapeeth.edu, APPROOTDIR=/u03/inbox, EPMORACLEHOME=/u02/Oracle/Middleware/EPMSystem11R1, TARGETAPPTYPE=ESSBASE, OUTBOXDIR=/u03/inbox/outbox, TARGETAPPDB=db, FILEDIR=inbox, APPID=38, MULTIPERIODLOAD=N, LOADID=856, RULEID=46, IMPORTMODE=REPLACE, SOURCETYPE=EPM, CATNAME=Budget, RULENAME=Export-PBCS to BC, LOCKEY=31, EXPORTMODE=null, INBOXDIR=/u03/inbox/inbox, EPMORACLEINSTANCEHOME=/u02/user_projects/instance0, IMPORTFORMAT=Export-PBCS to BC}

2017-11-06 07:13:26,702 DEBUG [AIF]: The executeEventScript is set to: NO

2017-11-06 07:13:26,702 DEBUG [AIF]: The AppRootFolder is set to: /u03/inbox

2017-11-06 07:13:26,702 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

2017-11-06 07:13:26,702 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

2017-11-06 07:13:26,702 DEBUG [AIF]: Comm.doScriptInit - END

2017-11-06 07:13:26,702 DEBUG [AIF]: CommData.preImportData - END

2017-11-06 07:13:26,740 DEBUG [AIF]: CommData.extractDataFromSource - START

2017-11-06 07:13:26,740 DEBUG [AIF]: AIFUtil.callOdiServlet - START

2017-11-06 07:13:26,753 INFO [AIF]: EssbaseService.extractData - START

2017-11-06 07:13:26,785 DEBUG [AIF]: appId:38, appType:HPL, mcFlag:false, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL, textDataLoad:N, isFccsLoad:false, isJournalLoad:false

2017-11-06 07:13:26,785 DEBUG [AIF]: LOAD_METHOD:ESSFILE, LOAD_TYPE:DATA, EXPORT_MODE:STORE_DATA, CREATE_DRILL_REGION:false, PURGE_DATA_FILE:false, EXPORT_FILE_DELIMITER:comma, BATCH_SIZE:10000

2017-11-06 07:13:26,846 INFO [AIF]: cloudServiceType: Planning, Resolved user name for application access: epm_default_cloud_admin

2017-11-06 07:13:26,846 DEBUG [AIF]: We need to connect to Essbase server.

2017-11-06 07:13:26,893 DEBUG [AIF]: Extracting data from BVBudget:Budget...

2017-11-06 07:13:26,935 INFO [AIF]: Extract Script (Calc): SET DataExportOptions

{

DATAEXPORTCOLFORMAT ON;

DATAEXPORTDIMHEADER ON;

DATAEXPORTDRYRUN OFF;

DataExportRelationalFile OFF;

DataExportNonExistingBlocks OFF;

DataExportLevel ALL;

DATAEXPORTCOLHEADER "Period";

DATAEXPORTOVERWRITEFILE ON;

DataExportDynamicCalc OFF;

};

FIX (@Relative("40000000",0),"21001","FY18","Budget","Working","FY18")

DATAEXPORT "File" "," "/u03/inbox/data/BVBudget_Budget_856.txt" "#";

ENDFIX

2017-11-06 07:13:26,951 INFO [AIF]: List of exported files to be merged from dir /u03/inbox/data for file name BVBudget_Budget_856*

2017-11-06 07:13:26,960 INFO [AIF]: Number of files to be merged: 1

2017-11-06 07:13:26,969 INFO [AIF]: EssbaseService.extractData - END (true)

2017-11-06 07:13:26,977 DEBUG [AIF]: AIFUtil.callOdiServlet - END

2017-11-06 07:13:26,978 DEBUG [AIF]: CommData.extractDataFromSource - END

2017-11-06 07:13:27,001 DEBUG [AIF]: CommData.insertImportProcessDetails - START

2017-11-06 07:13:27,001 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, 'raghunandan.rao@bharatividyapeeth.edu' 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 = 856

) q

ORDER BY ENTITY_NAME_ORDER

2017-11-06 07:13:27,017 DEBUG [AIF]: CommData.insertImportProcessDetails - END

2017-11-06 07:13:27,037 DEBUG [AIF]: FileData.importData - START

2017-11-06 07:13:27,037 DEBUG [AIF]: Importing data for load id: 856

2017-11-06 07:13:27,038 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

FROM aif_bal_rule_loads a,

aif_balance_rules br,

tpovperiodadaptor b,

aif_processes c

WHERE a.loadid = 856

AND a.start_periodkey=b.periodkey

AND a.loadid =c.process_id

AND br.rule_id = a.rule_id

AND b.INTSYSTEMKEY = 'XCC_BVBudget7_2'

2017-11-06 07:13:27,040 DEBUG [AIF]: FileData.py: Importing Text data for load id: 856

2017-11-06 07:13:27,098 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH:IMPGROUPFILETYPE::856;31:3:46:INR:/u03/inbox/data:EPM_EPM

2017-11-06 07:13:27,102 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8

2017-11-06 07:13:27,102 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start

2017-11-06 07:13:27,102 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,

pp.GL_PERIOD_NUM ,

pp.YEARTARGET

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

ORDER BY en.entity_name_order

2017-11-06 07:13:27,138 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=1:SourceClName=Amount

2017-11-06 07:13:27,138 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=1:SourceClName=Account

2017-11-06 07:13:27,138 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=Version

2017-11-06 07:13:27,138 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=1:SourceClName=Entity

2017-11-06 07:13:27,139 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps

2017-11-06 07:13:27,139 INFO [AIF]: EPMFDM-140274:Message - File Name BVBudget_856.dat

periodKey2018-03-31

2017-11-06 07:13:27,139 INFO [AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM() HPL

2017-11-06 07:13:27,139 DEBUG [AIF]: BOM exists

2017-11-06 07:13:27,139 DEBUG [AIF]: After removing BOM ["Years","Scenario","Version","Entity","Account","Period"]

2017-11-06 07:13:27,139 DEBUG [AIF]: EPMFDM-140274:Message - HEADER: ["Years", "Scenario", "Version", "Entity", "Account", "Period"]

2017-11-06 07:13:27,142 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CURKEY:ImpFieldText=null:StartPos=1:SourceClName=Currency

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40101001",#,#,#,#,#,#,#,#,#,#,#,#,#,1200]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40101010",#,#,#,#,#,#,#,#,#,#,#,#,#,160185300]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40102006",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40102007",#,#,#,#,#,#,#,#,#,#,#,#,#,48909800]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40103001",#,#,#,#,#,#,#,#,#,#,#,#,#,3507000]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40104001",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201001",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201003",#,#,#,#,#,#,#,#,#,#,#,#,#,90000]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201004",#,#,#,#,#,#,#,#,#,#,#,#,#,75000]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201005",#,#,#,#,#,#,#,#,#,#,#,#,#,7500000]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201006",#,#,#,#,#,#,#,#,#,#,#,#,#,41379700]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201007",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201008",#,#,#,#,#,#,#,#,#,#,#,#,#,3250000]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201009",#,#,#,#,#,#,#,#,#,#,#,#,#,400000]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201010",#,#,#,#,#,#,#,#,#,#,#,#,#,10000000]

2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201011",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201013",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201014",#,#,#,#,#,#,#,#,#,#,#,#,#,250000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201015",#,#,#,#,#,#,#,#,#,#,#,#,#,0]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201016",#,#,#,#,#,#,#,#,#,#,#,#,#,1350000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201017",#,#,#,#,#,#,#,#,#,#,#,#,#,1000000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201018",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201019",#,#,#,#,#,#,#,#,#,#,#,#,#,400000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201020",#,#,#,#,#,#,#,#,#,#,#,#,#,3000000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201022",#,#,#,#,#,#,#,#,#,#,#,#,#,450000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201023",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201025",#,#,#,#,#,#,#,#,#,#,#,#,#,450000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201026",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201027",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201028",#,#,#,#,#,#,#,#,#,#,#,#,#,100000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201029",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301001",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301003",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301004",#,#,#,#,#,#,#,#,#,#,#,#,#,950000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301005",#,#,#,#,#,#,#,#,#,#,#,#,#,500000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301006",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301007",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301008",#,#,#,#,#,#,#,#,#,#,#,#,#,900000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301009",#,#,#,#,#,#,#,#,#,#,#,#,#,2250000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301010",#,#,#,#,#,#,#,#,#,#,#,#,#,50000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301011",#,#,#,#,#,#,#,#,#,#,#,#,#,550000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301013",#,#,#,#,#,#,#,#,#,#,#,#,#,60000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301014",#,#,#,#,#,#,#,#,#,#,#,#,#,800000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301015",#,#,#,#,#,#,#,#,#,#,#,#,#,125000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40302004",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601001",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601002",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601003",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601004",#,#,#,#,#,#,#,#,#,#,#,#,#,250000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601005",#,#,#,#,#,#,#,#,#,#,#,#,#,13000000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601006",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602001",#,#,#,#,#,#,#,#,#,#,#,#,#,500000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602002",#,#,#,#,#,#,#,#,#,#,#,#,#,0]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602003",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602004",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602005",#,#,#,#,#,#,#,#,#,#,#,#,#,45000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602006",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602007",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602008",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40603001",#,#,#,#,#,#,#,#,#,#,#,#,#,1700000]

2017-11-06 07:13:27,171 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 856

PARTITIONKEY: 31

IMPORT GROUP: Export-PBCS to BC

FILE TYPE: DELIMITED

DELIMITER: ,

SOURCE FILE: BVBudget_856.dat

PROCESSING CODES:

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

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

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

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

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

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

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

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

HEADER ROW.............. Header Row

ERROR_INVALID_PERIOD.............. Invalid period specified in the file.

[BLANK] "FY18","Budget","Working","21001","40101001",#,#,#,#,#,#,#,#,#,#,#,#,#,1200

[BLANK] "FY18","Budget","Working","21001","40101010",#,#,#,#,#,#,#,#,#,#,#,#,#,160185300

[BLANK] "FY18","Budget","Working","21001","40102006",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

[BLANK] "FY18","Budget","Working","21001","40102007",#,#,#,#,#,#,#,#,#,#,#,#,#,48909800

[BLANK] "FY18","Budget","Working","21001","40103001",#,#,#,#,#,#,#,#,#,#,#,#,#,3507000

[BLANK] "FY18","Budget","Working","21001","40104001",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

[BLANK] "FY18","Budget","Working","21001","40201001",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000

[BLANK] "FY18","Budget","Working","21001","40201003",#,#,#,#,#,#,#,#,#,#,#,#,#,90000

[BLANK] "FY18","Budget","Working","21001","40201004",#,#,#,#,#,#,#,#,#,#,#,#,#,75000

[BLANK] "FY18","Budget","Working","21001","40201005",#,#,#,#,#,#,#,#,#,#,#,#,#,7500000

[BLANK] "FY18","Budget","Working","21001","40201006",#,#,#,#,#,#,#,#,#,#,#,#,#,41379700

[BLANK] "FY18","Budget","Working","21001","40201007",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000

[BLANK] "FY18","Budget","Working","21001","40201008",#,#,#,#,#,#,#,#,#,#,#,#,#,3250000

[BLANK] "FY18","Budget","Working","21001","40201009",#,#,#,#,#,#,#,#,#,#,#,#,#,400000

[BLANK] "FY18","Budget","Working","21001","40201010",#,#,#,#,#,#,#,#,#,#,#,#,#,10000000

[BLANK] "FY18","Budget","Working","21001","40201011",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

[BLANK] "FY18","Budget","Working","21001","40201012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000

[BLANK] "FY18","Budget","Working","21001","40201013",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

[BLANK] "FY18","Budget","Working","21001","40201014",#,#,#,#,#,#,#,#,#,#,#,#,#,250000

[BLANK] "FY18","Budget","Working","21001","40201015",#,#,#,#,#,#,#,#,#,#,#,#,#,0

[BLANK] "FY18","Budget","Working","21001","40201016",#,#,#,#,#,#,#,#,#,#,#,#,#,1350000

[BLANK] "FY18","Budget","Working","21001","40201017",#,#,#,#,#,#,#,#,#,#,#,#,#,1000000

[BLANK] "FY18","Budget","Working","21001","40201018",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

[BLANK] "FY18","Budget","Working","21001","40201019",#,#,#,#,#,#,#,#,#,#,#,#,#,400000

[BLANK] "FY18","Budget","Working","21001","40201020",#,#,#,#,#,#,#,#,#,#,#,#,#,3000000

[BLANK] "FY18","Budget","Working","21001","40201022",#,#,#,#,#,#,#,#,#,#,#,#,#,450000

[BLANK] "FY18","Budget","Working","21001","40201023",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

[BLANK] "FY18","Budget","Working","21001","40201025",#,#,#,#,#,#,#,#,#,#,#,#,#,450000

[BLANK] "FY18","Budget","Working","21001","40201026",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

[BLANK] "FY18","Budget","Working","21001","40201027",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

[BLANK] "FY18","Budget","Working","21001","40201028",#,#,#,#,#,#,#,#,#,#,#,#,#,100000

[BLANK] "FY18","Budget","Working","21001","40201029",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

[BLANK] "FY18","Budget","Working","21001","40301001",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

[BLANK] "FY18","Budget","Working","21001","40301003",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

[BLANK] "FY18","Budget","Working","21001","40301004",#,#,#,#,#,#,#,#,#,#,#,#,#,950000

[BLANK] "FY18","Budget","Working","21001","40301005",#,#,#,#,#,#,#,#,#,#,#,#,#,500000

[BLANK] "FY18","Budget","Working","21001","40301006",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

[BLANK] "FY18","Budget","Working","21001","40301007",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

[BLANK] "FY18","Budget","Working","21001","40301008",#,#,#,#,#,#,#,#,#,#,#,#,#,900000

[BLANK] "FY18","Budget","Working","21001","40301009",#,#,#,#,#,#,#,#,#,#,#,#,#,2250000

[BLANK] "FY18","Budget","Working","21001","40301010",#,#,#,#,#,#,#,#,#,#,#,#,#,50000

[BLANK] "FY18","Budget","Working","21001","40301011",#,#,#,#,#,#,#,#,#,#,#,#,#,550000

[BLANK] "FY18","Budget","Working","21001","40301012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000

[BLANK] "FY18","Budget","Working","21001","40301013",#,#,#,#,#,#,#,#,#,#,#,#,#,60000

[BLANK] "FY18","Budget","Working","21001","40301014",#,#,#,#,#,#,#,#,#,#,#,#,#,800000

[BLANK] "FY18","Budget","Working","21001","40301015",#,#,#,#,#,#,#,#,#,#,#,#,#,125000

[BLANK] "FY18","Budget","Working","21001","40302004",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

[BLANK] "FY18","Budget","Working","21001","40601001",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000

[BLANK] "FY18","Budget","Working","21001","40601002",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

[BLANK] "FY18","Budget","Working","21001","40601003",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000

[BLANK] "FY18","Budget","Working","21001","40601004",#,#,#,#,#,#,#,#,#,#,#,#,#,250000

[BLANK] "FY18","Budget","Working","21001","40601005",#,#,#,#,#,#,#,#,#,#,#,#,#,13000000

[BLANK] "FY18","Budget","Working","21001","40601006",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

[BLANK] "FY18","Budget","Working","21001","40602001",#,#,#,#,#,#,#,#,#,#,#,#,#,500000

[BLANK] "FY18","Budget","Working","21001","40602002",#,#,#,#,#,#,#,#,#,#,#,#,#,0

[BLANK] "FY18","Budget","Working","21001","40602003",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

[BLANK] "FY18","Budget","Working","21001","40602004",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

[BLANK] "FY18","Budget","Working","21001","40602005",#,#,#,#,#,#,#,#,#,#,#,#,#,45000

[BLANK] "FY18","Budget","Working","21001","40602006",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000

[BLANK] "FY18","Budget","Working","21001","40602007",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000

[BLANK] "FY18","Budget","Working","21001","40602008",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

[BLANK] "FY18","Budget","Working","21001","40603001",#,#,#,#,#,#,#,#,#,#,#,#,#,1700000

Rows Loaded: 0

Rows Rejected: 62

2017-11-06 07:13:27,207 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=1:SourceClName=Amount

2017-11-06 07:13:27,207 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=1:SourceClName=Account

2017-11-06 07:13:27,207 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=Version

2017-11-06 07:13:27,207 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=1:SourceClName=Entity

2017-11-06 07:13:27,208 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps

2017-11-06 07:13:27,208 INFO [AIF]: EPMFDM-140274:Message - File Name BVBudget_856.dat

periodKey2018-03-31

2017-11-06 07:13:27,208 INFO [AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM() HPL

2017-11-06 07:13:27,208 DEBUG [AIF]: BOM exists

2017-11-06 07:13:27,208 DEBUG [AIF]: After removing BOM ["Years","Scenario","Version","Entity","Account","Period"]

2017-11-06 07:13:27,208 DEBUG [AIF]: EPMFDM-140274:Message - HEADER: ["Years", "Scenario", "Version", "Entity", "Account", "Period"]

2017-11-06 07:13:27,211 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CURKEY:ImpFieldText=null:StartPos=1:SourceClName=Currency

2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40101001",#,#,#,#,#,#,#,#,#,#,#,#,#,1200]

2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40101010",#,#,#,#,#,#,#,#,#,#,#,#,#,160185300]

2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40102006",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40102007",#,#,#,#,#,#,#,#,#,#,#,#,#,48909800]

2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40103001",#,#,#,#,#,#,#,#,#,#,#,#,#,3507000]

2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40104001",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201001",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000]

2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201003",#,#,#,#,#,#,#,#,#,#,#,#,#,90000]

2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201004",#,#,#,#,#,#,#,#,#,#,#,#,#,75000]

2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201005",#,#,#,#,#,#,#,#,#,#,#,#,#,7500000]

2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201006",#,#,#,#,#,#,#,#,#,#,#,#,#,41379700]

2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201007",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201008",#,#,#,#,#,#,#,#,#,#,#,#,#,3250000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201009",#,#,#,#,#,#,#,#,#,#,#,#,#,400000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201010",#,#,#,#,#,#,#,#,#,#,#,#,#,10000000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201011",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201013",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201014",#,#,#,#,#,#,#,#,#,#,#,#,#,250000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201015",#,#,#,#,#,#,#,#,#,#,#,#,#,0]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201016",#,#,#,#,#,#,#,#,#,#,#,#,#,1350000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201017",#,#,#,#,#,#,#,#,#,#,#,#,#,1000000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201018",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201019",#,#,#,#,#,#,#,#,#,#,#,#,#,400000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201020",#,#,#,#,#,#,#,#,#,#,#,#,#,3000000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201022",#,#,#,#,#,#,#,#,#,#,#,#,#,450000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201023",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201025",#,#,#,#,#,#,#,#,#,#,#,#,#,450000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201026",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201027",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201028",#,#,#,#,#,#,#,#,#,#,#,#,#,100000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201029",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301001",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301003",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301004",#,#,#,#,#,#,#,#,#,#,#,#,#,950000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301005",#,#,#,#,#,#,#,#,#,#,#,#,#,500000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301006",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301007",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301008",#,#,#,#,#,#,#,#,#,#,#,#,#,900000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301009",#,#,#,#,#,#,#,#,#,#,#,#,#,2250000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301010",#,#,#,#,#,#,#,#,#,#,#,#,#,50000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301011",#,#,#,#,#,#,#,#,#,#,#,#,#,550000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301013",#,#,#,#,#,#,#,#,#,#,#,#,#,60000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301014",#,#,#,#,#,#,#,#,#,#,#,#,#,800000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301015",#,#,#,#,#,#,#,#,#,#,#,#,#,125000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40302004",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601001",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601002",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601003",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601004",#,#,#,#,#,#,#,#,#,#,#,#,#,250000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601005",#,#,#,#,#,#,#,#,#,#,#,#,#,13000000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601006",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602001",#,#,#,#,#,#,#,#,#,#,#,#,#,500000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602002",#,#,#,#,#,#,#,#,#,#,#,#,#,0]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602003",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602004",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602005",#,#,#,#,#,#,#,#,#,#,#,#,#,45000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602006",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602007",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602008",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40603001",#,#,#,#,#,#,#,#,#,#,#,#,#,1700000]

2017-11-06 07:13:27,239 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 856