Results for “progress_asof_date”

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

Overview

PA_PROJECT_LISTS_PORTLET_V is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) module. It is a portlet-oriented presentation layer designed to feed project information, including the latest published progress status, into Oracle EBS dashboards and portal regions. The view consolidates project master attributes from PA_PROJECT_LISTS_USER_V with the most recent published progress report information pulled from PA_PROJ_PROGRESS_REPORTS, decorated with the lookup meaning drawn from PA_LOOKUPS. As a result it exposes both static project definition data (name, number, dates, customer, organization) and dynamic progress tracking data in a single row per project, which is the shape required by portlet data sources.

The view is registered as VALID in the APPS schema and is available in both EBS 12.1.1 and 12.2.2. It is read-only by design; it is not intended for DML. Because it references security-aware packages and a user-filtered underlying view, results are constrained by the responsibility of the querying user.

Underlying Base Objects

The documented base objects are PA_PROJECT_LISTS_USER_V, PA_PROJECT_STATUSES, PA_PROJ_PROGRESS_REPORTS, PA_LOOKUPS, and the packages FND_GLOBAL, PA_SECURITY_PVT, PA_PROJECTS_MAINT_UTILS, and PA_PROJECT_DATES_UTILS.

• PA_PROJECT_LISTS_USER_V supplies the majority of project columns (aliased PPL). Because it is a _USER_V view, project visibility is filtered through the Projects security model.
• PA_PROJ_PROGRESS_REPORTS (PPR2) supplies progress status. It is joined through an inline subquery restricted to TASK_ID = 0 and REPORT_STATUS = 'PUBLISHED', taking the row with the maximum PROGRESS_REPORT_ID per project, i.e., the latest published report.
• PA_LOOKUPS (PL) resolves PROGRESS_STATUS_CODE against LOOKUP_TYPE = 'PA_XC_PROGRESS_STATUS' to produce the MEANING column.
• PA_PROJECT_STATUSES (PPS) enforces project lifecycle filtering by restricting PROJECT_SYSTEM_STATUS_CODE to APPROVED, UNAPPROVED, SUBMITTED, or UPGRADED.
• The PA packages (PA_SECURITY_PVT, PA_PROJECTS_MAINT_UTILS, PA_PROJECT_DATES_UTILS) and FND_GLOBAL are invoked by the underlying views/packages to resolve the current user, organization context, and derived dates.

Key Columns

• PROJECT_ID — Primary identifier joining to PA_PROJECTS.
• NAME, SEGMENT1 — Project name and project number.
• PROJECT_STATUS_CODE, PROJECT_STATUS_NAME — Lifecycle status from PA_PROJECT_LISTS_USER_V.
• PROGRESS_STATUS_CODE — Code of the latest published progress report status, drawn from PA_PROJ_PROGRESS_REPORTS. This is the column targeted by the search term "progress_status_code"; it is functionally related to the earlier PROJECT_STATUS_CODE but reflects report-level progress rather than project lifecycle.
• MEANING — Decoded description for PROGRESS_STATUS_CODE, resolved from PA_LOOKUPS via lookup type PA_XC_PROGRESS_STATUS.
• PROGRESS_ASOF_DATE — Date the latest published progress report reflects.
• START_DATE, COMPLETION_DATE, CLOSED_DATE, ACTUAL_START_DATE, ACTUAL_FINISH_DATE — Schedule and actual milestone dates.
• CUSTOMER_ID, CUSTOMER_NAME, PERSON_ID, PERSON_NAME, ORG_ID — Owning customer, project manager, and operating unit context.
• PROJECT_VALUE, PROBABILITY_PERCENTAGE, EXPECTED_APPROVAL_DATE — Commercial pipeline attributes.
• ENABLED_FLAG, SUMMARY_FLAG, TEMPLATE_FLAG, RECORD_VERSION_NUMBER — Control and concurrency columns.

Note that the outer join (PPL.PROJECT_ID = PPR.PROJECT_ID (+)) means PROGRESS_STATUS_CODE, MEANING, and PROGRESS_ASOF_DATE are NULL when no published progress report exists for a project.

Common Use Cases and Queries

This view is typically consumed by dashboard portlet regions that display a project list with current progress status. Because the progress columns are outer-joined and already filtered to the latest published report, callers avoid the need to write correlated MAX() subqueries.

List all projects with the latest published progress status:

SELECT project_id
     , segment1
     , name
     , project_status_name
     , progress_status_code
     , meaning
     , progress_asof_date
  FROM apps.pa_project_lists_portlet_v;

Return only projects that have a published progress report with a specific status code (the "progress_status_code" query pattern):

SELECT project_id
     , segment1
     , name
     , progress_status_code
     , meaning
  FROM apps.pa_project_lists_portlet_v
 WHERE progress_status_code = :p_status_code
 ORDER BY name;

Report projects lacking any published progress report:

SELECT project_id, segment1, name
  FROM apps.pa_project_lists_portlet_v
 WHERE progress_status_code IS NULL
 ORDER BY name;

Because visibility passes through the Projects security layer, always query with a responsibility that has been granted access to the intended operating units. For portlet integration, the view should be accessed read-only through a secured data source.