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
Joins (inferred from key columns): BALANCE_TYPE_CODE → PAY_BALANCE_TYPES_VL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNTING_ENTRY_STATUS_CODE | ● | Code identifying the accounting entry status. | |
| ACCOUNTING_ENTRY_TYPE_CODE | ● | Code identifying the accounting entry type. | |
| AE_HEADER_ID | PK | ○ | 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.
- Cash to General Ledger Reconciliation Report
- Manual Subledger Journals Report
- AHCS Create Accounting Errors Report
- AHCS Create Accounting Report
- Global SLA Account Analysis
- SLA Payables Account Analysis Report
- Projects CIP TIP Asset Detail Report
- AR Aging Detail Report
- Accounting Hub Journal Entry Line Extract
- Payables to Ledger Reconciliation Report
- Receivables to General Ledger Reconciliation Report
- Subledger Period Close Exceptions Report
- Journal and Transaction Details Report
- Payables Period Close Exceptions Report
- Payables Posted Invoice Register
- Payables Posted Payment Register
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.
- Budgetary Control - Transactions Real Time
- Fixed Assets - Asset Depreciation Real Time
- Fixed Assets - Asset Transactions Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Payables Payments - Disbursements Real Time
- Procurement - Spend Real Time
- Project Billing - Revenue Real Time
- Project Costing - Actual Costs Real Time
- Receivables - Adjustments Real Time
- Receivables - Bills Receivable Real Time
- Receivables - Credit Memo Applications Real Time
- Receivables - Miscellaneous Receipts Real Time
- Receivables - Receipts Details Real Time
- Receivables - Revenue Adjustments Real Time
- Receivables - Standard Receipts Application Details Real Time
- Receivables - Transactions Real Time
- Revenue Management - Revenue Recognition Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for XLA_AE_HEADERS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table