Search Results inventory_org_code




Overview
Explore in AI Chat

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

Overview

OKL_EXT_FA_LINE_SOURCES_B is a Fixed Assets transactions line extension table within the OKL (Leasing and Finance Management) product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It resides in the OKL schema and stores the line-level detail that links Oracle Lease Management contract lines to the Fixed Assets transactions generated from them. Where the corresponding header extension table captures the transaction-level context, this table records one row per asset or contract line sourced into a Fixed Assets transaction, preserving identifiers for the contract line, the resulting asset, the transaction header, and the vendor.

From a Data Vault modeling perspective, the FK structure mined from the schema suggests this object behaves as a link table. Its foreign keys point outward to independent business entities — FA_TRANSACTION_HEADERS, FA_ADDITIONS_B, OKC_K_LINES_B, and AP_SUPPLIERS — while its own unique indexes carry the composite business keys that bind those entities together for a given asset capitalization event.

Key Information Stored

The table contains 39 documented columns. The most significant are:

Unique index U2 covers (FA_TRANSACTION_ID, ASSET_ID), and U3 covers (FA_TRANSACTION_ID, ASSET_BOOK_TYPE_CODE, PERIOD_COUNTER, ASSET_ID), both being business-key candidates.

Common Use Cases and Queries

Typical reporting reconciles lease contract lines against the assets capitalized in Fixed Assets. A representative query joins the table to its header and to FA_ADDITIONS_B:

  • Trace a capitalized asset back to its originating contract line: select KLE_ID, CONTRACT_LINE_NUMBER, SOURCE_TABLE and SOURCE_ID for a given ASSET_ID.
  • Audit all lines of a transaction: filter on FA_TRANSACTION_ID and join to FA_TRANSACTION_HEADERS.
  • Period-level asset reporting using ASSET_BOOK_TYPE_CODE and PERIOD_COUNTER, leveraging index U3.
  • Vendor analysis by joining ASSET_VENDOR_ID to AP_SUPPLIERS.
  • DFF extraction via LINE_ATTRIBUTE_CATEGORY and LINE_ATTRIBUTE1–15.

Related Objects

  • FA_TRANSACTION_HEADERS — joined on FA_TRANSACTION_ID.
  • FA_ADDITIONS_B — joined on ASSET_ID.
  • OKC_K_LINES_B — joined on KLE_ID.
  • AP_SUPPLIERS — joined on ASSET_VENDOR_ID.
  • OKL_EXT_FA_HEADER_SOURCES_B — parent header extension, joined on HEADER_EXTENSION_ID.
  • OKL_EXT_FA_LINE_SOURCES_B (self-reference) — HEADER_EXTENSION_ID and other internal links.
  • OKL_EXT_FA_LINE_SOURCES_TL / _V — translation and view layers that expose this base table to OAF and reporting.