Results for “fiibv_proj_prj_typ_lcv”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FIIBV_PROJ_PRJ_TYP_LCV is a base view associated with the Financial Intelligence (FII) product family in Oracle E-Business Suite, specifically within the Enterprise Data Warehouse (EDW) layer. Within the ETRM 12.2.2 documentation, the object is classified under the FII – Financial Intelligence module, which is flagged as obsolete in current releases. The view represents the Project Type level of the Project dimension in the EDW dimensional model, providing the lowest-grain reference used to build analytical and reporting structures around projects.

The view's design purpose is to produce a surrogate key and descriptive attributes for the Project Type dimension so that fact tables in the EDW can reference project type lineage consistently. It does not store transactional data; instead it exposes a denormalized, flattened representation of the project type hierarchy derived from the operational PA tables. Because it is a base view in the dimensional build chain, it typically serves as an input to higher-level dimension views rather than being queried directly by end users.

Underlying Base Objects

The documented view text shows that FIIBV_PROJ_PRJ_TYP_LCV is defined over three underlying objects:

• PA_PROJECT_TYPES_ALL — the primary source of project type definitions, aliased as PT. It supplies the project type name, operating unit context (ORG_ID), and the LAST_UPDATE_DATE audit column.
• HR_ALL_ORGANIZATION_UNITS — the organization master, aliased as ORG, joined on ORG_ID to resolve the operating unit name for display.
• EDW_LOCAL_INSTANCE — the EDW instance registry, aliased as ELI, which contributes INSTANCE_CODE to distinguish the source instance in multi-instance warehouse deployments.

The join on HR_ALL_ORGANIZATION_UNITS is an outer join (indicated by the (+) operator) and is guarded by NVL(PT.ORG_ID, -99), allowing project types that are not tied to a specific operating unit to survive the join. The documentation states the object is not implemented in the database against which the ETRM metadata was captured, so this definition is representative rather than currently instantiated.

Key Columns

• PRJ_TYP_PK — the surrogate primary key for the Project Type dimension member, built as ORG_ID || '-' || PROJECT_TYPE || '-' || INSTANCE_CODE. This concatenated key uniquely identifies a project type within an operating unit and instance.
• NAME — the descriptive name of the project type, formed as PROJECT_TYPE concatenated with the organization name where ORG_ID is populated.
• PROJECT_TYPE — the raw project type value from PA_PROJECT_TYPES_ALL.
• ALL_FK — a constant literal 'ALL' used to support the ALL-level aggregation member of the dimension.
• INSTANCE — the EDW instance code from EDW_LOCAL_INSTANCE.
• LAST_UPDATE_DATE — the audit timestamp of the source project type record, used for incremental loading and change detection.

The view text also carries a descriptive flexfield reference ('_DF:PRT:_EDW'), indicating the intended association with the Project Type DFF for extended attribute reporting.

Common Use Cases and Queries

Typical usage involves feeding the Project Type dimension build, validating dimensional keys, or reconciling EDW project type members back to PA. A representative query might be:

• SELECT PRJ_TYP_PK, NAME, PROJECT_TYPE, INSTANCE FROM FIIBV_PROJ_PRJ_TYP_LCV WHERE INSTANCE = 'PROD';
• SELECT PROJECT_TYPE, LAST_UPDATE_DATE FROM FIIBV_PROJ_PRJ_TYP_LCV WHERE LAST_UPDATE_DATE > SYSDATE - 1; for incremental extraction checks.
• SELECT COUNT(*), INSTANCE FROM FIIBV_PROJ_PRJ_TYP_LCV GROUP BY INSTANCE; to validate the multi-instance key space.

Because the object belongs to an obsolete FII module and is not implemented in the reference database, its practical reuse in 12.1.1 or 12.2.2 is limited. Implementations should treat it as historical metadata and derive equivalent Project Type dimension logic directly from PA_PROJECT_TYPES_ALL when rebuilding EDW content.