Search Results pa_progress_report_edit

Overview

PA_PROJ_PARTIES_PROG_EV_V is an Oracle E-Business Suite view owned by the APPS schema and validated under the PA (Projects) product module. It presents a filtered, de-normalized list of project parties who are eligible to appear in Progress Report functionality, specifically scoped by role types associated with the PA_PROGRESS_REPORT_VIEW and PA_PROGRESS_REPORT_EDIT functions. The view consolidates two categories of resources — employees and external parties — into a single record set, assigning a synthetic resource type discriminator (101 for employees, 112 for external parties via HZ_PARTIES). It serves as a security-and-eligibility lens, ensuring that only project roles mapped through the compiled menu function hierarchy are surfaced for progress reporting usage.

Underlying Base Objects

The view text joins three primary sources across each UNION ALL branch. The first branch joins PA_PROJECT_PARTIES (SYNONYM) to PA_PROJECT_ROLE_TYPES (VIEW) and PA_EMPLOYEES (VIEW), restricting to RESOURCE_TYPE_ID = 101 and matching RESOURCE_SOURCE_ID to PE.PERSON_ID. The second branch mirrors this structure but substitutes HZ_PARTIES (SYNONYM) for the party source, restricting to RESOURCE_TYPE_ID = 112. Both branches apply a subquery against FND_COMPILED_MENU_FUNCTIONS (SYNONYM) joined to FND_FORM_FUNCTIONS (SYNONYM) to select only those menu IDs tied to the two progress report functions. Documented dependencies also include HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY packages (used at runtime for name and security resolution), plus PA_ROLE_JOB_BG_UTILS.

Key Columns

• PROJECT_PARTY_ID — Unique identifier of the project party record from PA_PROJECT_PARTIES.
• PROJECT_ID — The project context for the party assignment.
• RESOURCE_ID — Internal resource identifier (person ID or party ID).
• RESOURCE_TYPE_ID — Discriminator column; 101 for employees, 112 for external parties (set literally in each branch).
• RESOURCE_SOURCE_ID — The source key; PERSON_ID for employees, PARTY_ID for HZ parties.
• RESOURCE_SOURCE_NAME — Full name; sourced from PA_EMPLOYEES.FULL_NAME or HZ_PARTIES.PARTY_NAME.
• PROJECT_ROLE_ID / PROJECT_ROLE_TYPE / PROJECT_ROLE_NAME — Role identification; PROJECT_ROLE_NAME carries the PPRT.MEANING value.
• START_DATE_ACTIVE / END_DATE_ACTIVE — Validity window for the party's role assignment.

Common Use Cases and Queries

This view is typically consumed by progress reporting and project team eligibility logic rather than direct end-user inquiry. A representative query retrieves all eligible parties for a specific project:

• SELECT PROJECT_PARTY_ID, RESOURCE_TYPE_ID, RESOURCE_SOURCE_NAME, PROJECT_ROLE_NAME FROM PA_PROJ_PARTIES_PROG_EV_V WHERE PROJECT_ID = :project_id AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE);
• Filtering to external stakeholders only: SELECT * FROM PA_PROJ_PARTIES_PROG_EV_V WHERE RESOURCE_TYPE_ID = 112;
• Joining to project headers to validate role coverage: SELECT v.PROJECT_ID, v.PROJECT_ROLE_NAME, v.RESOURCE_SOURCE_NAME FROM PA_PROJ_PARTIES_PROG_EV_V v, PA_PROJECTS_ALL p WHERE v.PROJECT_ID = p.PROJECT_ID AND p.PROJECT_STATUS_CODE = 'APPROVED';

Because the view embeds the FND_COMPILED_MENU_FUNCTIONS eligibility filter, it is a reliable basis for reporting on who may act on or view progress reports without replicating the menu-function mapping logic. The user's originating search term, fnd_compiled_menu_functions, reflects this key dependency — the compiled menu is the mechanism through which EBS determines which role types inherit the progress report function grants.