Search Results pa_percent_completes_v

Overview

PA_PERCENT_COMPLETES_V is an Oracle E-Business Suite view owned by the APPS schema within the Projects (PA) product family. Its ETRM documentation classifies it as "10Sc Only – Retrofitted," indicating that the object originates from an earlier Projects release (release 10SC) and has been carried forward into the 12.1.1 and 12.2.2 code lines for backward compatibility rather than being an actively enhanced component of the current data model. The view presents a denormalized, task-oriented projection of physical percent-complete records, joining task definition data from PA_TASKS to computed completion entries in PA_PERCENT_COMPLETES. Its role is primarily informational and reporting-oriented: it supplies progress measurement information in a structure suitable for concurrent programs, Forms-based inquiry, and custom operational reports that need to display task hierarchies alongside their latest completion percentages. Because it is a view with no stored data of its own, it always reflects the current transactional state of the underlying tables.

Underlying Base Objects

The view is defined over three referenced objects as documented in the ETRM metadata: PA_PERCENT_COMPLETES (SYNONYM), PA_TASKS (SYNONYM), and PA_TASK_UTILS (PACKAGE). PA_PERCENT_COMPLETES is the driving table, holding one row per percent-complete computation performed against a task, including the computed percentage, the computation date, the product code that produced the measurement, and the current-flag indicator. PA_TASKS supplies the task identity and structural context: project, task identifier, task number, task name, description, parent task, and WBS level. The join is expressed as an outer join (T.TASK_ID = PC.TASK_ID (+)), meaning every task in PA_TASKS is returned, with percent-complete attributes populated only where a matching computation exists. PA_TASK_UTILS is a PL/SQL package invoked at query time through the function PA_TASK_UTILS.SORT_ORDER_TREE_WALK, which derives a hierarchical sort ordering by walking the parent-task chain. This runtime function call means the view cannot be queried in a purely read-only, no-PLSQL context and may carry performance implications on large task hierarchies.

Key Columns

• ROW_ID – the ROWID of the underlying PA_PERCENT_COMPLETES row, used for direct row addressing in Forms and updates.
• PROJECT_ID, TASK_ID, TASK_NUMBER, TASK_NAME – core task identification attributes sourced from PA_TASKS.
• TASK_DESCRIPTION – the descriptive text of the task; this is the column most commonly retrieved when users search for "task_description."
• INDENTED_TASK_NUMBER, INDENTED_TASK_NAME – task number and name prefixed with two spaces per WBS level, producing a ready-made visual hierarchy for reports without additional formatting logic.
• WBS_LEVEL – the depth of the task within the work breakdown structure.
• DATE_COMPUTED, COMPLETED_PERCENTAGE – the date the percent-complete value was calculated and the resulting percentage.
• DESCRIPTION, PM_PRODUCT_CODE, CURRENT_FLAG – the progress description, the originating product code (for example, a progress or costing module), and the flag identifying the current measurement row.
• SORT_ORDER – the value returned by PA_TASK_UTILS.SORT_ORDER_TREE_WALK, used to order rows hierarchically.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN – standard WHO audit columns carried from PA_PERCENT_COMPLETES.

Common Use Cases and Queries

Typical usage centers on progress reporting and task-level inquiry. A common pattern retrieves the current percent-complete per task with description text:

• Progress reporting by project: SELECT task_number, task_name, task_description, completed_percentage FROM pa_percent_completes_v WHERE project_id = :project_id AND current_flag = 'Y' ORDER BY sort_order;
• Hierarchical structure extraction: SELECT wbs_level, indented_task_name, completed_percentage FROM pa_percent_completes_v WHERE project_id = :project_id ORDER BY sort_order;
• Audit of computation history: SELECT task_number, date_computed, completed_percentage, pm_product_code FROM pa_percent_completes_v WHERE task_id = :task_id ORDER BY date_computed DESC;
• Integration extracts feeding external scheduling or dashboard tools, filtering on CURRENT_FLAG to return only the latest measurement per task.

Because the TASK_DESCRIPTION and INDENTED columns are exposed directly, the view is frequently chosen over hand-built joins between PA_TASKS and PA_PERCENT_COMPLETES. Query authors should nonetheless account for the package function in the SELECT list, restrict results by PROJECT_ID where possible, and treat the object as a legacy compatibility view when planning new development in 12.1.1 or 12.2.2.