Analytics Catalog/Data dictionary/XLA_AE_HEADERS
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

XLA_AE_HEADERS

Subledger AccountingUsed in 19 subject areas16 reporting columns

Subledger Accounting (XLA) — accounting entry headers. One row per accounting event posted from the subledgers (Payables, Receivables, Fixed Assets, Cash Management, Projects). The bridge from subledger transactions to GL.

Primary key: AE_HEADER_ID

Columns

ColumnKeyIn reportsDescription (inferred)
ACCOUNTING_ENTRY_STATUS_CODE●Code identifying the accounting entry status.
ACCOUNTING_ENTRY_TYPE_CODE●Code identifying the accounting entry type.
AE_HEADER_IDPK○Identifier for the ae header.
BALANCE_TYPE_CODE●Code identifying the balance type.
CLOSE_ACCT_SEQ_VALUE●Close account seq value.
COMPLETED_DATE●Completed date.
COMPLETION_ACCT_SEQ_VALUE●Completion account seq value.
DESCRIPTION●Description.
DOC_CATEGORY_CODE●Code identifying the doc category.
DOC_SEQUENCE_VALUE●Doc sequence value.
EVENT_TYPE_CODE●Code identifying the event type.
FUNDS_STATUS_CODE●Code identifying the funds status.
GL_TRANSFER_DATE●General ledger transfer date.
GL_TRANSFER_STATUS_CODE●Code identifying the general ledger transfer status.
JE_CATEGORY_NAME●Name of the je category.
PERIOD_NAME●Name of the period.
REFERENCE_DATE●Reference date.

16 reports read from this table

Change a column here and these are the reports that move with it — the blast radius for any change to XLA_AE_HEADERS.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for XLA_AE_HEADERS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us