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
Joins (inferred from key columns): AE_HEADER_ID → XLA_AE_HEADERS
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.
Problems that run through this table