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,759 06-21-2020, 11:01 PM
Last Post: Abdelrahman.Fouad
  Run Oracle E-Business Suite on Oracle Cloud MM Ifan 0 8,476 01-12-2020, 12:14 AM
Last Post: MM Ifan
  Oracle VAT Implementation admin 2 16,813 12-24-2019, 02:51 PM
Last Post: viggora
  Oracle Subledger Accounting new Features in EBS Release R12 Sneha Rahul 2 15,363 12-24-2019, 02:19 PM
Last Post: viggora
  Oracle Payable Open Interface Import Neha Majeed 2 28,131 12-24-2019, 01:26 PM
Last Post: viggora
  International public sector accounting standards using Oracle EBS shaz.rashid@gmail.com 2 12,231 12-24-2019, 01:09 PM
Last Post: viggora
  Payments to Financing House In Oracle R12 nisarwangde 3 4,163 12-24-2019, 01:07 PM
Last Post: viggora
  Duplicated entry in Oracle General Trial Balance eimis 2 17,268 12-24-2019, 12:27 PM
Last Post: viggora
  R12 Oracle Property Manager MKardaris 2 18,185 12-24-2019, 11:59 AM
Last Post: viggora
  Migrating Oracle Financial Apps sunny101 4 18,063 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!