Search Results deprn_run_id

Overview

OKL_TRX_HEADER_UV is a consolidated reporting view owned by the APPS schema within the Oracle Lease and Finance Management (OKL) module. It presents a unified transaction header recordset for lease contracts, drawing together transaction identifiers, contract references, transaction types, statuses, amounts, currency, and accounting draft/actual indicators. The view plays a central role in accounting and reporting flows because it exposes a normalized header-level structure that downstream Oracle E-Business Suite reports, integrations, and accounting extraction processes can query without joining the underlying operational tables directly. In releases 12.1.1 and 12.2.2 the object remains VALID and is defined as a UNION ALL of two subqueries, reflecting the fact that lease transactions originate from more than one source construct within the OKL data model.

Underlying Base Objects

The view is defined over a set of core OKL and shared objects. The primary driving objects are OKL_TRX_CONTRACTS_ALL (aliased OTCB), OKC_K_HEADERS_B (OKHB), OKL_TRX_TYPES_V (OTTT), and GL_LEDGERS (GL). Joins link transaction records to their contract header, their transaction type, and the ledger defined by the transaction's set of books. The first UNION ALL branch additionally restricts results with an EXISTS clause against OKL_TXL_CNTRCT_LNS_UV, ensuring only transactions with associated contract lines are returned. The documented dependency list confirms these relationships and shows further indirect dependencies including OKL_ACCOUNTING_UTIL, OKL_TXL_CNTRCT_LNS_UV, OKL_TRX_ASSETS, OKL_BPD_AP_INVOICE_UV, OKL_BPD_AR_HEADER_V, OKL_TRX_TYPES_V, and GL_LEDGERS. Several FA_* and OKL_VIEW_TRX_ASSETS_V references indicate the view family participates in broader asset and accounting reporting chains.

Key Columns

• ID / TRANS_ID — Character representation of OTCB.ID, the unique transaction identifier.
• KHR_ID / CONTRACT_NUMBER — Contract header identifier and contract number from OKC_K_HEADERS_B.
• SOURCE_CODE / SOURCE — Constant 'LEASE' plus its decoded lookup meaning via OKL_VIEW_ACC_SOURCES.
• TRANSACTION_NUMBER — Transaction number, cast to character in the second UNION ALL branch.
• TRANSACTION_TYPE — Descriptive name from OKL_TRX_TYPES_V.
• TRANSACTION_STATUS — Decoded from OKL_TRANSACTION_STATUS using the transaction's TSU_CODE.
• TRANSACTION_DATE — Date the transaction occurred.
• AMOUNT / CURRENCY_CODE — Transaction monetary value and currency.
• ACTUAL_DRAFT_STATUS_CODE / ACTUAL_DRAFT_STATUS — Derived through OKL_ACCOUNTING_UTIL.GET_DRAFT_ACTUAL_TRX against OKL_TXL_CNTRCT_LNS.
• TRY_ID — The transaction type identifier from OKL_TRX_TYPES_V; this is the column referenced by the search term "try_id" and serves as the foreign key linking a transaction header to its type definition.
• ORG_ID, REPRESENTATION_CODE, INVOICE_YN — Operating unit, ledger short name, and a constant 'N' invoice flag.

Common Use Cases and Queries

Typical usage includes accounting reconciliation, transaction-type analysis, and feeding upstream reporting extracts. A frequent query filters by TRY_ID to isolate a particular transaction type, and by KHR_ID to focus on a single contract:

• SELECT TRANSACTION_NUMBER, TRANSACTION_TYPE, TRANSACTION_STATUS, AMOUNT FROM OKL_TRX_HEADER_UV WHERE TRY_ID = :p_try_id;
• SELECT CONTRACT_NUMBER, TRANSACTION_DATE, ACTUAL_DRAFT_STATUS FROM OKL_TRX_HEADER_UV WHERE KHR_ID = :p_khr_id ORDER BY TRANSACTION_DATE;
• SELECT SOURCE, CURRENCY_CODE, SUM(AMOUNT) FROM OKL_TRX_HEADER_UV WHERE ORG_ID = :p_org_id GROUP BY SOURCE, CURRENCY_CODE;

Because several columns are computed through OKL_ACCOUNTING_UTIL functions, queries returning ACTUAL_DRAFT_STATUS can incur additional processing cost, so filtering on indexed identifiers such as TRY_ID, KHR_ID, or ORG_ID before projecting status columns is advisable in high-volume extracts.