General Ledger Interface Tables

By | April 7, 2016
General Ledger Interface Tables Purpose of Table
GL_INTERFACE GL_INTERFACE is used to import journal entry batches through Journal Import.
Base Tables:
  1. GL_JE_HEADERS
  2. GL_JE_LINES
GL_INTERFACE_CONTROL GL_INTERFACE_CONTROL is used to control Journal Import execution. Whenever you start Journal Import from the Import Journals form, a row is inserted into this table for each source and group id that you specified. When Journal Import completes, it deletes these rows from the table.
GL_INTERFACE_HISTORY GL_INTERFACE_HISTORY stores the rows that are successfully imported from the GL_INTERFACE table through Journal Import.
GL_BUDGET_INTERFACE GL_BUDGET_INTERFACE is used to upload budget data into your Oracle General Ledger application from a spreadsheet program or other external source. Each row includes one fiscal year’s worth of budget amounts for an account.
GL_DAILY_RATES_INTERFACE GL_DAILY_RATES_INTERFACE is used to create, update, and delete daily conversion rates. You can use this table to load rates into the GL_DAILY_RATES table.
Base Tables:
  1. GL_DAILY_RATES
GL_IMP_COA_SEG_VAL_INTERFACE Interface table to capture data for the import of Chart of Accounts Segment Values.
GL_IMP_COA_NORM_HIER_INTERFACE Interface table to capture data for the import Child Ranges for Parent Chart of Account Segment Values.
GL_IMP_COA_ERR_INTERFACE Error message interface table for the Chart of Account Segment Values Import process.
GL_XFR_INTERFACE This table is a custom version of the gl_interface table for use by the balance transfer to Fusion Application
WOW! Did you like this post? We'll send more interesting posts like General Ledger Interface Tables to you!
Enter your Email Address: