Results for “proj_categ7_fk”

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

Overview

FII_PROJ_CLS7_LCV is a Class 7 source view belonging to the FII (Financial Intelligence) product family within Oracle E-Business Suite. In the ETRM documentation metadata for releases 12.1.1 and 12.2.2, FII is explicitly flagged as obsolete, meaning the module is no longer actively supported or shipped in current implementations. The view is documented as the "CLass 7 source view for the Project dimension in EDW," positioning it within the extract, transform, and load layer that supplied data to the Enterprise Data Warehouse. Its function is to expose the seventh-level project classification hierarchy — a granular segmentation of project data — so downstream warehouse staging and dimension-building processes could consume a stable, pre-joined projection of project classification attributes without touching the underlying transactional tables directly.

A distinguishing characteristic of this view is that the ETRM metadata records it as "Not implemented in this database." This indicates that the view definition exists in the dictionary repository but was not instantiated in the environment captured by the documentation, a common situation for legacy FII objects retained for reference after the module was retired.

Underlying Base Objects

The ETRM metadata documents no base tables directly within this database; instead, the view text selects from a single underlying object, FIIBV_PROJ_CLS7_LCV, which is itself a database view in the FII business-view layer. The "BV" component of that name follows the standard FII naming convention for business views, which typically sit atop the FII base tables and encapsulate the join logic across project classification entities.

The SELECT list of FII_PROJ_CLS7_LCV shadows the column structure of FIIBV_PROJ_CLS7_LCV almost exactly, with five trailing positions mapped to NULL literals. Because no base tables are enumerated, the dependency chain resolves only to FIIBV_PROJ_CLS7_LCV; the underlying tables behind that business view are not exposed in the supplied metadata and would need to be resolved by querying the data dictionary in a live instance.

Key Columns

• PROJ_CLS7_PK — The surrogate primary key for the seventh-level project classification record. This is the column most frequently referenced in the user's search for "proj_cls7_pk," and it serves as the join key to project dimension tables in the warehouse.
• NAME — The descriptive name of the classification member.
• PROJECT_CLASS7 — The Class 7 classification value itself, representing the seventh tier of the project classification hierarchy.
• PROJ_CATEG7_FK — Foreign key linking the record to its associated project category at level seven, establishing the parent-child relationship in the hierarchy.
• INSTANCE — Identifies the originating EBS instance, supporting multi-instance warehouse consolidation.
• LAST_UPDATE_DATE — Audit timestamp used by incremental extraction logic to identify changed records.
• USER_ATTRIBUTE1 through USER_ATTRIBUTE5 — Descriptive flexfield (DFF) segments. In this view they are hard-coded as NULL, indicating the warehouse extract intentionally suppressed user-defined attributes.

Common Use Cases and Queries

The principal use case is populating or validating the seventh-level project hierarchy in the EDW project dimension. A typical query joins the surrogate key to fact or dimension tables:

• SELECT PROJ_CLS7_PK, NAME, PROJECT_CLASS7, PROJ_CATEG7_FK FROM FII_PROJ_CLS7_LCV WHERE PROJ_CATEG7_FK = :category_id;
• Incremental extraction: SELECT * FROM FII_PROJ_CLS7_LCV WHERE LAST_UPDATE_DATE > :last_run_date;
• Hierarchy reconciliation: SELECT c.PROJ_CATEG7_FK, c.NAME FROM FII_PROJ_CLS7_LCV c ORDER BY c.PROJ_CATEG7_FK;

Because FII is obsolete, any remaining use of this view should be treated as legacy. Implementations on 12.1.1 or 12.2.2 that still reference FII_PROJ_CLS7_LCV should confirm object existence, since the metadata records it as not implemented, and plan migration to currently supported project dimension sources.