Results for “pox_id”

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

Overview

OKL_TRX_AP_INVS_ALL_B is the base table in the Oracle Leasing and Finance Management (OKL) module that stores the collection of all OKL transactions which generate Payables invoices. It acts as the integration bridge between the leasing transaction lifecycle and the Oracle Payables subledger, capturing the invoice header-level information that OKL sends to Payables for vendor payment processing. In Oracle EBS 12.1.1 and 12.2.2 the table resides in the OKL schema and is a VALID, documented object containing 72 columns.

From a Data Vault modeling perspective, the metadata's heuristic classification is satellite-leaning. The table carries a surrogate primary key plus numerous descriptive and foreign-key attributes rather than serving purely as a hub of business keys or a link between entities, so it is best understood as a transactional satellite centered on a single OKL-to-Payables invoice event.

Key Information Stored

The surrogate primary key is ID, supported by unique index OKL_TRX_AP_INVS_ALL_B_U1. The most operationally significant columns include:

• ID — surrogate primary key uniquely identifying each AP-bound invoice record.
• INVOICE_NUMBER and VENDOR_INVOICE_NUMBER — the generated and externally supplied invoice identifiers.
• TRX_STATUS_CODE and INVOICE_TYPE, INVOICE_CATEGORY_CODE — control the invoice state and Payables classification.
• AMOUNT and CURRENCY_CODE — monetary value and currency of the invoice, together with CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, and CURRENCY_CONVERSION_DATE.
• VENDOR_ID — foreign key to AP_SUPPLIERS, identifying the payee.
• TRY_ID — foreign key to OKL_TRX_TYPES_B, classifying the originating transaction.
• CODE_COMBINATION_ID — foreign key to GL_CODE_COMBINATIONS, driving accounting.
• QTE_ID, KHR_ID, ART_ID, TAP_ID_REVERSES — foreign keys linking to quotes, contract headers, asset returns, and reversing invoices respectively.
• LEGAL_ENTITY_ID, SET_OF_BOOKS_ID, ORG_ID — organizational and accounting context.
• DATE_INVOICED, DATE_ENTERED, TRANSACTION_DATE — key date attributes for period reporting.
• OBJECT_VERSION_NUMBER, CREATED_BY, LAST_UPDATE_DATE — concurrency control and audit columns.

The fifteen ATTRIBUTE columns provide the standard EBS descriptive-flexfield extension points.

Common Use Cases and Queries

Typical usage includes reconciling lease-generated invoices to Payables, reporting on unbilled or rejected invoices, and tracing reversals. A common pattern joins the header to its lines and to the transaction type:

• Reporting pending invoices: SELECT id, invoice_number, amount, trx_status_code FROM okl_trx_ap_invs_all_b WHERE trx_status_code = :status.
• Reversal tracing: self-join on TAP_ID_REVERSES to link a reversal to its original invoice.
• Vendor analysis: join VENDOR_ID to AP_SUPPLIERS and TRY_ID to OKL_TRX_TYPES_B.
• Accounting review: join CODE_COMBINATION_ID to GL_CODE_COMBINATIONS and SET_OF_BOOKS_ID for ledger context.
• Line-level detail: join ID to OKL_TXL_AP_INV_LNS_ALL_B.TAP_ID.

Related Objects

• OKL_TXL_AP_INV_LNS_ALL_B — child lines table joined on TAP_ID.
• OKL_TRX_AP_INVS_ALL_B (self) — reversal relationship via TAP_ID_REVERSES.
• OKL_TRX_TYPES_B — transaction type lookup via TRY_ID.
• OKL_K_HEADERS — contract header reference via KHR_ID.
• OKL_TRX_QUOTES_ALL_B — quote reference via QTE_ID.
• OKL_ASSET_RETURNS_ALL_B — asset return reference via ART_ID.
• AP_SUPPLIERS — vendor master via VENDOR_ID.
• GL_CODE_COMBINATIONS — accounting flexfield via CODE_COMBINATION_ID.
• FV_LEGAL_ENTITIES — legal entity context via LEGAL_ENTITY_ID.