Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Oracle E-Business Suite won't import all data using the configured spreadsheet
06-01-2021, 08:51 PM,
#1
Oracle E-Business Suite won't import all data using the configured spreadsheet
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...214912.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?
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
  Oracle Project Budget Details Abdelrahman.Fouad 0 4,288 06-21-2020, 11:01 PM
Last Post: Abdelrahman.Fouad
  Run Oracle E-Business Suite on Oracle Cloud MM Ifan 0 7,799 01-12-2020, 12:14 AM
Last Post: MM Ifan
  Oracle VAT Implementation admin 2 16,028 12-24-2019, 02:51 PM
Last Post: viggora
  Oracle Subledger Accounting new Features in EBS Release R12 Sneha Rahul 2 13,576 12-24-2019, 02:19 PM
Last Post: viggora
  Oracle Payable Open Interface Import Neha Majeed 2 27,140 12-24-2019, 01:26 PM
Last Post: viggora
  International public sector accounting standards using Oracle EBS shaz.rashid@gmail.com 2 11,881 12-24-2019, 01:09 PM
Last Post: viggora
  Payments to Financing House In Oracle R12 nisarwangde 3 3,356 12-24-2019, 01:07 PM
Last Post: viggora
  Duplicated entry in Oracle General Trial Balance eimis 2 17,071 12-24-2019, 12:27 PM
Last Post: viggora
  R12 Oracle Property Manager MKardaris 2 17,593 12-24-2019, 11:59 AM
Last Post: viggora
  Migrating Oracle Financial Apps sunny101 4 17,714 12-24-2019, 11:56 AM
Last Post: viggora



Users browsing this thread: 1 Guest(s)
Open Tech Talks Get Oracle Tutorials, Tips! Post a Question!