Oracle Fusion · Data dictionary
XLA_AE_LINES
Subledger AccountingUsed in 17 subject areas23 reporting columns
Subledger Accounting (XLA) — accounting entry lines. The debit/credit lines behind every XLA_AE_HEADERS row, with the full Chart of Accounts code combination.
Primary key: AE_HEADER_ID, AE_LINE_NUM
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNTED_CR | ● | Accounted cr. | |
| ACCOUNTED_DR | ● | Accounted dr. | |
| ACCOUNTING_CLASS_CODE | ● | Code identifying the accounting class. | |
| ACCOUNTING_DATE | ● | Accounting date. | |
| AE_HEADER_ID | PK | ○ | Identifier for the ae header. |
| AE_LINE_NUM | PK | ○ | Ae line number. |
| BUSINESS_CLASS_CODE | ● | Code identifying the business class. | |
| CURRENCY_CONVERSION_DATE | ● | Currency conversion date. | |
| CURRENCY_CONVERSION_RATE | ● | Currency conversion rate. | |
| CURRENCY_CONVERSION_TYPE | ● | Type of currency conversion. | |
| DESCRIPTION | ● | Description. | |
| DISPLAYED_LINE_NUMBER | ● | Displayed line number. | |
| ENCUMBRANCE_TYPE_ID | ● | Identifier for the encumbrance type. | |
| ENTERED_CR | ● | Entered cr. | |
| ENTERED_DR | ● | Entered dr. | |
| GL_SL_LINK_ID | ● | Identifier for the general ledger sl link. | |
| GL_SL_LINK_TABLE | ● | General ledger sl link table. | |
| JGZZ_RECON_REF | ● | Jgzz recon reference. | |
| OVERRIDE_REASON | ● | Override reason. | |
| STATISTICAL_AMOUNT | ● | Statistical amount. | |
| SUBLEDGER_XCC_COMPLETE_STATUS | ● | Status of the subledger xcc complete. | |
| UNROUNDED_ACCOUNTED_CR | ● | Unrounded accounted cr. | |
| UNROUNDED_ACCOUNTED_DR | ● | Unrounded accounted dr. | |
| UNROUNDED_ENTERED_CR | ● | Unrounded entered cr. | |
| UNROUNDED_ENTERED_DR | ● | Unrounded entered dr. |
20 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_LINES.
- Cash to General Ledger Reconciliation Report
- Manual Subledger Journals Report
- AHCS Create Accounting Errors Report
- AHCS Create Accounting Report
- Account Analysis Report
- Global SLA Account Analysis
- Italian Journal Book Report
- Intercompany Invoiced Reconciliation Report
- India Creditors Ledger Report
- SLA Payables Account Analysis Report
- Vietnam Payment Voucher Report
- Projects CIP TIP Asset Detail Report
- AR Aging Detail Report
- Greece Customer Balance by Account Report
- Vietnam Receipt Voucher Report
- Accounting Hub Journal Entry Line Extract
- UK Audit File (SAF-T)
- Journal and Transaction Details 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
- 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_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.