data exchange Import issue Applying Amount Mapping
Summary:
I am facing issue during Import step of Data Exchange. Below error: It is allocation data writeback from EPCM to ERP. Integration is able to extract data out of Essbase but fails with following error: (note : data has been masked in below)
Exception while applying AMOUNT mapping on the row:[00 0000,Actual,050,71350,FY25,L052 - Alloc 160001-500000-71350 to stores,000000,5000,Final,CAD,000,110032,PCM_Allocation In,CALedger,YTD,100
[BLANK] 0000,Actual,050,71350,FY25,L052 - Alloc 160001-5000-71350 to stores,000000,50000,Final,CAD,000,110032,PCM_Allocation In,CALedger,YTD,100
Rows Loaded: 0
Rows Rejected: 1
Period mappings looks to be corrrect.
Any help in resolution of above is highly appreciated.
Tagged:
0