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:
  • 62 Vote(s) - 2.76 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DataLoad Templates for Oracle Financials
10-11-2010, 12:16 AM, (This post was last modified: 10-11-2010, 12:22 AM by admin.)
#1
DataLoad Templates for Oracle Financials
We are publishing some sample DataLoad templates for Oracle Financials, along with their descriptions and navigation instructions.

Please note, these are only samples; you may need to modify the templates based on your Oracle application configurations. The blue columns represent DataLoad commands, the yellow columns is where you paste your data. Hope you will find the templates useful.

Share your own experiences with uploading and maintaining data in Oracle
Applications.

Create Employee AP Signing Limits
Create employee signing limits for expense report approvals. Managers can approve an expense report only if the total amount of the expense report does not exceed their pre-defined signing limit. The Manager (Spending) Approval Process in the Expense Reporting workflow uses the signing limits to determine which manager has authority to approve expense reports. When you assign signing limits to a manager, you also specify a cost center to which this signing limit applies and you can give managers signing limits for multiple cost centers.

Navigation: Payables Manager: Employees > Signing Limits
Start Field: Document Type
DataLoad:AP Employee Signing Limits

.zip   Create AP Employee Signing Limits.zip (Size: 1.62 KB / Downloads: 285)

Create AP Expense Report Template

Define your Expense Report Template based on the expense report forms your company uses. You can define default values for expense items and you can choose those items from a list of values when you enter expense reports. During Expense Report Import, Payables uses the expense item information to create invoice distributions. If your employees will be entering project-related expense reports, you need to define project-related expense items and associate them with Oracle Projects expenditure types.

Navigation: Payables Manager: Employees > Signing Limits

Start Field: Document Type

DataLoad: AP Expense Report Template

.zip   Create AP Expense Report Template.zip (Size: 1.79 KB / Downloads: 221)


Create Standard Suppliers

Create suppliers in Oracle Payables.

Navigation: Payables Manager: Suppliers > Entry

Start Field: Supplier Name

DataLoad: Create Suppliers

.zip   Create Suppliers.zip (Size: 1.92 KB / Downloads: 271)


Create Customers

Create customers in Oracle Receivables. You can enter as much or as little information in the customer accounts as you want. The only information that is required for a new customer account is a party name, account number, and address.

Navigation: Receivables Manager: Customers > Standard

Start Field: Name

DataLoad: Create Customers

.zip   Create Customers.zip (Size: 1.89 KB / Downloads: 236)
Reply
Thanks given by: chiragerp , ridha76
11-08-2012, 03:34 PM,
#2
RE: DataLoad Templates for Oracle Financials
Thanks a lot mate, this is of grate help and save much time.
Reply
Thanks given by: ridha76
06-07-2013, 10:52 PM,
#3
RE: DataLoad Templates for Oracle Financials
Thanks a lot for the files. They are good.
Reply
Thanks given by: ridha76
06-08-2013, 04:45 PM,
#4
RE: DataLoad Templates for Oracle Financials
Nice Material
Reply
Thanks given by: ridha76
09-01-2014, 12:48 AM,
#5
RE: DataLoad Templates for Oracle Financials
(11-08-2012, 03:34 PM)jhonka Wrote: Thanks a lot mate, this is of grate help and save much time.
Thank you so much
Reply
Thanks given by: ridha76
01-24-2017, 08:47 AM,
#6
RE: DataLoad Templates for Oracle Financials
when i am logged into my oracle erp cloud, where do i go to download ALL file based loader templates for item master, suppliers, employees, LOV's, Enterprise Structures, Locations, current GL/COA, etc.
Reply
Thanks given by:
01-24-2017, 05:33 PM,
#7
RE: DataLoad Templates for Oracle Financials
Check this document link to load data through spread sheets in ERP Cloud.
https://docs.oracle.com/cloud/latest/fin...CSF1004386
thanks
Reply
Thanks given by:
06-09-2017, 03:32 PM,
#8
RE: DataLoad Templates for Oracle Financials
Hi How to download these files?
Reply
Thanks given by:
06-09-2017, 08:49 PM,
#9
RE: DataLoad Templates for Oracle Financials
(06-09-2017, 03:32 PM)adamtan Wrote: Hi How to download these files?

You have to become premium member, follow the instruction http://www.oraerp.com/Announcement-Upgra...Membership
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
  Oracle HCM Cloud Interview Questions MM Ifan 1 50,522 06-06-2021, 12:16 AM
Last Post: zaidmd
  Oracle Implementation Project Plan admin 35 141,001 04-29-2021, 06:59 AM
Last Post: Cwahsayz
  Oracle ERP Implementation Project Schedule based on OUM Kashif Manzoor 7 25,585 03-31-2021, 11:45 PM
Last Post: haydara
  Oracle Financials - Data Flow From SLA to GL admin 8 79,362 12-17-2020, 11:26 PM
Last Post: cok3cl
  Oracle Inventory Module End User Training Material James Robert 1 29,399 08-27-2020, 08:59 PM
Last Post: shahid
  Oracle Inventory Miscellaneous Transactions Mark Donald 1 27,977 08-20-2020, 05:34 PM
Last Post: shahid
  Oracle Fusion Financials General Ledger Essentials M Irfan 5 92,211 08-20-2020, 05:32 PM
Last Post: shahid
  Oracle AIM - RD050 Business Requirement Documents admin 10 107,170 06-04-2020, 05:28 AM
Last Post: Shashi
  Oracle AIM - BR100 Documents admin 37 243,113 05-13-2020, 06:53 PM
Last Post: amjad.orafunctional
  AIM Vs OUM - Application Implementation Methodology vs Oracle Unified Methodology Kashif Manzoor 7 43,184 12-11-2019, 10:50 PM
Last Post: abuzeids



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