Search Results project_pk

Overview

FII_PROJ_PROJECT_LCV is a Project-level source view owned by the APPS schema within the FII (Financial Intelligence) product family of Oracle E-Business Suite. Its documented purpose is to serve as the source view for the Project dimension in the Enterprise Data Warehouse (EDW). In the EBS 12.1.1 and 12.2.2 architecture, FII views such as this one act as staging and extraction surfaces that flatten project master data into a conformed dimension record consumable by the Financial Intelligence and Daily Business Intelligence reporting stacks. The view is marked VALID in the data dictionary, confirming it compiles and resolves cleanly against its underlying dependency. Because it exposes a denormalized column set keyed on PROJECT_PK, it is commonly referenced by ETL mappings, BI Publisher reports, and ad hoc SQL against the Project dimension.

Underlying Base Objects

Per the documented metadata, the view text is a straight projection over a single underlying object: FIIBV_PROJ_PROJECT_LCV. No additional base tables are documented as direct dependencies in the ETRM record. The "_LCV" suffix in both the view and its source object conventionally denotes a "level current view," the layer that resolves the current effective row for each project before presentation. FIIBV_PROJ_PROJECT_LCV is the business view in the FII business view (BV) tier; FII_PROJ_PROJECT_LCV is the public-facing APPS synonym/view through which EDW extraction and reporting tools address that tier. Practically, the underlying business view traces back to PA_PROJECTS_ALL and related project setup tables in the Projects (PA) module, but the documented dependency chain in this metadata stops at FIIBV_PROJ_PROJECT_LCV.

Key Columns

The columns projected by the view serve the Project dimensional model:

• PROJECT_PK — Surrogate/primary key for the Project dimension row; the join key for fact tables.
• NAME, PROJECT, PROJECT_NUMBER — Project display name, project identifier, and the user-facing project number.
• PRJ_TYP_FK — Foreign key to the Project Type dimension. This is the column most frequently referenced by users searching for project type classification in FII extracts.
• PROJ_CLS1_FK through PROJ_CLS7_FK — Foreign keys to the seven project classification values configured against the project.
• INSTANCE — Instance discriminator, used where multiple operating units or instances feed a single warehouse.
• DISTRIBUTION_RULE — Distribution rule associated with the project for cost allocation reporting.
• PROJECT_STATUS_CODE — The project's status (for example Approved, Active, Closed), critical for point-in-time reporting.
• PROJECT_MANAGER — The manager of record for the project.
• LAST_UPDATE_DATE — Change-tracking column for incremental ETL loads.
• USER_ATTRIBUTE1 through USER_ATTRIBUTE5 — Descriptive flexfield segments carried through for extendable reporting. The view selects NULL for these five columns from the underlying business view, exposing placeholder slots in the projection.

Common Use Cases and Queries

The primary scenario is populating or validating the Project dimension in the EDW. Reporting users also join it to project cost or billing fact tables on PROJECT_PK, and filter or group by PRJ_TYP_FK or the classification keys. A representative query follows, which also demonstrates resolving the project type key that prompted the "prj_typ_fk" search:

SELECT p.project_pk,
       p.project_number,
       p.name,
       p.prj_typ_fk,
       p.project_status_code,
       p.project_manager
  FROM apps.fii_proj_project_lcv p
 WHERE p.project_status_code = 'ACTIVE';

Incremental extraction typically filters on LAST_UPDATE_DATE greater than the previous watermark. Because the view is a thin projection, queries remain efficient and reflect current FII dimension semantics for both 12.1.1 and 12.2.2.