Search Results jl_co_fa_asset_apprs




Overview
Explore in AI Chat

Overview

JL_CO_FA_ASSET_APPRS is a table within the JL (Latin America Localizations) product family in Oracle EBS 12.1.1 and 12.2.2. It stores appraisal information for fixed assets, acting as the intersection between an appraisal event and the individual assets that were appraised during that event. The table records the appraisal value assigned to each asset along with workflow-oriented status and the standard Oracle EBS audit and concurrent program columns.

The table is owned by the JL schema and is documented as VALID in the ETRM physical schema for 12.2.2, containing 29 columns. Its role in the broader Latin America localization data model is to capture, at the asset level, the results of a parent appraisal transaction. In heuristic Data Vault terms mined from its foreign key structure, this object is satellite-leaning: it carries descriptive and attributed measures (the appraisal value, status, and audit context) that hang off a parent appraisal key rather than forming an independent business hub or acting as a many-to-many link across unrelated hubs.

Key Information Stored

The most significant columns in JL_CO_FA_ASSET_APPRS are the following:

The physical surrogate primary key is JL_CO_FA_ASSET_APPRS_PK, defined on the composite of (APPRAISAL_ID, ASSET_NUMBER). A unique index, JL_CO_FA_ASSET_APPRS_U1, is documented on the same two columns, confirming that this pair is the business-key candidate and that each asset may appear at most once per appraisal.

Common Use Cases and Queries

Typical usage centers on reporting appraised asset values, validating that all assets belonging to an appraisal were processed, and reconciling appraisal results against fixed asset balances for Latin America localization reporting.

Listing all assets for a given appraisal:

  • SELECT asset_number, appraisal_value, status FROM jl_co_fa_asset_apprs WHERE appraisal_id = :p_appraisal_id ORDER BY asset_number;

Retrieving the appraisal context by joining to the parent table:

  • SELECT a.appraisal_id, a.asset_number, a.appraisal_value, p.<parent_col> FROM jl_co_fa_asset_apprs a JOIN jl_co_fa_appraisals p ON a.appraisal_id = p.appraisal_id WHERE a.status = 'APPROVED';

Summing appraised values per appraisal event:

  • SELECT appraisal_id, SUM(appraisal_value) FROM jl_co_fa_asset_apprs GROUP BY appraisal_id;

Because the primary key already includes ASSET_NUMBER, queries that filter on asset_number alone will generally benefit from additional indexing or careful plan review.

Related Objects

The following objects are most significant in relation to JL_CO_FA_ASSET_APPRS:

  • JL_CO_FA_APPRAISALS — Parent appraisal header table, joined on APPRAISAL_ID (documented foreign key).
  • JL_CO_FA_ASSET_APPRS_PK — Primary key constraint on (APPRAISAL_ID, ASSET_NUMBER).
  • JL_CO_FA_ASSET_APPRS_U1 — Unique index on (APPRAISAL_ID, ASSET_NUMBER), the business-key candidate.
  • FA_ADDITIONS / FA_BOOKS — Fixed asset tables that can be joined on ASSET_NUMBER to compare appraised values with book values.
  • FND_CONCURRENT_REQUESTS — Joinable on REQUEST_ID to trace the concurrent program that produced or updated appraisal rows.