Results for “okl_ext_fa_line_sources_b”

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:

• LINE_EXTENSION_ID — the surrogate primary key (OKL_EXT_FA_LINE_SOURCES_B_PK) and also the leading column of unique index U1.
• HEADER_EXTENSION_ID — FK back to the parent header extension row, establishing the header-to-line relationship.
• FA_TRANSACTION_ID — FK to FA_TRANSACTION_HEADERS, identifying the Fixed Assets transaction that produced this line.
• ASSET_ID — FK to FA_ADDITIONS_B, the created or updated asset.
• KLE_ID — FK to OKC_K_LINES_B, the source contract line.
• ASSET_VENDOR_ID — FK to AP_SUPPLIERS.
• ASSET_NUMBER, CONTRACT_LINE_NUMBER, ASSET_VENDOR_NAME, ASSET_BOOK_TYPE_NAME — denormalized descriptive values used for reporting without joins.
• ASSET_BOOK_TYPE_CODE, PERIOD_COUNTER — the asset book and depreciation period context.
• SOURCE_ID, SOURCE_TABLE, INVENTORY_ORG_CODE, INVENTORY_ITEM_NAME_CODE, INSTALLED_SITE_ID — lineage and inventory context.
• LINE_ATTRIBUTE_CATEGORY and LINE_ATTRIBUTE1 through LINE_ATTRIBUTE15 — the standard DFF flexfield block.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — concurrency and audit columns.

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.