Search Results


Wednesday, April 29, 2009

GL Interface Tables

GL_BUDGET_INTERFACE
Used to upload budget data into your Oracle General Ledger application

GL_DAILY_RATES_INTERFACE
Used to insert, update, or delete daily rates in the GL_DAILY_RATES table.

GL_IEA_INTERFACE
Used to create intercompany transaction data.

GL_INTERFACE
Used to create journal entries, Transfers source information into a target set of books, Creates accounting for Intercompany Transactions etc.

Base Tables
Following are the base table for Journal entry.
GL_JE_HEADERS
GL_JE_LINES
GL_JE_BACTHES

Concurrent program
Journal Import
Journal Posting


GL_INTERFACE_CONTROL
GL_INTERFACE_HISTORY



Usefull metalink notes
  1. Troubleshooting Journal Import
  2. Journal Import FAQ
  3. Oracle General Ledger Posting - FAQ
  4. Technical Reference Manual



Article By:
Prasanna Jayaraman

Please post your Ideas and Comments

1 comment :

Unknown said...

Hello, I have a questions about table GL_INTERFACE.
When I make a query in this table to my book. The query show information only the two type of category COGS JOURNAL and IR Adjustment.
When I try the close de GL Period, the message is warning the unprocessed records exist in GL_INTERFACE. How I can obtain the information through this table??