Search Results jl_co_fa_appraisals




Overview
Explore in AI Chat

Overview

The JL_CO_FA_APPRAISALS table resides in the JL schema and belongs to the JL – Latin America Localizations product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores information about the technical appraisal header, which is the parent record for asset appraisal activities used primarily by Colombian fixed asset localization functionality (avalúo técnico). Each row represents a single appraisal event, capturing when the appraisal occurred, who performed it, and the currency and fiscal context in which it was executed.

The object is documented as VALID and carries 35 columns in the ETRM 12.2.2 physical schema. Based on the foreign key topology mined from the metadata, this table exhibits hub-leaning characteristics in a Data Vault modeling sense: it holds a stable business key (APPRAISAL_ID) referenced by satellite-like dependent tables rather than acting as a transactional link. This classification is a heuristic suggestion and should be validated against the actual business key semantics before applying Data Vault design.

Key Information Stored

The table is anchored by the surrogate primary key APPRAISAL_ID, enforced by JL_CO_FA_APPRAISALS_PK. A unique index, JL_CO_FA_APPRAISALS_U1, is also defined on APPRAISAL_ID, making it the documented business-key candidate as well as the technical identifier.

Common Use Cases and Queries

Typical reporting scenarios include listing appraisals by fiscal year, tracing which assets were appraised during a given event, and auditing who executed or last modified an appraisal record. A representative join against the child books table retrieves appraisal headers with their book-level detail:

  • Appraisal header lookup: SELECT appraisal_id, appraisal_date, currency_code, fiscal_year, appraisal_status FROM jl_co_fa_appraisals WHERE fiscal_year = :year;
  • Header-to-book join: SELECT a.appraisal_id, a.appraisal_date, b.* FROM jl_co_fa_appraisals a, jl_co_fa_appraisal_books b WHERE a.appraisal_id = b.appraisal_id;
  • Asset linkage: SELECT a.appraisal_id, x.asset_id FROM jl_co_fa_appraisals a, jl_co_fa_asset_apprs x WHERE a.appraisal_id = x.appraisal_id;
  • Appraiser activity audit grouped by APPRAISER_NAME and APPRAISAL_STATUS.
  • Concurrent program traceability using REQUEST_ID and PROGRAM_ID.

Related Objects

The following documented relationships are most significant for joins and dependency analysis:

  • JL_CO_FA_APPRAISAL_BOOKS – child table joined via APPRAISAL_ID; holds book-level appraisal lines.
  • JL_CO_FA_ASSET_APPRS – child table joined via APPRAISAL_ID; links appraisals to individual assets.
  • FND_CURRENCIES – referenced through CURRENCY_CODE for currency validation and description lookup.
  • Standard EBS FND audit and concurrent manager views referencing CREATED_BY, LAST_UPDATED_BY, and REQUEST_ID.