I am trying to load data from an Essbase app to a Planning app. The dataexport from Essbase seems to be fine (except that the period name is by itself on row 2 of the export file instead of being a column on the data rows), but the import fails with message Exception while applying AMOUNT mapping on the row:["HourEmp","SA.0007","No Grade","KC10750","EN.6500","DP.700","EM6072580","FY22","Act","Week2","Capital_Hrs",43].
I'm thinking the problem is that it expects Amount to be in column 13, but there are only 12 columns (the amount is in column 12 of the export file because period is not included).
The most relevant section of the log (level 5) is below:
2022-11-16 21:05:59,007 DEBUG [AIF]: FileData.py: Importing Text data for load id: 1836
2022-11-16 21:05:59,076 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH:IMPGROUPFILETYPE::1836;11:2:74:[NONE]:\\ncwpwhyppea0002\cluster_share\FDM_Data/data:EPM_EPM
2022-11-16 21:05:59,168 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8
2022-11-16 21:05:59,168 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start
2022-11-16 21:05:59,169 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
2022-11-16 21:05:59,232 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=1:SourceClName=Amount
2022-11-16 21:05:59,232 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=Account
2022-11-16 21:05:59,233 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=1:SourceClName=Department
2022-11-16 21:05:59,233 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=1:SourceClName=Employee
2022-11-16 21:05:59,234 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=1:SourceClName=EmpStatus
2022-11-16 21:05:59,234 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=Entity
2022-11-16 21:05:59,235 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD5:ImpFieldText=null:StartPos=1:SourceClName=Grade
2022-11-16 21:05:59,235 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD6:ImpFieldText=null:StartPos=1:SourceClName=Scenario
2022-11-16 21:05:59,236 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD7:ImpFieldText=null:StartPos=1:SourceClName=State
2022-11-16 21:05:59,236 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD8:ImpFieldText=null:StartPos=1:SourceClName=SubAcct
2022-11-16 21:05:59,237 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD9:ImpFieldText=null:StartPos=1:SourceClName=Version
2022-11-16 21:05:59,240 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps
2022-11-16 21:05:59,241 INFO [AIF]: EPMFDM-140274:Message - File Name SPAY-Main_1836.dat
periodKey2022-11-01
2022-11-16 21:05:59,242 INFO [AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM() ESSBASE
2022-11-16 21:05:59,244 DEBUG [AIF]: EPMFDM-140274:Message - HEADER: ["EmpStatus", "SubAcct", "Grade", "State", "Entity", "Department", "Employee", "Years", "Scenario", "Version", "Account", "Period"]
2022-11-16 21:05:59,253 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CURKEY:ImpFieldText=null:StartPos=1:SourceClName=Currency
2022-11-16 21:05:59,289 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["HourEmp","SA.0007","No Grade","KC10750","EN.6500","DP.700","EM6072580","FY22","Act","Week2","Capital_Hrs",43]
2022-11-16 21:05:59,290 DEBUG [AIF]: EPMFDM-140274:Message - null
2022-11-16 21:05:59,291 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 1836
PARTITIONKEY: 11
IMPORT GROUP: sSal_from_sPay
FILE TYPE: DELIMITED
DELIMITER: ,
SOURCE FILE: SPAY-Main_1836.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] "HourEmp","SA.0007","No Grade","KC10750","EN.6500","DP.700","EM6072580","FY22","Act","Week2","Capital_Hrs",43