Search Results contract_status_code




Overview
Explore in AI Chat

Overview

The OKL_EXT_FA_HEADER_SOURCES_B table is a Fixed Assets transaction header extension table within the Oracle Lease and Finance Management (OKL) module. It resides in the OKL schema and serves as an extension staging and reference point for header-level data that Oracle Lease and Finance Management passes to Oracle Fixed Assets during asset conversion, transfer, and accounting integration processes. The table carries a documented column count of 77 and holds a VALID status in the ETRM 12.1.1 and 12.2.2 data dictionaries.

Based on the foreign key structure — which references master entities such as OKL_TRX_TYPES_B, HZ_PARTIES, and HZ_CUST_ACCOUNTS, alongside a self-referencing key on KHR_ID — the heuristic Data Vault classification for this object is a link. This suggests the table primarily models associations between lease contract headers, transaction types, and customer parties rather than acting as a standalone hub or an attribute-only satellite.

Key Information Stored

The table is anchored by the surrogate primary key HEADER_EXTENSION_ID, enforced through the OKL_EXT_FA_HEADER_SOURCES_B_PK constraint and also covered by the unique index OKL_EXT_FA_HEADER_SOURCES_B_U1, which represents the business-key candidate. Among the most operationally significant columns are:

Common Use Cases and Queries

Typical usage centers on tracing Fixed Assets conversion activity back to lease contracts and verifying that header-level source data is complete before the assets interface is processed. A common pattern joins the extension row to the transaction type and customer tables:

  • Reporting on contracts pending conversion, filtered on CONVERTED_ACCOUNT_FLAG = 'N'.
  • Auditing the source table and source ID for every fixed asset header record.
  • Extracting customer and contract context by joining on PARTY_ID, CUST_ACCOUNT_ID, and KHR_ID.
  • Reviewing attribute flexfield values for reconciliation and exception handling.
  • Reconciling contract numbers between OKL and Fixed Assets using CONTRACT_NUMBER and CONVERTED_NUMBER.

Related Objects

The most significant related objects are those joined via the documented foreign keys:

  • OKL_TRX_TYPES_B — joined on TRY_ID to resolve transaction type details.
  • HZ_PARTIES — joined on PARTY_ID for customer party master data.
  • HZ_CUST_ACCOUNTS — joined on CUST_ACCOUNT_ID for customer account context.
  • OKL_EXT_FA_HEADER_SOURCES_B (self) — joined on KHR_ID to relate extension rows sharing a contract header.
  • Oracle Fixed Assets interface tables, which consume the header extension data during asset conversion.