Results for “applied_from_trx_hdr_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The OKL_AE_LINES_ALL table is the core accounting entry line store within Oracle Lease and Finance Management (OKL), the EBS module that supports leasing, lending, and financing contracts. Every accounting event generated by the OKL subledger — depreciation, interest accrual, payment application, tax assessment, termination, and contract write-off — produces one or more rows in this table. The table resides in the OKL schema and is classified as VALID in the ETRM 12.1.1 / 12.2.2 documentation set. Its structure and column pattern (SUBLEDGER_DOC_SEQUENCE_VALUE, GL_SL_LINK_ID, ACCOUNTING_ERROR_CODE, GL_TRANSFER_ERROR_CODE) mirror the standard EBS Subledger Accounting (SLA) line model, confirming that OKL_AE_LINES_ALL holds the pre-transfer accounting detail that is ultimately posted to General Ledger through the standard SLA journal import process.

The supplied metadata carries a heuristic Data Vault classification of "satellite-leaning." In Data Vault modeling terms this suggests the table behaves primarily as a descriptive satellite attached to a parent hub or link, rather than a standalone hub. The parent entity in this case is the accounting header, and the satellite carries the financial measures and descriptive attributes for each line. Practitioners designing downstream warehouse models should treat AE_LINE_ID as the durable identity key and AE_HEADER_ID as the link to the header business key.

Key Information Stored

The table is physically documented with 57 columns in the 12.2.2 schema. The most operationally significant columns include:

• AE_LINE_ID — surrogate primary key (OKL_AE_LINES_ALL_PK) and also the unique index candidate OKL_AE_LINES_ALL_U1. This is the durable line identity.
• AE_HEADER_ID — foreign key to OKL_AE_HEADERS_ALL, tying the line to its accounting event header.
• AE_LINE_NUMBER — sequencing within the header.
• CODE_COMBINATION_ID — the GL account combination (natural account, cost center, etc.) debited or credited.
• AE_LINE_TYPE_CODE — classifies the line (for example debit, credit, tax, rounding).
• CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE — the multi-currency conversion context.
• ENTERED_DR / ENTERED_CR — entered-currency amounts; ACCOUNTED_DR / ACCOUNTED_CR — ledger-currency amounts.
• TAXABLE_ENTERED_DR, TAXABLE_ENTERED_CR, TAXABLE_ACCOUNTED_DR, TAXABLE_ACCOUNTED_CR — the taxable portion of each line.
• SOURCE_TABLE and SOURCE_ID — back-reference to the originating OKL transaction.
• GL_SL_LINK_ID — the link used to reconcile against GL when the journal is transferred.
• ACCOUNTING_ERROR_CODE and GL_TRANSFER_ERROR_CODE — diagnostic flags for lines that failed validation or transfer.
• ORG_ID — multi-org operating unit partitioning.

The APPLIED_FROM_TRX_HDR_TABLE/ID and APPLIED_TO_TRX_HDR_TABLE/ID pairs support cross-contract application scenarios such as applying a deposit or receipt between transactions.

Common Use Cases and Queries

Typical reporting and reconciliation scenarios include:

• Unposted line analysis. Rows where GL_SL_LINK_ID is null and ACCOUNTING_ERROR_CODE is null represent lines awaiting GL transfer.
• Error troubleshooting. Query lines with non-null ACCOUNTING_ERROR_CODE or GL_TRANSFER_ERROR_CODE to diagnose SLA or transfer failures.
• Trial balance reconciliations. Aggregate ACCOUNTED_DR and ACCOUNTED_CR by CODE_COMBINATION_ID for a given ORG_ID and accounting period.
• Source traceability. Joining SOURCE_TABLE and SOURCE_ID back to the OKL transaction to confirm the origin of an entry.

A representative query pattern joins the line to the header and to GL_CODE_COMBINATIONS:

SELECT l.ae_line_id, h.ae_header_id, cc.concatenated_segments,
       l.entered_dr, l.entered_cr, l.accounted_dr, l.accounted_cr
FROM   okl.okl_ae_lines_all l
       JOIN okl.okl_ae_headers_all h ON h.ae_header_id = l.ae_header_id
       JOIN apps.gl_code_combinations_kfv cc ON cc.code_combination_id = l.code_combination_id
WHERE  l.org_id = :p_org_id
AND    l.accounting_error_code IS NULL;

Related Objects

The dominant relationship is the mandatory FK from OKL_AE_LINES_ALL.AE_HEADER_ID to OKL_AE_HEADERS_ALL, forming the parent-child accounting entry structure. Additional dependencies include:

• OKL_AE_HEADERS_ALL — parent accounting event header; join on AE_HEADER_ID.
• GL_CODE_COMBINATIONS / GL_CODE_COMBINATIONS_KFV — resolves CODE_COMBINATION_ID to account strings.
• GL_IMPORT_REFERENCES / GL_JE_LINES — reconciliation to GL via GL_SL_LINK_ID after subledger transfer.
• FND_CURRENCIES — validation of CURRENCY_CODE.
• OKL_AE_LINE_SOURCES and related OKL transaction tables referenced through SOURCE_TABLE / SOURCE_ID.
• XLA_AE_LINES — the SLA counterpart created when OKL entries are transferred to the SLA engine.

Collectively these objects allow full traceability from an OKL lease event through accounting line detail, tax detail, and finally the GL journal.