Search Results progress_entry_enabled_flag

Overview

PA_TASK_DET_EFFORT_COST_V is an APPS-owned database view in the Oracle Projects (PA) module, shipped as part of Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes task-level detail for effort and cost progress accumulation, drawing together planned effort, actual effort to date, and derived progress metrics for project and task elements. The view is a supporting object for Project Progress reporting and is aligned with the Progress Workplan / progress rollup functionality used to compute physical percent complete in Oracle Projects.

The view text is heavily driven by the PA_PROGRESS_UTILS package, which supplies the computational logic for planned effort, actual effort to date, percent complete, and percent spent. Rather than storing values, the view resolves effort and cost metrics dynamically at query time using a driving hint on PJI_FM_XBS_ACCUM_TMP1, indicating it forms part of the effort/cost accumulation reporting layer used by Project Management and Progress reporting.

Underlying Base Objects

The documented base objects reveal a structural view over project element version and progress data:

• PA_PROJ_ELEMENTS, PA_PROJ_ELEMENT_VERSIONS, PA_PROJ_ELEM_VER_STRUCTURE, PA_PROJ_ELEM_VER_SCHEDULE — Provide the task/element hierarchy, version context, structure and scheduling data used to resolve project and task identity.
• PA_PROJ_PROGRESS_ATTR, PA_PROJ_WORKPLAN_ATTR — Supply progress attributes and workplan configuration, including the workplan enable-version flag used to distinguish PUBLISH versus WORKING progress.
• PA_PROJECTS_ALL, PA_TASK_TYPES — Supply project-level and task-type context.
• PA_PROGRESS_ROLLUP — Supplies rolled-up progress values (actual effort to date, ETC values) across the element hierarchy.
• PJI_FM_XBS_ACCUM_TMP1 — The accumulation source referenced by the driving index hint.
• PA_PROGRESS_UTILS and PA_CURRENCY — Packages providing calculation logic and currency handling.
• PA_LOOKUPS — Referenced for lookup code meanings, though the documentation excerpt describing this object appears to have been inherited from PA_LOOKUPS metadata and should be treated with caution.

Key Columns

• PROJECT_ID, PROJ_ELEMENT_ID, ELEMENT_VERSION_ID — Identify the project, task/project element and its version.
• OBJECT_TYPE, PARENT_STRUCTURE_VERSION_ID — Classify the element and locate it within the version structure hierarchy.
• PLANNED_EFFORT — Calculated via PA_PROGRESS_UTILS.CALC_PLAN over labor and equipment hours.
• ACTUAL_EFFORT_TO_DATE — Sum of people and equipment actual effort plus subproject contributions.
• PERCENT_COMPLETE_EFFORT — Derived from actual effort and summed ETC values, honoring PUBLISH/WORKING version state.
• PERCENT_SPENT_EFFORT — Actual effort divided by planned effort via PA_PROGRESS_UTILS.PERCENT_SPENT_VALUE.

Common Use Cases and Queries

This view is typically consumed for task-level progress analysis, effort-to-complete reporting, and physical percent complete calculations in Project Progress reporting. A representative query:

• SELECT project_id, proj_element_id, planned_effort, actual_effort_to_date, percent_complete_effort, percent_spent_effort FROM apps.pa_task_det_effort_cost_v WHERE project_id = :project_id;

The view supports reconciliation between planned and actual effort across the task hierarchy, and can be joined to PA_PROJECTS_ALL or PA_TASK_TYPES for descriptive reporting. Because metric computation is delegated to PA_PROGRESS_UTILS, results reflect the same progress logic used by the standard Progress Workplan pages, ensuring reporting consistency with the application.