Search Results okl_k_headers

Overview

The OKL_K_HEADERS table is a core data object within Oracle E-Business Suite Release 12.1.1 and 12.2.2, specifically for the Lease and Finance Management (OKL) module. It functions as a shadow table that extends the standard Oracle Contracts Core header tables, OKC_K_HEADERS_B and OKC_K_HEADERS_TL. Its primary role is to store lease-specific contract attributes that are not accommodated by the generic contract header structure. This design allows Oracle Lease Management to leverage the robust contract engine while maintaining specialized data fields required for complex lease and finance agreements. The table is central to the contract lifecycle, serving as a nexus for numerous transactional and setup entities within the module.

Key Information Stored

The table's structure is anchored by its primary key column, ID, which uniquely identifies each lease contract header record. A critical foreign key column is KHR_ID, which establishes a recursive relationship within the same table, likely to support hierarchical contract structures or amendments. Another significant foreign key is CRS_ID, which links to the OKL_VP_CHANGE_REQUESTS table, connecting contracts to formal change request processes. While the provided metadata does not list all columns, the table's description confirms it holds specialized attributes for OKL contracts, such as those pertaining to portfolio assignment, insurance, tax calculations, and consolidated accounting streams, which differentiate lease contracts from other agreement types in the system.

Common Use Cases and Queries

This table is integral for reporting and data extraction related to the lease contract portfolio. Common operational and analytical queries involve joining OKL_K_HEADERS with its related transactional tables to gain a comprehensive view of a contract's financial and operational status. For instance, to retrieve a list of contracts with associated insurance policies, a query would join OKL_K_HEADERS to OKL_INS_POLICIES_B. To analyze revenue streams for a set of contracts, a join to OKL_STREAMS on KHR_ID is essential. A fundamental query pattern for fetching core contract header information often follows this structure:

• SELECT okh.* FROM OKL.OKL_K_HEADERS okh WHERE okh.ID = :p_contract_id;

Implementation teams also frequently reference this table during data migrations, integrations, and while developing custom reports for lease accounting, portfolio management, and compliance.

Related Objects

As indicated by its extensive foreign key relationships, OKL_K_HEADERS is a parent table to a wide array of critical OKL entities. Key child tables include:

• OKL_STREAMS and OKL_CNSLD_AR_STRMS_B for payment and accounting streams.
• OKL_INS_POLICIES_B and OKL_INS_POLICIES_ALL_B for insurance policy details.
• OKL_TRX_CONTRACTS for transactional contract data.
• OKL_TRX_AR_INVOICES_B and OKL_TRX_AP_INVOICES_B for receivables and payables invoices.
• OKL_PRTFL_CNTRCTS_B and OKL_POOLS_ALL for portfolio and pool assignment.
• OKL_ACC_GROUP_BAL for accounting group balances.

It maintains a direct relationship with the Oracle Contracts Core tables (OKC_K_HEADERS_B/TL) and is referenced by the change request table (OKL_VP_CHANGE_REQUESTS). This network of relationships underscores its position as the central hub for lease contract data within the EBS architecture.