Oracle Gl Interface

The journal Import interface uses the GL_INTERFACE table as a bridge between external systems and the Oracle General Ledger base tables. For each journal line that needs to be imported, a single record is inserted into GL_INTERFACE table.

1. Oracle GL Interface


Introduction
The journal Import interface uses the GL_INTERFACE table as a bridge between
external systems and the Oracle General Ledger base tables. For each journal line
that needs to be imported, a single record is inserted into GL_INTERFACE table.

Standard GL Interface Process
 Create journals in feeder systems and upload them to Oracle General Ledger
using Journal Import
 Import journal entries from feeder systems
– Third Party Systems - Billing, Banking etc.
– Oracle Sub-ledgers - AP, AR,Payroll
– Includes statistical information - airtime, customers
 Review journal import data
 Correct and delete journal import data
For transfers initiated from Oracle subledgers, the system automatically populates
the GL_INTERFACE table, and then starts the journal import process.
GL Data Model
GL_JE_BATCHES Journal Batches
GL_JE_HEADERS Journals
GL_JE_LINES Journal Lines
GL_BALANCES Balances for every code combination, currency and period

2. A journal batch is a group of related journals that are posted together. The period in
which the journals belong is stored at batch level. Each journal in a batch gives rise
to a separate record in the GL_JE_HEADERS
A journal is a group of journal lines that balance. The sum of the debits is equal to
the sum of credits. The currency code is stored at the journal level.
The GL_JE_LINES table holds a record for each journal line. The lines record the
accounted amounts, either debit or credit, and the account code combi nation that
the amount will be posted to.

GL_JE_BATCHES> ---------------------------FND_PERIODS
| |
^ |
GL_JE_HEADERS>-------------FND_CURRENCIES |
| | |
^ | |
GL_JE_LINES>--GL_CODE_COMBINATIONS | |
V | | |
| ^ ^ ^
GL_BALANCES

GL_SETS_OF_BOOKS A row for each set of books
GL_PERIODS A row for each calender period
GL_CODE_COMBINATI ONS All the Account Flexfield segment values
FNS_CURRENCIES A row for each currency
GL_BALANCES Balances for every account code, currency, and period
combination.

3. Importing Journals
 Import journal entries from feeder system:
o Third Party Systems - Billing, Banking etc.
o Oracle Sub-ledgers - AP, AR,Payroll
 Includes statistical information - airtime, customers
 Review journal import data
 Correct and delete journal import data


ADI Functionality
Applications Desktop Integrator is a spreadsheet tool which enables you to interface data in
spreadsheet format directly into Oracle, it can also drill down into Oracle from a spreadsheet to
provide you with the required information. Its features are:
 Journal Import
 Budgeting
 Analysis and Drilldown
 Fixed Asset Import
 Account Hierarchy Editor
 Physical Inventory Run
 Import Text File