Results for “okl_fa_trx_line_uv”

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

Overview

OKL_FA_TRX_LINE_UV is a union view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the OKL - Lease and Finance Management product family and presents a consolidated, line-level picture of Fixed Assets activity arising from leased assets managed within OKL contracts. The view combines two distinct data streams: fixed asset transaction headers (additions, adjustments, transfers, and retirements recorded in FA_TRANSACTION_HEADERS) and depreciation distributions recorded in FA_DEPRN_DETAIL. In effect, it acts as a unified feeder of "FA transaction and depreciation lines" that downstream reporting, accounting extraction, and integration programs can consume without having to join the underlying Fixed Assets tables themselves.

The view is used primarily in lease accounting reconciliation and in the transfer of lease-related asset information into the corporate Fixed Assets book. Each row represents a single transaction or depreciation line for an asset, complete with its book, transaction amount, currency, contract context, and category description.

Underlying Base Objects

Per the documented ETRM metadata, OKL_FA_TRX_LINE_UV is defined over the following referenced base objects:

• OKL_VIEW_TRX_ASSETS_V (VIEW) – supplies the leased asset, asset number, corporate book, and the lease contract ID (DNZ_CHR_ID) linkage.
• OKC_K_HEADERS_ALL_B (SYNONYM) – the contract header, providing CONTRACT_NUMBER, KHR_ID, and the contract status code (STS_CODE) used in date derivation.
• FA_TRANSACTION_HEADERS (SYNONYM) – source of asset transaction header rows and transaction types.
• FA_ADDITIONS (SYNONYM) – links asset_id to its asset category.
• FA_CATEGORIES_B_KFV (VIEW) – the key flexfield category view that supplies the CONCATENATED_SEGMENTS description for the asset category.
• FA_DEPRN_DETAIL (SYNONYM) – the depreciation distribution lines appearing in the UNION ALL half of the view.
• FA_DEPRN_PERIODS (SYNONYM) – depreciation period context used to align amounts to periods.
• OKL_ACCOUNTING_UTIL (PACKAGE) – provides the GET_FA_TRX_AMOUNT, GET_FUNC_CURR_CODE, GET_FA_TRX_START_DATE, and GET_FA_TRX_END_DATE functions that calculate amounts, currency, and effective date ranges.

The join path runs from the OKL view to the contract header, then to FA_TRANSACTION_HEADERS and FA_ADDITIONS, and finally to FA_CATEGORIES_B_KFV. Date filtering is applied with the OKL_ACCOUNTING_UTIL functions so that only transactions falling within the asset's effective FA window are returned. Note that the query also references the user search term fa_categories_b_kfv directly: that key flexfield view supplies the human-readable category description exposed as the DESCRIPTION column.

Key Columns

• ID – composite identifier built as BOOK_TYPE_CODE || '-' || ASSET_NUMBER || '-' || TRANSACTION_HEADER_ID (or PERIOD_COUNTER/DISTRIBUTION_ID for depreciation lines).
• LINE_NUMBER – constant value of 1 for each returned line.
• DESCRIPTION – book type concatenated with the asset category concatenated segments from FA_CATEGORIES_B_KFV.
• AMOUNT – FA transaction amount derived via OKL_ACCOUNTING_UTIL.GET_FA_TRX_AMOUNT for headers, or DEPRN_AMOUNT for depreciation distributions.
• CURRENCY_CODE – functional currency returned by OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE.
• STREAM_TYPE / STREAM_TYPE_PURPOSE – NULL placeholders in the header branch.
• TRANSACTION_ID – book, asset number, and header ID concatenation.
• SOURCE_TABLE – literal 'FA_TRANSACTION_DETAIL' identifying the originating stream.
• ASSET_ID, DISTRIBUTION_ID, PERIOD_COUNTER, BOOK_TYPE_CODE – Fixed Assets keys used for drill-down and reconciliation.
• CONTRACT_NUMBER, KHR_ID – the OKL/OKC lease contract context.

Common Use Cases and Queries

Typical uses include lease-to-FA reconciliation, review of depreciation posted against leased assets, and feeding external accounting or reporting extracts.

List all lines for a given contract:

SELECT id, description, amount, currency_code, book_type_code
FROM   apps.okl_fa_trx_line_uv
WHERE  contract_number = 'LEASE-1001';

Summarize amounts by book and source:

SELECT book_type_code, source_table, SUM(amount) total_amount
FROM   apps.okl_fa_trx_line_uv
GROUP BY book_type_code, source_table;

Reconcile a single asset across transaction and depreciation streams:

SELECT id, amount, source_table, period_counter
FROM   apps.okl_fa_trx_line_uv
WHERE  asset_id = :p_asset_id
ORDER BY source_table, period_counter;

Because amounts and date ranges are computed through OKL_ACCOUNTING_UTIL, the view should be queried in the context of the correct functional currency and accounting period. Its UNION ALL structure means callers should filter on SOURCE_TABLE when only transaction or only depreciation detail is required.