Results for “txs_trx_line_id”

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

Overview

OKL_TXL_AR_INV_LNS_B is the base table within the Oracle E-Business Suite Release 12.1.1 / 12.2.2 Leasing and Finance Management (OKL) module that stores the transaction lines destined for inclusion on Receivables invoices. Each row represents an individual billable line — a lease payment, late charge, tax amount, or adjustment — that has been staged for transfer to Oracle Receivables. Because the table name carries the "_B" suffix, it conforms to the EBS base-table convention, holding the primary surrogate identifier referenced by corresponding "_TL" translation and "_ALL" intersection tables where applicable.

The table's role is transactional staging and persistence rather than reference data. It acts as the bridge between the leasing contract engine and the Receivables subledger, capturing the monetary and quantity attributes that ultimately flow into an AR invoice line. Program context columns indicate that most rows are produced by concurrent programs executing the billing and invoicing cycle.

A heuristic Data Vault classification derived from the foreign-key structure suggests this object behaves as a satellite-leaning entity. It carries descriptive and measurable attributes (amounts, quantities, periods) attached to multiple parent hubs — lease contracts, stream types, AR invoices, and cost condition lines — rather than serving as a pure link or hub itself. Modelers should treat it as a descriptive satellite associated with the AR invoice hub.

Key Information Stored

The primary key is ID, enforced by the unique index OKL_TXL_AR_INV_LNS_B_U1, which also functions as the business-key candidate. This surrogate identifier is the anchor referenced by downstream tables such as OKL_TXD_AR_LN_DTLS_B and OKL_TXL_ADJSTS_LNS_B.

• TAI_ID — foreign key to OKL_TRX_AR_INVOICES_B, tying each line to its parent AR invoice record.
• KLE_ID — foreign key to OKL_K_LINES, linking the line to the contract line being billed.
• STY_ID — foreign key to OKL_STRM_TYPE_B, identifying the stream type (payment stream) that generated the charge.
• TPL_ID — foreign key to OKL_TXL_AP_INV_LNS_ALL_B, connecting AP-side invoice lines for pass-through or cost-based billing.
• ACN_ID_COST — foreign key to OKL_AST_CNDTN_LNS_ALL_B, associating the line with an asset condition cost.
• TIL_ID_REVERSES — self-referencing key identifying the line that this row reverses.
• AMOUNT and QUANTITY — the monetary value and units to be invoiced.
• AMOUNT_APPLIED — tracks the portion of the line already applied or settled.
• DATE_BILL_PERIOD_START and DATE_BILL_PERIOD_END — define the billing period the charge covers.
• RECEIVABLES_INVOICE_ID — the identifier of the invoice created in Oracle Receivables.
• TAX_LINE_ID — foreign key to ZX_LINES, linking the leasing line to its corresponding tax line.
• ORG_ID and INVENTORY_ORG_ID — multi-org and inventory context for the transaction.
• INVENTORY_ITEM_ID — the item associated with the billable line.
• TXS_TRX_ID and TXS_TRX_LINE_ID — transaction and transaction-line references for tax and stream processing.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID — concurrent program audit context.

Standard EBS who-columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER) support audit and optimistic locking. Fifteen ATTRIBUTE columns provide the conventional descriptive flexfield extension area.

Common Use Cases and Queries

The most frequent reporting scenario reconciles leasing billing lines to Receivables invoices. A typical query joins the staging table to its parent invoice and contract line:

• Billing reconciliation: select TIL.ID, TIL.AMOUNT, TAI.INVOICE_NUMBER from OKL_TXL_AR_INV_LNS_B TIL join OKL_TRX_AR_INVOICES_B TAI on TIL.TAI_ID = TAI.ID where TIL.AMOUNT is not null.
• Revenue period analysis: aggregate AMOUNT grouped by DATE_BILL_PERIOD_START to validate monthly billing volumes.
• Reversal tracking: query rows where TIL_ID_REVERSES is not null to audit credits issued against original charges.
• Tax reconciliation: join to ZX_LINES via TAX_LINE_ID to verify tax amounts were calculated and transferred correctly.
• Concurrent program diagnostics: filter on REQUEST_ID to isolate rows generated by a specific billing run.

These patterns support finance and operations reporting on lease revenue recognition, unbilled receivables, and late-charge accrual.

Related Objects

• OKL_TRX_AR_INVOICES_B — parent invoice header; join on TAI_ID = ID.
• OKL_K_LINES — billed contract line; join on KLE_ID = ID.
• OKL_STRM_TYPE_B — stream type definition; join on STY_ID = ID.
• OKL_TXD_AR_LN_DTLS_B — line detail recipient; references this table via TIL_ID_DETAILS.
• OKL_TXL_ADJSTS_LNS_B and OKL_TXL_ADJSTS_LNS_ALL_B — adjustment lines referencing the base line through TIL_ID.
• OKL_XTL_SELL_INVS_B — seller invoice lines linking back via TIL_ID.
• OKL_TXL_AP_INV_LNS_ALL_B — AP invoice lines joined through TPL_ID.
• OKL_AST_CNDTN_LNS_ALL_B — asset condition lines linked through ACN_ID_COST.
• ZX_LINES — EBS tax engine lines linked through TAX_LINE_ID.