Exporting Information to GL
(Product --> Transaction Type)
Payables --> Payments and invoices
Receivables --> Debit memos, credit memos, on-account credits,
invoices, chargebacks, receipts, adjustments,
guarantees, other receipts and deposits
Assets --> Deferred and standard depreciation expense
transactions and asset transaction information
Projects --> Labor cost, usage cost, vendor invoice
adjustments, and revenue information
Purchasing --> Accrued receipts
Cost Management/Inventory Inventory and work in process transactions
Importing Information to GL
Except for Oracle Assets, all subledgers integrate with Oracle General Ledger
(GL) through the GL_INTERFACE table.
• Run the Journal Import process automatically from the subledger at transaction transfer time or manually from Oracle General Ledger at a later time.
• Transfer information to Oracle General Ledger in detail (show all journal entry lines for transactions against each account within a category) or summary (show only totals for transactions against each account within a category).
Note: Oracle Assets transfers information directly into the GL_JE_BATCHES,
GL_JE_HEADERS, and GL_JE_LINES tables.
Oracle subledgers share:
The Oracle General Ledger set of books, consisting of a calendar, currency, and chart of accounts
The Oracle General Ledger exchange rates, including conversion rate types, daily rates, period rates, and historical rates
The Oracle General Ledger journal entry sources and categories used to record information about the origination and purpose of transactions
Set of Books
• A set of books determines the functional currency, account structure, and
accounting calendar for each company or group of companies.
• Each set of books has a number of options that indicate the accounting
practices you want to follow for that set of books.
Chart of Accounts
• Your chart of accounts is the account structure you define to fit the specific
needs of your organization.
• You can choose the number of account segments as well as the length, name,
and order of each segment.
• The accounting calendar defines an accounting year and the periods it
• You can define multiple calendars and assign a different calendar to each set
• You can select the functional currency for your set of books as well as other
currencies that you use to transact business.