Results for “party_rel_id2_new”

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

Overview

OKL_TRX_CONTRACTS_ALL is the lease transaction header table within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores the top-level attributes of every lease contract processed through ETRM, serving as the master anchor from which lease streams, accounting entries, asset associations, and party relationships descend. Each row represents a single lease transaction identified by a surrogate primary key and qualified by a representation code and transaction number unique within an operating unit.

From a dimensional modeling perspective, the documented foreign-key structure suggests classifying this object as a link in a Data Vault heuristic. It connects independent business hubs — the lease type (OKL_TRX_TYPES_B), the product definition (OKL_PRODUCTS), the quote of origin (OKL_TRX_QUOTES_ALL_B), the associated accounting template set, provisions, and the legal entity — rather than acting as a standalone hub or descriptive satellite. This classification should be treated as a modeling suggestion, since the physical table also carries many descriptive attributes typical of a satellite.

Key Information Stored

The table contains 97 documented columns. The most significant include:

• ID — surrogate primary key defined by index OKL_TRX_CONTRACTS_ALL_PK.
• TRX_NUMBER — the user-facing lease transaction number.
• REPRESENTATION_CODE — business qualifier distinguishing transaction representations; combined with TRX_NUMBER and ORG_ID it forms the unique business key index OKL_TRX_CONTRACTS_ALL_U1.
• ORG_ID — operating unit that owns the transaction, enforcing multi-org security.
• TRY_ID — foreign key to OKL_TRX_TYPES_B, the lease transaction type.
• PDT_ID — foreign key to OKL_PRODUCTS, the financing product.
• KHR_ID / KHR_ID_NEW / KHR_ID_OLD — references to OKL_K_HEADERS, capturing current, new, and prior contract header revisions.
• PVN_ID — foreign key to OKL_PROVISIONS.
• QTE_ID — foreign key to OKL_TRX_QUOTES_ALL_B, linking the contract to its originating quote.
• LEGAL_ENTITY_ID — foreign key to FV_LEGAL_ENTITIES for accounting and legal ownership.
• AMOUNT, CURRENCY_CODE — transaction value and currency, with CURRENCY_CONVERSION_TYPE, RATE, and DATE for revaluation.
• TRANSACTION_DATE, CANCELED_DATE, TRANSACTION_REVERSAL_DATE — key lifecycle dates.
• TMT_STATUS_CODE — processing status flag for downstream ETRM workflows.
• ATTRIBUTE_CATEGORY through ATTRIBUTE15 — the standard EBS extensibility columns.

Common Use Cases and Queries

Typical reporting includes listing active lease contracts by operating unit, reconciling lease originations to quotes, and tracing transaction status for accrual processing. A representative query joining the transaction type and product follows:

• SELECT c.TRX_NUMBER, c.AMOUNT, c.CURRENCY_CODE, t.TRX_TYPE_NAME, p.PRODUCT_NAME FROM OKL_TRX_CONTRACTS_ALL c, OKL_TRX_TYPES_B t, OKL_PRODUCTS p WHERE c.TRY_ID = t.TRY_ID AND c.PDT_ID = p.PDT_ID AND c.ORG_ID = :org_id;
• Filtering by REPRESENTATION_CODE = 'PRIMARY' isolates master contract records from amendments and representations.
• Joining LEGAL_ENTITY_ID to FV_LEGAL_ENTITIES supports legal-entity-level lease exposure reporting.

Related Objects

• OKL_K_HEADERS — joined on KHR_ID, KHR_ID_NEW, and KHR_ID_OLD; supplies contract header detail.
• OKL_TRX_TYPES_B — joined on TRY_ID; defines lease transaction type.
• OKL_PRODUCTS — joined on PDT_ID; defines the financing product.
• OKL_TRX_QUOTES_ALL_B — joined on QTE_ID; the originating quote.
• OKL_PROVISIONS — joined on PVN_ID; reserves and provisions.
• IGI_DOS_TRX_SOURCES — joined on SOURCE_TRX_ID; external transaction sourcing.
• FV_LEGAL_ENTITIES — joined on LEGAL_ENTITY_ID; legal ownership.
• OKL_AE_TMPT_SETS_ALL — joined on AES_ID; accounting template sets.