Search Results fii_proj_task_lcv

Overview

FII_PROJ_TASK_LCV is a source view in the Oracle E-Business Suite Financial Intelligence (FII) product family, which underpins the Enterprise Data Warehouse (EDW) and the associated dimensional model used for analytical reporting. The view is documented as the Project Task level source view for the Project dimension in the EDW. Its purpose is to expose task-level attributes from the transactional EBS schema in a flattened, denormalized form suitable for extraction, transformation, and loading into the analytical Project dimension. In Oracle EBS 12.1.1 and 12.2.2, FII objects of this type act as the bridge between the operational Projects (PA) tables and the reporting layer.

The ETRM record classifies the owning product as FII - Financial Intelligence, and the product status is noted as Obsolete. Implementation/DBA data for the object indicates it is "Not implemented in this database," and no owner is documented. These factors indicate that FII_PROJ_TASK_LCV is a legacy or contract view that may not be deployed in all environments, and its availability depends on whether the FII/EDW collection schemas have been installed.

Underlying Base Objects

According to the documented view text, FII_PROJ_TASK_LCV is defined over a single documented source object: FIIBV_PROJ_TASK_LCV. The "BV" and "LCV" naming conventions suggest a Business View / logical source view layered beneath this published interface view. The metadata states that no referenced base tables are documented, so the underlying physical tables are abstracted behind FIIBV_PROJ_TASK_LCV and are not enumerated in the available record.

The view is a simple projection. It selects columns directly from FIIBV_PROJ_TASK_LCV without joins, filters, or aggregation. Several trailing positions in the SELECT list are hard-coded NULL literals (USER_ATTRIBUTE1 through USER_ATTRIBUTE5), which are placeholder columns reserved for descriptive flexfield or user-defined attribute content that is not populated by this view.

Key Columns

• TASK_PK — Primary key surrogate for the project task; the join key to the EDW Project dimension.
• NAME — Descriptive name of the task.
• TASK and TASK_NUMBER — The task identifier and its user-visible number.
• TOP_TASK_FK — Foreign key to the top-level (parent) task, supporting task hierarchies.
• INSTANCE — Instance qualifier associated with the task record.
• TASK_START_DATE and TASK_END_DATE — Planned or actual start and end dates for the task.
• SERVICE_TYPE_CODE — Service type classification for the task.
• LABOR_COST_MULT — Labor cost multiplier used in costing calculations.
• DENORM_TASK_ORG_FK — Denormalized foreign key to the task organization.
• LAST_UPDATE_DATE — Standard EBS audit column indicating the last modification timestamp.
• USER_ATTRIBUTE1–5 — Placeholder attributes returned as NULL.

Common Use Cases and Queries

Typical usage centers on populating or validating the Project dimension at task granularity, and on ad hoc reporting that requires task-level descriptive and date attributes. A representative query retrieving active task attributes is shown below. Because the object may not be implemented in a given database, availability should be confirmed against ALL_VIEWS before use.

SELECT TASK_PK,
       NAME,
       TASK_NUMBER,
       TOP_TASK_FK,
       TASK_START_DATE,
       TASK_END_DATE,
       SERVICE_TYPE_CODE,
       LABOR_COST_MULT,
       DENORM_TASK_ORG_FK,
       LAST_UPDATE_DATE
FROM   FII_PROJ_TASK_LCV
WHERE  TASK_END_DATE IS NULL
   OR  TASK_END_DATE >= SYSDATE
ORDER BY TASK_NUMBER;

For hierarchical analysis, the view can be self-joined on TASK_PK and TOP_TASK_FK to reconstruct parent-child task relationships. In ETL context, the view serves as an extraction source whose TASK_PK is matched to staging structures before loading the Project dimension. Given its obsolete classification and undocumented base tables, deployments should verify existence and dependencies prior to relying on the object in production interfaces.