Search Results okl_ext_ap_header_sources_b




Overview
Explore in AI Chat

Overview

The OKL_EXT_AP_HEADER_SOURCES_B table is a core extension table within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as a critical integration point between the Payables (AP) and Lease Management systems. Its primary role is to store extended header-level information for Payables transactions that are sourced from lease or finance management activities. This table enables the OKL module to maintain and reference specific business context—such as the related lease contract, transaction type, and customer—for invoices and other payables documents generated within the leasing lifecycle, ensuring financial data integrity across modules.

Key Information Stored

The table's structure is designed to link a standard Oracle Payables transaction header to its originating lease contract and associated business entities. The primary key is the HEADER_EXTENSION_ID, which uniquely identifies each extended header record. Other crucial columns establish these business relationships. The KHR_ID column stores the foreign key to the lease contract (OKL_K_HEADERS_B). The TRY_ID links to the transaction type definition in OKL_TRX_TYPES_B. For customer information, the table references the Trading Community Architecture via PARTY_ID (HZ_PARTIES) and CUST_ACCOUNT_ID (HZ_CUST_ACCOUNTS). Collectively, these columns allow the system to trace a payable transaction back to its precise lease-based source.

Common Use Cases and Queries

A primary use case is generating reports or conducting audits to reconcile Accounts Payable invoices with their underlying lease contracts. For instance, an analyst may need to list all payables invoices created for a specific lease customer. A typical query would join this table to the standard AP invoice headers (AP_INVOICES_ALL) via the common header identifier and to the customer tables.

  • Sample Query Pattern: SELECT aia.invoice_num, oeahs.khr_id, hca.account_number FROM ap_invoices_all aia JOIN okl_ext_ap_header_sources_b oeahs ON aia.[header_id_column] = oeahs.[ap_header_id] JOIN hz_cust_accounts hca ON oeahs.cust_account_id = hca.cust_account_id WHERE oeahs.khr_id = :p_lease_id;
  • Integration Logic: The table is populated during the invoice creation process from lease transactions, such as maintenance charges or lease payments payable to a vendor. It is essential for downstream processes that require lease context for payables data validation or allocation.

Related Objects

The table sits at the center of a defined relational model within the OKL schema. Its primary key is referenced by the OKL_EXT_AP_LINE_SOURCES_B table (via HEADER_EXTENSION_ID), which stores extended line-level information, creating a header-line relationship. It is a child table to several key master data entities via foreign key constraints:

  • OKL_K_HEADERS_B: Joined on KHR_ID. This is the central lease contract table.
  • OKL_TRX_TYPES_B: Joined on TRY_ID. Provides the transaction type classification.
  • HZ_PARTIES: Joined on PARTY_ID. Provides the party master data.
  • HZ_CUST_ACCOUNTS: Joined on CUST_ACCOUNT_ID. Provides the customer account details.

This network of relationships ensures that every extended payable header is explicitly tied to a valid lease contract, transaction type, and customer within the EBS ecosystem.