Search Results system_progress_stat_code




Overview
Explore in AI Chat

Overview

APPS.PA_TASK_PROGRESS_V is a read-only view in the Oracle E-Business Suite Projects (PA) module that consolidates task-level scheduling, progress, and status information for project structures. It is registered as an internal view owned by the APPS schema with FND Design Data reference PA.PA_TASK_PROGRESS_V, and its status is VALID. Oracle explicitly warns that this object is for Oracle Internal Use Only and is not supported for direct access by customer code except through standard Oracle Applications programs. As a result, the view functions primarily as a reporting and integration surface: it exposes denormalized task progress data that Oracle's own concurrent programs, progress rollups, and EBS-facing analytics consume, rather than a supported public API.

The view is especially relevant to users searching on act_sch_finish_var, since the schema exposes the full set of baseline, scheduled, actual, and estimated start and finish dates, along with percent-complete and progress-status attributes. This makes it a natural candidate for variance analysis and status dashboards.

Underlying Base Objects

The documented dependency metadata shows the view is not built over a single flat table. Instead, it is defined over a mix of SYNONYMs, VIEWs, and PL/SQL PACKAGEs, which supply both stored row data and computed values:

Because versions, structures, and schedules are joined together, the view reflects a specific project-element version and its placement within the work breakdown structure.

Key Columns

Identity and hierarchy columns include PROJECT_ID, PROJECT_NAME, PROJECT_NUMBER, TASK_ID, TASK_NAME, TASK_NUMBER, WBS_NUMBER, WBS_LEVEL, and DISPLAY_SEQUENCE. Milestone and classification attributes include MILESTONE_FLAG, CRITICAL_FLAG, SUMMARY_ELEMENT_FLAG, PRIORITY_CODE, and STATUS_CODE. Schedule columns are BASELINE_START_DATE, BASELINE_FINISH_DATE, SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE, ACTUAL_START_DATE, ACTUAL_FINISH_DATE, ESTIMATED_START_DATE, and ESTIMATED_FINISH_DATE. Progress columns include AS_OF_DATE, COMPLETED_PERCENTAGE, PROGRESS_STATUS_CODE, PROGRESS_STATUS_WEIGHT, and STATUS_ICON_IND. Effort and work quantity are represented by PLANNED_EFFORT, PLANNED_WORK_QUANTITY, INCREMENTAL_WORK_QTY, and CUMULATIVE_WORK_QTY.

Common Use Cases and Queries

Typical scenarios include task schedule dashboards, milestone tracking, percent-complete rollups, and finish-date variance reporting. The following query surfaces scheduled-versus-actual finish variance for open tasks:

  • SELECT project_number, task_number, scheduled_finish_date, actual_finish_date, (actual_finish_date - scheduled_finish_date) AS finish_variance, completed_percentage FROM apps.pa_task_progress_v WHERE actual_finish_date IS NOT NULL AND wbs_level = 1;
  • SELECT task_number, baseline_finish_date, scheduled_finish_date FROM apps.pa_task_progress_v WHERE milestone_flag = 'Y' AND critical_flag = 'Y';

Because the object is unsupported for direct access, queries should be restricted to read-only reporting, and any production integration should route through supported Oracle APIs.