Results for “pa_fin_percent_completes_v”

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

Overview

PA_FIN_PERCENT_COMPLETES_V is a Projects (PA) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes financial percent-complete and progress rollup information for the project structure, spanning both WBS structures (PA_STRUCTURES) and tasks (PA_TASKS) held in PA_PROJ_ELEMENTS. The view resolves the polymorphic element identity through a DECODE on OBJECT_TYPE, returning the element number for tasks and the version number for structures, and applies the same logic to present the element name.

Beyond identity, the view joins the published structure hierarchy to percent-complete records and progress rollup rows, producing an as-of view of completed percentage, publication status, and the number of children beneath each element. It is typically used for project progress reporting, financial percent-complete inquiries, and as a data source for downstream integrations and extensions that must reconcile hierarchy versioning with rollup percentages.

Underlying Base Objects

The view is defined over the following documented objects, all referenced as synonyms from APPS except the two utility packages:

• PA_PROJ_ELEM_VER_STRUCTURE — supplies the published structure version and hierarchy record.
• PA_PROJ_ELEMENT_VERSIONS — supplies version metadata such as display sequence, WBS level, WBS number, and financial task flag.
• PA_PROJ_ELEMENTS — the project element master (structures and tasks), providing name, element number, project, manager, and carrying-out organization.
• PA_PROJ_STRUCTURE_TYPES and PA_STRUCTURE_TYPES — join into the structure type definitions.
• PA_TASKS — task dates and parent task references.
• PA_PERCENT_COMPLETES — the percent-complete records, including current and published flags, description, and progress comment.
• PA_PROGRESS_ROLLUP — the rolled-up progress rows, as-of date, completed percentage, and effective rollup percentage.
• PA_OBJECT_RELATIONSHIPS — resolved relationship linkage (for example, OBJECT_ID_FROM1).
• PER_ALL_PEOPLE_F — manager full name.
• HR_ALL_ORGANIZATION_UNITS_TL — the translated name of the carrying-out organization.
• PA_PROJ_ELEMENTS_UTILS (PACKAGE) — invoked for CHECK_CHILD_ELEMENT_EXIST.
• PA_TASK_UTILS (PACKAGE) — invoked for SORT_ORDER_TREE_WALK.

Key Columns

• OBJECT_TYPE — distinguishes PA_STRUCTURES from PA_TASKS rows; drives the DECODE that produces the element display number and name.
• ELEMENT_VERSION_ID, PROJ_ELEMENT_ID, PROJECT_ID — version, element, and project identifiers.
• PARENT_STRUCTURE_VERSION_ID, WBS_LEVEL, WBS_NUMBER, DISPLAY_SEQUENCE — hierarchy position and ordering.
• COMPLETED_PERCENTAGE — derived as NVL(PPR.COMPLETED_PERCENTAGE, PPR.EFF_ROLLUP_PERCENT_COMP), so the actual percentage is returned when present and falls back to the effective rollup percent otherwise.
• AS_OF_DATE — the effective date of the progress rollup row.
• CURRENT_FLAG, PUBLISHED_FLAG — status of the percent-complete record.
• FINANCIAL_TASK_FLAG — identifies financial tasks within the structure version.
• The CHECK_CHILD_ELEMENT_EXIST expression and the LPAD-derived indented display column — the child-element indicator the user searched for as "child_element_flag," and the hierarchy indentation string built with LPAD(' ', 2 * (PPV.WBS_LEVEL - 1)).
• MANAGER_PERSON_ID, FULL_NAME, CARRYING_OUT_ORGANIZATION_ID, organization name, START_DATE, COMPLETION_DATE — ownership, organization, and date context.

Common Use Cases and Queries

Typical usage includes financial percent-complete reporting by project, review of hierarchical progress with child-element awareness, and reconciliation of current versus published percent-complete records. The child-element expression is often consumed by extensions to suppress rollup actions on leaf elements and to drive hierarchy rendering.

• Percent-complete detail for a project, ordered hierarchically:

SELECT project_id, wbs_number, wbs_level, completed_percentage, as_of_date
FROM apps.pa_fin_percent_completes_v
WHERE project_id = :project_id
ORDER BY display_sequence;

• Latest published percent-complete rows per element:

SELECT proj_element_id, element_version_id, completed_percentage, published_flag, current_flag
FROM apps.pa_fin_percent_completes_v
WHERE project_id = :project_id
AND published_flag = 'Y'
AND current_flag = 'Y';

• Hierarchical display with indentation:

SELECT element_number_display, completed_percentage
FROM apps.pa_fin_percent_completes_v
WHERE project_id = :project_id
ORDER BY sort_order_tree_walk;

Because the view incorporates published structure versioning and function-based expressions, queries should always constrain by PROJECT_ID to bound the join cost and return a well-defined hierarchical result set.