Sample DataLoad Templates for Oracle Financials

bob

Create GL Code Combinations
Define new accounts by creating new combinations of account segment values. You must define all new accounts manually if you do not allow dynamic insertion to create new accounts automatically (most people have it on), or if you need to pre-define your account combinations for data conversions [e.g. employees, assets, invoices, etc.].
Navigation: General Ledger Super User: Setup > Accounts > Combinations
Start Field: Account
DataLoad: Create GL Code Combinations
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
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
Create Standard Suppliers
Create suppliers in Oracle Payables.
Navigation: Payables Manager: Suppliers > Entry
Start Field: Supplier Name
DataLoad: Create Suppliers
Create 1099 Suppliers
Create 1099 suppliers and their tax reporting options.
Navigation: Payables Manager: Suppliers > Entry
Start Field: Supplier Name
DataLoad: Create 1099 Suppliers
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
Delete AR Transactions

Use the Transaction window to delete the payment schedule by choosing the incomplete button in the and deleting the record. We used this method to remove legacy project invoices, which were generated in Projects (in order to create opening bill balances), and did not belong in Receivables.
Navigation: Receivables Manager: Transactions > Transactions
Start Field: Source
DataLoad: Delete AR Transactions
Create FA Categories
Create your asset categories. Category information is common for a group of assets. Oracle Assets defaults these depreciation rules when you add an asset, to help you add assets quickly. If the default does not apply, you can override many of the defaults for an individual asset in the Asset Details or Books windows. You have to set up default values for each category in each book. The default depreciation rules that you set up for a category also depend upon the date placed in service ranges you specify.
Navigation: Fixed Assets Manager: Setup > Asset System > Asset Categories
Start Field: Category
DataLoad: Create FA Categories
Assign Existing FA Categories To a New Book

Assign the existing asset categories to a new asset book.
Navigation: Fixed Assets Manager: Setup > Asset System > Asset Categories
Start Field: Category
DataLoad: Assign FA Categories To a New Book
Set GL Set of Books Name Profile Option

Set the GL: Set of Books Name profile option for all your responsibilities in the multi-org environment.
Navigation: System Administrator: Profile > System
Start Field: Responsibility in the Find System Profile Values. (Make sure to enable the flag.)
DataLoad: Set GL Set of Books Profile Option
Set MO Operating Unit Profile Option

Set the MO: Operating Unit profile option for all your responsibilities in a multi-org environment.
Navigation: System Administrator: Profile > System
Start Field: Responsibility in the Find System Profile Values. (Make sure to enable the flag.)
DataLoad: Set MO Operating Unit Profile
Set OIE Profile Options

Set the iExpense profile options to match you business requirements.
Navigation: System Administrator: Profile > System
Start Field: Profile
DataLoad: OIE Profiles