Search Results project_manager




Overview
Explore in AI Chat

Overview

APPS.FIIBV_PROJ_PROJECT_LCV is a Business Intelligence (BI) extraction view in Oracle E-Business Suite, part of the FII (Financial Intelligence) layer used to feed the Oracle EBS data warehouse and ETL pipelines. It presents a consolidated, denormalized projection of project master data across all operating units in an EBS instance. The view is designed primarily for downstream reporting and integration scenarios, where project records must be surfaced in a form suitable for dimensional modeling rather than transaction processing.

In the context of a search for project_manager, the view is relevant because it includes a PROJECT_MANAGER column in its projection. Notably, the documented view text exposes PROJECT_MANAGER as NULL for both branches of the UNION, meaning the column exists structurally for schema compatibility with the target BI object, but is not populated by this particular view. Consumers expecting a project manager name from this view will not obtain one; the column is a placeholder.

Underlying Base Objects

The view is defined as a UNION ALL of two queries. The first selects from PA_PROJECTS_ALL, joined to EDW_LOCAL_SYSTEM_PARAMETERS and EDW_LOCAL_INSTANCE. The second selects from PJM_SEIBAN_NUMBERS, joined to EDW_LOCAL_INSTANCE. These three tables (PA_PROJECTS_ALL, PJM_SEIBAN_NUMBERS, EDW_LOCAL_INSTANCE) are the effective base objects, although ETRM metadata lists none as documented references. Several PL/SQL function calls are embedded: EDW_PROJ_CLS.GET_CLASS_FK is invoked seven times to derive project classification foreign keys from class categories 1 through 7.

Key Columns

Common Use Cases and Queries

Typical usage involves ETL extraction and cross-instance project dimension loading.

SELECT project_pk, project, project_number,
       project_status_code, instance, last_update_date
FROM   apps.fiibv_proj_project_lcv
WHERE  last_update_date >= :p_since;

Because PROJECT_MANAGER is NULL, retrieving a project manager requires joining to PA_PROJECTS_ALL and resolving the role assignment through PA_PROJECT_PARTIES or PA_PROJECT_ROLE_TYPES. The classification function calls also carry performance cost, so filtering by instance or last update date is advisable.