Skip to main content
OracleOps AI
← All tables
Oracle Fusion/Financials/GL

GL_IMPORT_REFERENCES

Drill-down bridge — links each imported GL journal line back to the subledger transaction that created it.

Key Columns

JE_HEADER_IDJE_LINE_NUMGL_SL_LINK_IDGL_SL_LINK_TABLEREFERENCE_1REFERENCE_5

Common Joins

GL_JE_LINESvia JE_HEADER_ID + JE_LINE_NUM

The GL journal line this reference explains.

XLA_AE_LINESvia GL_SL_LINK_ID + GL_SL_LINK_TABLE

The subledger accounting line the journal line came from.

Used In

GLSubledger Accounting

Related

Subledger Accounting (XLA) event model

Each subledger transaction is an entity (XLA_TRANSACTION_ENTITIES) that raises accounting events (XLA_EVENTS). Create Accounting turns events into journal headers/lines (XLA_AE_HEADERS / XLA_AE_LINES); XLA_DISTRIBUTION_LINKS ties each transaction distribution to its journal line, and GL_IMPORT_REFERENCES bridges the posted GL line back to XLA.

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.

Ask Oracle AI about GL_IMPORT_REFERENCES