Results for “okl_k_headers_h”

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

Overview

OKL_K_HEADERS_H is the history (audit) table for OKL_K_HEADERS, the core header entity within the Oracle Lease and Finance Management (OKL) module. It resides in the OKL schema and is classified as VALID in the E-Business Suite 12.1.1 and 12.2.2 releases. In the context of Oracle EBS, this table preserves prior and versioned states of lease, financing, and contract-header records so that point-in-time reconstruction of a deal's financial and structural attributes remains possible after changes are committed to the base OKL_K_HEADERS table.

From a Data Vault modeling perspective, the mined foreign-key structure supports a heuristic classification of standalone. Because the table is keyed on the combination of ID and MAJOR_VERSION and does not participate in downstream dependents as a parent, it behaves less like a hub or link and more like a versioned satellite of the contract-header business entity. This is a modeling suggestion only; Oracle does not document OKL_K_HEADERS_H as a Data Vault construct.

Key Information Stored

The physical schema in ETRM 12.2.2 documents 84 columns. The following are the most operationally significant.

• ID — Surrogate identifier inherited from the base OKL_K_HEADERS record.
• MAJOR_VERSION — Version discriminator for the historical row. Together with ID, it forms the primary key OKL_K_HEADERS_H_PK and the unique business-key candidate OKL_K_HEADERS_H_U1 (ID, MAJOR_VERSION).
• KHR_ID — Foreign key to OKL_PRTFL_CNTRCTS_B, linking the header version to the portfolio contract.
• LEGAL_ENTITY_ID — Foreign key to FV_LEGAL_ENTITIES, identifying the owning legal entity.
• PDT_ID and ISG_ID — Product and internal-sales-group references that classify the financed instrument.
• DATE_FIRST_ACTIVITY, DATE_CONVERSION_EFFECTIVE, DATE_REFINANCED, DATE_DEAL_TRANSFERRED — Lifecycle milestone dates for the deal.
• PRE_TAX_YIELD, AFTER_TAX_YIELD, IMPLICIT_INTEREST_RATE, IMPLICIT_NON_IDC_INTEREST_RATE — Yield and interest-rate measures captured at the version.
• TARGET_PRE_TAX_YIELD, TARGET_AFTER_TAX_YIELD, TARGET_IMPLICIT_INTEREST_RATE, TARGET_IMPLICIT_NONIDC_INTRATE — Target thresholds used for pricing evaluation.
• PRE_TAX_IRR, AFTER_TAX_IRR — Internal rates of return for the version.
• DEAL_TYPE, RECOURSE_CODE, SECURITIZED_CODE, SECURITIZATION_TYPE — Deal classification and securitization attributes.
• TERM_DURATION — Contract term length.
• CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE — Currency conversion context.
• OBJECT_VERSION_NUMBER — Standard EBS optimistic locking column.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — WHO-column audit trail.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield storage.

Common Use Cases and Queries

Typical uses center on audit, reconciliation, and as-of reporting. A straightforward version-listing query returns all historical snapshots of a header:

• SELECT id, major_version, deal_type, pre_tax_yield, after_tax_yield, last_update_date FROM okl.okl_k_headers_h WHERE id = :p_id ORDER BY major_version DESC;
• Point-in-time yield comparison: join OKL_K_HEADERS_H to OKL_K_HEADERS on ID to contrast current versus prior implicit interest rates.
• Portfolio exposure reporting: join to OKL_PRTFL_CNTRCTS_B via KHR_ID to aggregate TOT_CL_FUNDING_AMT or TOT_CL_NET_TRANSFER_AMT by legal entity.
• Legal-entity rollups: join LEGAL_ENTITY_ID to FV_LEGAL_ENTITIES for entity-level reporting.

Related Objects

• OKL_K_HEADERS — Base table for which this table is the history; join on ID and MAJOR_VERSION.
• OKL_PRTFL_CNTRCTS_B — Referenced via KHR_ID.
• FV_LEGAL_ENTITIES — Referenced via LEGAL_ENTITY_ID.
• OKL_K_HEADERS_H_PK / OKL_K_HEADERS_H_U1 — Primary key and unique index on (ID, MAJOR_VERSION).
• OKL_K_LINES_H — Line-level history table that mirrors the header history pattern.
• OKL_K_ITEMS_H — Line-item history typically joined by contract header identity.