Oracle EBS GL Open Interface Tables

Actuals Interface - “GL_INTERFACE”
Budget Interface - “GL_BUDGET_INTERFACE”
Daily Foreign Currency Rates - “GL_DAILY_RATES_INTERFACE”

GL_INTERFACE

Used to import journal entry transactions (budget, actual, encumbrance, and statistical) from external sources. Also used to send transactions between sets of books (e.g. Consolidation, MRC, CENTRA, etc.). Notes:Requires calendar periods to be “Open” or “Future”. The “Journal Import”program transfers data from the Interface table into the Oracle base tables (e.g.GL_JE_BATCHES,GL_JE_HEADERS, and GL_JE_LINES).

 

The “Journal Posting” program changes the posting status w/i the “GL_JE_” tables,
updates the GL_BALANCES table, creates Intercompany Balancing transactions, Suspense
Posting transactions, etc.

GL_BUDGET_INTERFACE
Used to import budget data directly into GL_BALANCES table without requiring accounting periods to be open or run the Journal Posting program

GL_DAILY_RATES_INTERFACE
Used to automates the loading of currency conversion rates into the GL_DAILY_RATES
table.