Search Results project_manager

Overview

FIIBV_PROJ_PROJECT_LCV is the Project-level base view that feeds the Project dimension in the Oracle E-Business Suite Financial Intelligence (FII) Enterprise Data Warehouse (EDW). It belongs to the FII – Financial Intelligence product, which is classified as obsolete in Oracle EBS 12.1.1 and 12.2.2. The view consolidates project master information from the Oracle Projects and Seiban number sources into a single, denormalized dimension source suitable for extraction, transformation, and loading into the EDW project dimension.

The view is not implemented in the current database, and no base objects are formally documented in the ETRM metadata. Its definition nevertheless reveals its purpose: presenting each project as a uniquely keyed row with a surrogate-style primary key, descriptive attributes, project type and classification foreign keys, and instance context for multi-organization reporting. In the context of a search for "project_manager", it is significant that the view exposes a PROJECT_MANAGER column, although this column is defined as NULL in the supplied view text. This indicates the dimension design anticipated a project manager attribute, but the current implementation does not populate it from the underlying project data.

Underlying Base Objects

The view is defined as a UNION ALL over two principal sources. The first branch selects from PA_PROJECTS_ALL (aliased PA), joined to EDW_LOCAL_SYSTEM_PARAMETERS (ELSP) and EDW_LOCAL_INSTANCE (ELI). PA_PROJECTS_ALL supplies the authoritative project definitions, including project number, name, organization, project type, distribution rule, status code, and last update date. EDW_LOCAL_INSTANCE provides the INSTANCE_CODE used to derive the composite keys and the INSTANCE attribute. EDW_LOCAL_SYSTEM_PARAMETERS supplies configuration for classification category mappings consumed by the EDW_PROJ_CLS.GET_CLASS_FK function.

The second branch selects from PJM_SEIBAN_NUMBERS (SB), again joined to EDW_LOCAL_INSTANCE. This branch captures Seiban project numbers, assigning a fixed project type foreign key value and the literal 'NA_EDW' to each project classification foreign key, since Seiban records do not carry the same class hierarchy as standard projects. Both branches share the same key construction pattern, using PROJECT_ID concatenated with INSTANCE_CODE and the literal 'PJ' to form PROJECT_PK.

Key Columns

• PROJECT_PK – Composite primary key formed as PROJECT_ID || '-' || INSTANCE_CODE || '-PJ', uniquely identifying a project across instances.
• NAME / PROJECT / PROJECT_NUMBER – Descriptive identifiers; NAME maps to SEGMENT1 (or PROJECT_NUMBER for Seiban), while PROJECT holds the long project name.
• PRJ_TYP_FK – Project type foreign key built from ORG_ID, PROJECT_TYPE, and INSTANCE_CODE, linking to the project type dimension.
• PROJ_CLS1_FK through PROJ_CLS7_FK – Foreign keys to up to seven project classification categories, derived via EDW_PROJ_CLS.GET_CLASS_FK over CLASS_CATEG1 through CLASS_CATEG7.
• INSTANCE – The instance code identifying the source EBS environment.
• DISTRIBUTION_RULE / PROJECT_STATUS_CODE – Operational attributes; projected as NULL for Seiban records.
• PROJECT_MANAGER – Reserved dimension attribute, defined as NULL in both branches and therefore unpopulated.
• LAST_UPDATE_DATE – Delta-extraction control column for incremental EDW loads.

Common Use Cases and Queries

Because the view is obsolete and not implemented, it is primarily relevant for historical FII EDW documentation, migration analysis, or when reconstructing dimension lineage. Typical EDW extracts would select project keys and attributes for loading the Project dimension, filter by LAST_UPDATE_DATE for incremental processing, or join classification foreign keys to project classification dimensions.

A representative query filtering on the project manager attribute would be:

• SELECT PROJECT_PK, PROJECT_NUMBER, PROJECT, PROJECT_MANAGER, PROJECT_STATUS_CODE FROM FIIBV_PROJ_PROJECT_LCV WHERE PROJECT_MANAGER = :manager_name;

Such a query returns no rows where PROJECT_MANAGER is selected, because the column is hard-coded to NULL. To obtain project manager information in modern EBS releases, practitioners should query PA_PROJECTS_ALL or its associated project manager assignments rather than relying on this legacy FII view. The view remains a useful reference for understanding how the FII EDW modeled the Project dimension and which source columns it consumed.