Results for “taxable_yn”

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

Overview

The OKL_TXL_AP_INV_LNS_ALL_B table in the OKL (Lease and Finance Management) schema is the primary transaction-line store for lease and finance transactions that are destined to be processed into Oracle Payables invoices. It acts as the staging and persistent record of individual invoice distribution lines generated from lease contracts, consolidations, and payables streams before those lines are transferred to the Payables sub-ledger for accounting and payment processing.

The table is owned by the OKL schema and resides in the ALL namespace, meaning it is not only multi-org enabled but also potentially accessible across operating units where org-level security is not enforced. It is documented as VALID, indicating it is an active, supported object in Oracle EBS releases 12.1.1 and 12.2.2.

From a data modeling perspective, the schema's foreign-key density — with references to GL_CODE_COMBINATIONS, OKL_K_LINES, OKL_CNSLD_AR_STRMS_B, OKL_STRM_TYPE_B, OKL_TRX_AP_INVS_ALL_B, and OKL_PRTFL_CNTRCTS_B — combined with a surrogate primary key and natural business keys, suggests a satellite-leaning classification. In Data Vault terms, this table behaves like a satellite attached to a central invoice/stream hub, capturing descriptive and multi-org attributes about transaction lines rather than serving as an independent hub or pure link.

Key Information Stored

The table contains 51 documented columns. The most significant for functional and reporting purposes include:

• ID — Surrogate primary key (OKL_TXL_AP_INV_LNS_ALL_B_PK) and unique index (OKL_TXL_AP_INV_LNS_ALL_B_U1). This is the technical row identifier, not a business key.
• TAP_ID — Foreign key to OKL_TRX_AP_INVS_ALL_B, identifying the parent Payables invoice header for this line.
• TPL_ID_REVERSES — Self-referencing FK identifying the line this record reverses, used for transaction reversal tracking.
• CODE_COMBINATION_ID — FK to GL_CODE_COMBINATIONS, determining the accounting distribution for the line.
• KLE_ID — FK to OKL_K_LINES, linking to the lease contract line generating the charge.
• LSM_ID — FK to OKL_CNSLD_AR_STRMS_B, identifying the consolidated agreement stream.
• STY_ID — FK to OKL_STRM_TYPE_B, defining the stream or transaction type.
• KHR_ID — FK to OKL_PRTFL_CNTRCTS_B, identifying the portfolio contract or header.
• CNSLD_AP_INV_ID — FK to OKL_CNSLD_AP_INVS_ALL, linking to the consolidated payables invoice.
• LINE_NUMBER — Ordinal line position within the invoice.
• AMOUNT — Monetary value of the transaction line.
• DATE_ACCOUNTING — Accounting date applied to the line.
• ORG_ID — Operating unit identifier supporting multi-org access.
• PAYABLES_INVOICE_ID — Reference to the generated Oracle Payables invoice.
• ERROR_MESSAGE — Captures validation or transfer errors when a line fails Payables import.
• TAXABLE_YN — Flags whether the line is subject to tax.
• OBJECT_VERSION_NUMBER — Optimistic locking column for concurrent update control.

Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) plus 15 ATTRIBUTE flex columns provide audit trail and extensibility.

Common Use Cases and Queries

Typical scenarios for querying this table include reconciliation of lease charges transferred to Payables, troubleshooting invoice transfer errors, and reporting on accounting distributions by contract or stream.

Identifying lines that failed transfer to Payables:

SELECT t.ID, t.TAP_ID, t.LINE_NUMBER, t.AMOUNT, t.ERROR_MESSAGE
FROM   OKL_TXL_AP_INV_LNS_ALL_B t
WHERE  t.ERROR_MESSAGE IS NOT NULL
AND    t.ORG_ID = :p_org_id;

Joining to the parent invoice and lease line for detailed reporting:

SELECT i.INVOICE_NUM, t.LINE_NUMBER, t.AMOUNT, t.DATE_ACCOUNTING, k.CONTRACT_NUMBER
FROM   OKL_TXL_AP_INV_LNS_ALL_B t,
       OKL_TRX_AP_INVS_ALL_B   i,
       OKL_K_LINES             k
WHERE  t.TAP_ID = i.ID
AND    t.KLE_ID = k.ID
AND    t.ORG_ID = :p_org_id;

Reversals are traced by joining the table to itself on TPL_ID_REVERSES = ID. Distribution analysis groups on CODE_COMBINATION_ID after joining GL_CODE_COMBINATIONS to obtain account segments. Because the table is in the ALL namespace, filters on ORG_ID are essential for multi-org–secure reporting.

Related Objects

• OKL_TRX_AP_INVS_ALL_B — Parent invoice header; joined on TAP_ID = ID.
• OKL_K_LINES — Lease contract line generating the charge; joined on KLE_ID = ID.
• GL_CODE_COMBINATIONS — Accounting distribution; joined on CODE_COMBINATION_ID = CODE_COMBINATION_ID.
• OKL_CNSLD_AP_INVS_ALL — Consolidated Payables invoice; joined on CNSLD_AP_INV_ID = ID.
• OKL_CNSLD_AR_STRMS_B — Consolidated stream; joined on LSM_ID = ID.
• OKL_STRM_TYPE_B — Stream type lookup; joined on STY_ID = ID.
• OKL_PRTFL_CNTRCTS_B — Portfolio contract header; joined on KHR_ID = ID.
• OKL_TXL_AR_INV_LNS_B — Receivables invoice lines referencing this table via TPL_ID.
• OKL_TXL_AP_INV_LNS_ALL_B (self) — Reversal relationship via TPL_ID_REVERSES.