Results for “okl_fa_dist_uv”

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

Overview

The OKL_FA_DIST_UV view is a business-critical database object within the Oracle E-Business Suite (EBS) OKL – Lease and Finance Management module. Its primary function is to consolidate and expose General Ledger (GL) distribution and Fixed Asset (FA) accounting information specifically related to lease contracts. It serves as a vital integration point, bridging the operational data from the Lease Management module with the financial data stored in Oracle Assets and Oracle General Ledger.

As a "User View" (UV), it is designed to present a denormalized and business-oriented perspective of the underlying distribution transactions. It abstracts the complexity of the core transaction tables (FA_ADJUSTMENTS, FA_DEPRN_DETAIL, and FA_DISTRIBUTION_HISTORY) and provides a simplified, single-row-per-distribution interface. This view is instrumental for generating reconciliation reports, auditing lease accounting entries, and verifying the accurate transfer of lease obligations to the Fixed Asset register. It plays a pivotal role in ensuring financial integrity by allowing accountants to trace summarized lease adjustments and depreciation amounts back to specific asset distributions and accounting periods. This view is valid and available in both EBS 12.1.1 and 12.2.2 environments, with minor structural consistency differences but identical core purpose.

Underlying Base Objects

The view is defined with a UNION ALL query that combines data from two distinct accounting streams within Oracle Assets: asset adjustments and depreciation detail. It is owned by the APPS schema and references several key Fixed Asset tables as synonyms, including:

• FA_ADJUSTMENTS: Provides data on asset cost adjustments, financial adjustments, and revaluations. The union query specifically filters for adjustments where SOURCE_TYPE_CODE <> 'DEPRECIATION' and ADJUSTMENT_AMOUNT > 0.
• FA_ADDITIONS: Supplies the ASSET_NUMBER, which is used to construct the unique identifier for each row, linking the accounting entry to a specific asset.
• FA_TRANSACTION_HEADERS: Used in the first union block to derive the ACCOUNTING_DATE from TRANSACTION_DATE_ENTERED.
• FA_DEPRN_DETAIL: Sources depreciation distribution lines for the second part of the union query.
• FA_DEPRN_PERIODS: This table is used, though not explicitly in the provided text, to derive the PERIOD_COUNTER and other period-based attributes for depreciation records.
• FA_DISTRIBUTION_HISTORY: The user searched for "fa_distribution_history"; this view connects to that table via the CODE_COMBINATION_ID and ASSET_ID in the broader context of distribution tracking. However, the provided view text shows it directly joining FA_DEPRN_DETAIL and FA_ADJUSTMENTS to FA_ADDITIONS, with FA_DISTRIBUTION_HISTORY serving as the historical distribution repository for cost and depreciation expense accounts.
• FA_LOOKUPS: Used to translate lookup codes (like the depreciation source or debit/credit flag) into user-friendly meanings (e.g., AE_LINE_TYPE_MEANING).
• GL_JE_LINES: This table is referenced in the metadata, likely used in the view's definition to determine the POSTED status by checking for the existence of a Journal Entry header ID, or to pull additional journal details not shown in the excerpt.
• OKL_ACCOUNTING_UTIL (Package): A custom lease management package that provides critical utility functions like GET_CONCAT_SEGMENTS, GET_CONCATE_DESC, and GET_LOOKUP_MEANING to resolve the concatenated flexfield segments and descriptive meanings for the accounting codes.

Key Columns

The view exposes a wide range of columns that provide a complete financial picture of a lease-related asset transaction. The most critical columns are:

• ID: A unique identifier generated by concatenating BOOK_TYPE_CODE, ASSET_NUMBER, and TRANSACTION_HEADER_ID or PERIOD_COUNTER. This is a composite primary key for the view's rows.
• AE_LINE_TYPE: Derived from ADJUSTMENT_TYPE (for adjustments) or DEPRN_SOURCE_CODE (for depreciation). It categorizes the type of accounting entry.
• CODE_COMBINATION_ID & CONCATE_SEGMENTS: The raw ID and the fully concatenated account string, which are essential for financial reporting and validation.
• CONCATE_SEGMENTS_DESC: The descriptive name of the accounting flexfield combination.
• AE_LINE_TYPE_MEANING: A user-friendly description of the line type (e.g., "Cost Adjustment", "Revaluation").
• CR_DR_FLAG / DR_CR_FLAG_MEANING: Indicates whether the amount is a Debit ('D') or Credit ('C'), along with its translated meaning. This is crucial for determining the balance impact.
• AMOUNT: The monetary value of the adjustment or depreciation. Note that for depreciation, this is calculated as DEPRN_AMOUNT - N.
• ACCOUNTING_DATE: The date the transaction was entered, used for period-close and reporting.
• POSTED: A Yes/No flag indicating whether a journal entry has been created for this transaction in GL (JE_HEADER_ID is not null).
• ASSET_ID & DISTRIBUTION_ID: Foreign keys linking the line to the specific asset and its distribution in the subledger.
• SOURCE_TABLE: A literal value, "FA_TRANSACTION_DETAIL", indicating the origin of the data for the first part of the union.

Common Use Cases and Queries

This view is typically used for reconciliation and auditing. A common use case is to identify unposted lease adjustments, which is critical before closing an accounting period.

To find all unposted lease transactions that require journal entries:

SELECT ID, ACCOUNTING_DATE, CONCATE_SEGMENTS, AMOUNT, AE_LINE_TYPE_MEANING
FROM APPS.OKL_FA_DIST_UV
WHERE POSTED = 'No'
ORDER BY ACCOUNTING_DATE DESC;

Another frequent scenario is reconciling the total leased asset value for a specific asset number. This query lists all debit adjustments (cost additions) for a given asset:

SELECT ID, CODE_COMBINATION_ID, CONCATE_SEGMENTS, AMOUNT
FROM APPS.OKL_FA_DIST_UV
WHERE SOURCE_ID LIKE '%-ASSET_NUMBER-%-%' 
AND CR_DR_FLAG = 'D' 
AND AE_LINE_TYPE = 'COST';

Finally, for audit purposes, a query can retrieve all distributions for a specific accounting period to verify the total depreciation expense posted:

SELECT CODE_COMBINATION_ID, SUM(AMOUNT)
FROM APPS.OKL_FA_DIST_UV
WHERE AE_LINE_TYPE = 'DEPRECIATION'
AND ACCOUNTING_DATE BETWEEN '01-JAN-2024' AND '31-JAN-2024'
GROUP BY CODE_COMBINATION_ID;

These use cases demonstrate the view's utility in providing a transparent and actionable view of lease-related financial data from the EBS database.