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.

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: Holds the Journal Batches data. 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. 

• GL_JE_HEADERS: Holds the Journals data. A journal belongs to a journal batch. It is a group of journal lines with an account in each line that balance. The sum of the debits is equal to the sum of credits. The currency code is stored at the journal level. Each journal in a batch gives rise to a separate record in the .

• GL_JE_LINES: Holds the Journal Lines data. The  table holds a record for each journal line. The lines record the accounted amounts, either debit or credit, and the account code combination that the amount will be posted to. 

• GL_BALANCES: This table holds the accounting balance for every code combination, currency and period 

• Other Tables:

• GL_SETS_OF_BOOKS A row for each set of books 

• GL_PERIODS A row for each calender period 

• GL_CODE_COMBINATIONS All the Account Flexfield segment values 

• FND_CURRENCIES A row for each currency 

Importing Journals

• Import journal entries from feeder system: 

• 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 

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