Search Results okl_ext_fa_header_sources_b




Overview
Explore in AI Chat

Overview

The OKL_EXT_FA_HEADER_SOURCES_B table is a core data object within Oracle E-Business Suite Release 12.1.1 and 12.2.2, specifically for the OKL (Lease and Finance Management) product module. It functions as a Fixed Assets transactions header extension table. Its primary role is to store supplementary header-level information that extends the standard transaction processing for assets within the leasing and finance management context. This table acts as a critical junction, linking lease or finance transaction headers to related master data entities such as transaction types, parties, and customer accounts, thereby enabling integrated asset and financial tracking.

Key Information Stored

The table's structure is defined by its primary and foreign key columns, which are central to its purpose. The primary identifier is the HEADER_EXTENSION_ID. The key relational columns include KHR_ID, which links to the core transaction header; TRY_ID, which references a transaction type from OKL_TRX_TYPES_B; PARTY_ID, linking to the trading entity in HZ_PARTIES; and CUST_ACCOUNT_ID, connecting to a specific customer account in HZ_CUST_ACCOUNTS. While the provided metadata does not list all attribute columns, the foreign key structure confirms this table's role in enriching transaction headers with specific type, party, and customer context essential for downstream Fixed Assets processing.

Common Use Cases and Queries

This table is integral to processes where lease or finance transactions require detailed Fixed Assets integration. Common use cases include generating asset capitalization reports for specific customers, validating transaction data flows before asset creation, and auditing the sources of fixed asset entries. A typical analytical query would join this table to its referenced master data to provide a comprehensive view. For example:

  • SELECT ext.KHR_ID, tt.NAME, hzp.PARTY_NAME, hca.ACCOUNT_NUMBER FROM OKL.OKL_EXT_FA_HEADER_SOURCES_B ext JOIN OKL.OKL_TRX_TYPES_B tt ON ext.TRY_ID = tt.ID JOIN HZ.HZ_PARTIES hzp ON ext.PARTY_ID = hzp.PARTY_ID JOIN HZ.HZ_CUST_ACCOUNTS hca ON ext.CUST_ACCOUNT_ID = hca.CUST_ACCOUNT_ID WHERE ext.KHR_ID = :p_header_id;

This pattern supports troubleshooting data inconsistencies and building custom reports on asset transaction origins.

Related Objects

The OKL_EXT_FA_HEADER_SOURCES_B table maintains documented foreign key relationships with several fundamental EBS tables, as per the provided metadata. These relationships are crucial for data integrity and application logic:

  • Self-Reference (KHR_ID): The column OKL_EXT_FA_HEADER_SOURCES_B.KHR_ID references the same table, indicating a potential hierarchical or historical linkage between header extension records.
  • OKL_TRX_TYPES_B (TRY_ID): Links to the transaction type master via the TRY_ID column.
  • HZ_PARTIES (PARTY_ID): References the Trading Community Architecture (TCA) party master via the PARTY_ID column.
  • HZ_CUST_ACCOUNTS (CUST_ACCOUNT_ID): References the TCA customer account master via the CUST_ACCOUNT_ID column.

These relationships position the table as a central node connecting OKL transaction data to broader EBS master data and the Fixed Assets module.