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 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,
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:

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?
Thanks given by:

Possibly Related Threads…
Thread Author Replies Views Last Post
  Oracle Project Budget Details Abdelrahman.Fouad 0 4,975 06-21-2020, 11:01 PM
Last Post: Abdelrahman.Fouad
  Run Oracle E-Business Suite on Oracle Cloud MM Ifan 0 8,670 01-12-2020, 12:14 AM
Last Post: MM Ifan
  Oracle VAT Implementation admin 2 17,168 12-24-2019, 02:51 PM
Last Post: viggora
  Oracle Subledger Accounting new Features in EBS Release R12 Sneha Rahul 2 16,543 12-24-2019, 02:19 PM
Last Post: viggora
  Oracle Payable Open Interface Import Neha Majeed 2 28,742 12-24-2019, 01:26 PM
Last Post: viggora
  International public sector accounting standards using Oracle EBS 2 12,452 12-24-2019, 01:09 PM
Last Post: viggora
  Payments to Financing House In Oracle R12 nisarwangde 3 4,400 12-24-2019, 01:07 PM
Last Post: viggora
  Duplicated entry in Oracle General Trial Balance eimis 2 17,535 12-24-2019, 12:27 PM
Last Post: viggora
  R12 Oracle Property Manager MKardaris 2 18,422 12-24-2019, 11:59 AM
Last Post: viggora
  Migrating Oracle Financial Apps sunny101 4 18,302 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!