+- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com)
+-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html)
+--- Forum: Oracle E-Business Suite (EBS) (http://www.oraerp.com/forum-1.html)
+---- Forum: Oracle Financials (http://www.oraerp.com/forum-2.html)
+---- Thread: Oracle E-Business Suite won't import all data using the configured spreadsheet (/thread-113921.html)
Oracle E-Business Suite won't import all data using the configured spreadsheet - blueben_jamin - 06-01-2021
I'm configuring the spreadsheet (apwexwmc.xls) that comes with Oracle E-Business Suite to be able to retain data in a spreadsheet for offline expenses to be imported at a later date.
I've being using this manual to complete:
https://docs.oracle.com/cd/E18727_01/doc.121/e13454/T214904T214912.htm
I have successfully setup the spreadsheet and all flex fields however when you paste the data from the spreadsheet into Oracle it doesn't all import (even though the physical text is visible in the paste cell on Oracle).
Currently I have successfully got all "receipt based" expense Data importing but not all "mileage based".
On mileage, even though I can see the text values (in the Oracle import cell) I only get across 'Date' and 'Expense Type' all other data doesn't show (trip distance, price per mile, total reimbursement amount). Equally all data that is held in the "additional information" tab (from, to, license plate number, engine CC, justification) also doesn't poll across.
Could you help me fix this please?
Is there a specific structure order perhaps?
Has anyone got a spreadsheet they use that I could copy?