← All tables
Oracle Fusion/Financials/GL
GL_INTERFACE
Journal import staging table — external and FBDI journal lines wait here for the Import Journals process.
Key Columns
STATUSLEDGER_IDUSER_JE_SOURCE_NAMEUSER_JE_CATEGORY_NAMEACCOUNTING_DATECURRENCY_CODEENTERED_DRENTERED_CRGROUP_ID
Used In
GLFBDI
Notes
STATUS 'NEW' before import; failed rows are moved to GL_INTERFACE with an error status and detailed in the import execution report.
Related
GL ledgers, periods and journal import
A ledger (GL_LEDGERS) has a chart of accounts, currency and calendar; period open/close is GL_PERIOD_STATUSES per application. External journals stage in GL_INTERFACE for Import Journals, which creates GL_JE_BATCHES / GL_JE_HEADERS / GL_JE_LINES, and GL_IMPORT_REFERENCES keeps the drilldown to the subledger.