Results for “okl_k_headers”

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

Overview

OKL_K_HEADERS is a shadow table owned by the OKL schema in Oracle Lease and Finance Management (OKL), a module of Oracle E-Business Suite 12.1.1 and 12.2.2. It is the Lease Management extension of the Oracle Contracts Core contract header, which is stored in OKC_K_HEADERS_B and OKC_K_HEADERS_TL. OKL_K_HEADERS holds contract header attributes specific to leases and financings — terms, yields, securitization and recourse flags, funding and trade-in information — that do not fit the standard Contracts header structure. As a documented physical object, OKL_K_HEADERS is VALID and contains 83 columns.

In Data Vault modeling terms, the heuristic classification of this table is hub-leaning. This reflects its role as a durable, business-key-bearing registry of contract headers, referenced extensively by downstream transactional and analytical satellites rather than being a pure transactional log. It should be treated as a candidate hub in any downstream Data Vault or dimensional design, with the caveat that it also carries descriptive attributes that would traditionally be separated into satellite structures.

Key Information Stored

The surrogate primary key is ID, enforced by OKL_K_HEADERS_PK, with a unique index OKL_K_HEADERS_U1 also defined on ID. ID is the row identifier and is distinct from KHR_ID, which is the Contracts Core header identifier used to join back to OKC_K_HEADERS_B and OKC_K_HEADERS_TL. Notably, KHR_ID is self-referencing within OKL_K_HEADERS and is the column most referenced by the many child tables in the module.

• ID — surrogate primary key of the shadow row.
• KHR_ID — foreign key to the Contracts Core header; the principal join key across the OKL schema.
• ISG_ID, PDT_ID — lineage and product technical definition references.
• OBJECT_VERSION_NUMBER — optimistic locking and change detection.
• Deal and yield constraints — PRE_TAX_YIELD, AFTER_TAX_YIELD, IMPLICIT_INTEREST_RATE, IMPLICIT_NON_IDC_INTEREST_RATE, PRE_TAX_IRR, AFTER_TAX_IRR, DEAL_TYPE.
• Structural flags — SYNDICATABLE_YN, SALESTYPE_YN, RECOURSE_CODE, ASSIGNABLE_YN, SECURITIZED_CODE, SECURITIZATION_TYPE.
• Funding and credit attributes — REVOLVING_CREDIT_YN, TOT_CL_TRANSFER_AMT, TOT_CL_NET_TRANSFER_AMT, TOT_CL_LIMIT, TOT_CL_FUNDING_AMT, DATE_FUNDING_EXPECTED.
• Trade-in and delivery — TRADEIN_DESCRIPTION, TRADEIN_AMOUNT, DATE_TRADEIN, EXPECTED_DELIVERY_DATE.
• Accounting/GAAP indicators — GENERATE_ACCRUAL_YN, MULTI_GAAP_YN, CONVERTED_ACCOUNT_YN, CREDIT_ACT_YN.
• Change tracking — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and the ATTRIBUTE_CATEGORY/ATTRIBUTE1–15 flexfield set.

Common Use Cases and Queries

The most frequent operational requirement is resolving an OKL contract to its full header, joining the lease-specific shadow row to the Contracts Core header:

SELECT k.ID, k.KHR_ID, k.DEAL_TYPE, k.PRE_TAX_YIELD, k.SECURITIZED_CODE FROM OKL.OKL_K_HEADERS k WHERE k.KHR_ID = :p_khr_id;

Downstream reporting frequently joins OKL_K_HEADERS to OKL_TRX_CONTRACTS via KHR_ID to view executed and quoted transactions alongside lease terms. Change-tracking queries use DATE_REFINANCED, DATE_CONVERSION_EFFECTIVE, and DATE_DEAL_TRANSFERRED to reconstruct the lease lifecycle. Credit and funding exposure reports aggregate TOT_CL_LIMIT and TOT_CL_FUNDING_AMT by LEGAL_ENTITY_ID, joining to FV_LEGAL_ENTITIES. Scenarios prioritizing yield analysis combine the pre-tax and after-tax yield and IRR columns with implicit interest rate fields, while securitization research filters on SECURITIZABLE and ASSIGNABLE flags. As KHR_ID is the operational foreign key, index usage on OKL_K_HEADERS_U1 and the KHR_ID index supports most of these access paths.

Related Objects

The tables below represent the most significant dependencies documented in the ETRM metadata, using the actual join columns:

• OKC_K_HEADERS_B / OKC_K_HEADERS_TL — Contracts Core header base and translation tables; OKL_K_HEADERS is the OKL shadow for these, joined via KHR_ID.
• OKL_TRX_CONTRACTS / OKL_TRX_CONTRACTS_ALL — transaction contracts referencing headers via KHR_ID, KHR_ID_NEW, and KHR_ID_OLD.
• OKL_STREAMS — payment and cash flow streams joined on KHR_ID.
• OKL_TXL_CNTRCT_LNS / OKL_TXL_CNTRCT_LNS_ALL — contract lines linked via KHR_ID.
• OKL_INS_POLICIES_B / OKL_INS_POLICIES_ALL_B — insurance policy headers associated to the lease via KHR_ID.
• OKL_PRTFL_CNTRCTS_B — portfolio-to-contract mapping via KHR_ID.
• OKL_POOLS_ALL / OKL_POOLS — lease pooling assignments via KHR_ID.
• OKL_CNSLD_AR_LINES_B / OKL_CNSLD_AR_STRMS_B — consolidated receivable lines and streams via KHR_ID.
• OKL_VP_CHANGE_REQUESTS — change requests referenced by OKL_K_HEADERS.CRS_ID.
• FV_LEGAL_ENTITIES — legal entity referenced by LEGAL_ENTITY_ID.