Search Results jl_co_fa_appraisals_u1

Overview

JL.JL_CO_FA_APPRAISALS is a transactional header table within the Oracle E-Business Suite Colombian Localizations (JL) product, classified under the business entity FA_ASSET. It stores the header-level records for Colombian technical appraisals of fixed assets, capturing who performed the appraisal, the currency and fiscal year involved, and the current appraisal status. The entity supports the Colombian Technical Appraisals Mass Upload process, which allows organizations to register appraisal data for many assets in a single operation.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. Its primary key is JL_CO_FA_APPRAISALS_PK, defined on APPRAISAL_ID. A unique index, JL_CO_FA_APPRAISALS_U1, also exists on APPRAISAL_ID and is stored in the APPS_TS_TX_IDX tablespace. The ETRM heuristic Data Vault classification for this object is hub-leaning, suggesting it functions as a central business-key entity around which appraisal detail records are organized. It references FND_CURRENCIES through CURRENCY_CODE and is referenced by two child tables, JL_CO_FA_APPRAISAL_BOOKS and JL_CO_FA_ASSET_APPRS.

Key Information Stored

The most significant columns of JL_CO_FA_APPRAISALS are:

• APPRAISAL_ID – System-generated appraisal identification number. This is the surrogate primary key and the column on which the unique index JL_CO_FA_APPRAISALS_U1 is defined.
• APPRAISAL_DATE – The date on which the appraisal was performed.
• CURRENCY_CODE – The currency in which the appraisal is expressed; foreign key to FND_CURRENCIES.
• FISCAL_YEAR – The fiscal year of the appraisal. It must be higher than 1990.
• APPRAISER_NAME – Name of the appraiser.
• APPRAISER_ADDRESS1 / APPRAISER_ADDRESS2 – Two address lines for the appraiser.
• APPRAISER_PHONE – Appraiser's telephone number.
• APPRAISER_CITY – City of residence of the appraiser.
• APPRAISAL_STATUS – Current status of the appraisal. When validated, an Error status is assigned if one or more assets in the appraisal are invalid while the appraisal-level information remains valid.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard Who columns for audit tracking.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 – Descriptive flexfield columns supporting extensible attribute capture.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE – Concurrent program context columns identifying the mass upload request that created or updated the row.

The table contains 35 columns in total, as documented in the ETRM 12.2.2 physical schema.

Common Use Cases and Queries

Typical usage centers on reviewing, validating, and reconciling appraisal headers. Common reporting scenarios include listing appraisals by fiscal year, filtering by status, or joining to child asset detail records.

• Retrieve appraisals for a given fiscal year:

  SELECT appraisal_id, appraisal_date, appraiser_name, appraisal_status
  FROM   jl.jl_co_fa_appraisals
  WHERE  fiscal_year = :fiscal_year;

• Identify failed appraisals requiring correction:

  SELECT appraisal_id, appraiser_name, appraisal_status
  FROM   jl.jl_co_fa_appraisals
  WHERE  appraisal_status = 'ERROR';

• Validate currency codes against the cleared currencies:

  SELECT a.appraisal_id, a.currency_code, f.name
  FROM   jl.jl_co_fa_appraisals a, fnd_currencies f
  WHERE  a.currency_code = f.currency_code;

• Trace the concurrent request that loaded an appraisal:

  SELECT appraisal_id, request_id, program_id, program_update_date
  FROM   jl.jl_co_fa_appraisals
  WHERE  request_id = :request_id;

Reporting use cases include audit trails of appraiser details, currency exposure summaries per fiscal year, and exception reports for appraisals with Error status awaiting asset corrections.

Related Objects

• JL.JL_CO_FA_APPRAISAL_BOOKS – Child table referencing APPRAISAL_ID; stores appraisal book information associated with the header.
• JL.JL_CO_FA_ASSET_APPRS – Child table referencing APPRAISAL_ID; holds individual asset appraisal lines belonging to the header.
• FND_CURRENCIES – Parent reference table resolved through CURRENCY_CODE.
• JL_CO_FA_APPRAISALS_PK – Primary key constraint on APPRAISAL_ID.
• JL_CO_FA_APPRAISALS_U1 – Unique index on APPRAISAL_ID, forming the documented business-key candidate.

Together these objects form the appraisal header-detail hierarchy used by the Colombian Technical Appraisals Mass Upload process in Oracle EBS 12.1.1 and 12.2.2.