Search Results estimate_at_completion_cost




Overview
Explore in AI Chat

Overview

The view PA_TASK_PROGRESS_AMG_V, owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2, exposes progress data for structure tasks within the Projects (PA) module. Its stated purpose is to provide a consolidated, query-ready presentation of physical and effort-based progress information for tasks associated with a project structure. The view is classified as VALID and is documented in ETRM as a VIEW object under Product/Module PA - Projects.

The suffix "AMG" and its presence in the ETRM repository indicate it is intended primarily for reporting and integration consumption, rather than as a transactional base object. Downstream reporting tools, Oracle Business Intelligence Applications, custom concurrent programs, and interface extracts commonly rely on views of this type to retrieve task-level percent-complete, rollup, and cost/effort metrics without directly joining the underlying normalized tables.

Underlying Base Objects

The view text joins a substantial set of Projects tables and one external view. The documented referenced base objects are:

All base table references resolve through APPS synonyms, meaning the view executes in the APPS schema and inherits its security and privileges.

Key Columns

The view exposes identifiers, descriptive attributes, progress percentages, dates, and cost/effort measures. Notable columns include:

Common Use Cases and Queries

The most frequent use case involves retrieving task-level progress for a project, emphasizing items where progress data is available or in progress. A representative query follows:

SELECT project_id, proj_element_id, name, element_number, completed_percentage, status_code, actual_cost FROM apps.pa_task_progress_amg_v WHERE project_id = :p_project_id ORDER BY element_number;

Because the user search term was "in_progress," a targeted query filtering on status or incomplete progress is also common:

SELECT project_id, name, completed_percentage, est_remaining_effort, actual_effort FROM apps.pa_task_progress_amg_v WHERE completed_percentage < 100 AND prog_entry_enable_flag = 'Y';

Other typical scenarios include feeding project status dashboards, feeding planning extracts through PJI, comparing actual versus estimated effort across tasks, and reporting estimate-at-completion cost at the task level. Because the view joins the latest effective published structure, results reflect published structure versions only, which is important when validating progress against the baseline.