Results for “percent_complete_id”
50+ results
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— distinguishesPA_STRUCTURESfromPA_TASKSrows; drives theDECODEthat 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 asNVL(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_EXISTexpression 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 withLPAD(' ', 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.
-
APPS.PA_FIN_PERCENT_COMPLETES_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·Explore PA module →
-
APPS.PA_DELIVERABLE_PROG_HIST_V·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
APPS.PA_CURR_PROJ_TASK_PROG_V·↳ HZ_PARTIES·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
APPS.PA_TASK_DELVRS_PROGRESS_V·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
View: PA_DLV_ASSCN_TASKS_V 12.1.1
PA_DLV_ASSCN_TASKS_V selects all the attributes of a Deliverable
APPS.PA_DLV_ASSCN_TASKS_V·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
APPS.PA_ASSIGNMENT_PROGRESS_V·↳ PA_CURRENCY·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
APPS.PA_FIN_PERCENT_COMPLETES_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·Explore PA module →
-
APPS.PA_FIN_PERCENT_COMP_HIST_V·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·↳ PA_PROJ_ELEMENTS·Explore PA module →
-
APPS.PA_PERCENT_COMPLETES_FIN_V·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
View: PA_DELIVERABLES_V 12.1.1
PA_DELIVERABLES_V selects all the attributes of a Deliverable.
APPS.PA_DELIVERABLES_V·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·↳ PA_PROJECTS_ALL·Explore PA module →
-
View: PA_DELIVERABLES_V 12.2.2
PA_DELIVERABLES_V selects all the attributes of a Deliverable.
APPS.PA_DELIVERABLES_V·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·↳ PA_PROJECTS_ALL·Explore PA module →
-
APPS.PA_CURR_PROJ_TASK_PROG_V·↳ HZ_PARTIES·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
View: PA_TASK_PROG_HIST_V 12.2.2
APPS.PA_TASK_PROG_HIST_V·↳ FND_GLOBAL·↳ HZ_PARTIES·↳ PA_LATEST_PUB_STRUC_TASKS_V·Explore PA module →
-
APPS.PA_PROJ_TASK_PROG_HIST_V·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
Estimated percent completion for all levels of the work breakdown structure.
-
Estimated percent completion for all levels of the work breakdown structure.
-
View: PA_DLV_ASSCN_TASKS_V 12.2.2
PA_DLV_ASSCN_TASKS_V selects all the attributes of a Deliverable
APPS.PA_DLV_ASSCN_TASKS_V·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
APPS.PA_DELIVERABLE_PROGRESS_V·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
APPS.PA_TASK_DELVRS_PROGRESS_V·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
PA_LAUNCH_PAGE_OBJECTS_V gives the consolidated list of objects
APPS.PA_LAUNCH_PAGE_OBJECTS_V·↳ HZ_PARTIES·↳ PA_CI_TYPES_B·↳ PA_CI_TYPES_TL·Explore PA module →
-
APPS.PA_PERCENT_COMPLETES_FIN_V·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
PA_LOOKUPS is a view of system defined lookup codes and their corresponding meaning for Oracle Projects. This view will display the meani ng in the language of the session.
APPS.PA_TASK_DET_EFFORT_COST_V·↳ PA_CURRENCY·↳ PA_LOOKUPS·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
APPS.PA_BACK_PROJ_TASK_PROG_V·↳ PA_LOOKUPS·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·Explore PA module →
-
View: PA_TASK_PROG_HIST_V 12.1.1
APPS.PA_TASK_PROG_HIST_V·↳ FND_GLOBAL·↳ HZ_PARTIES·↳ PA_LATEST_PUB_STRUC_TASKS_V·Explore PA module →
-
APPS.PA_FIN_PERCENT_COMP_HIST_V·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·↳ PA_PROJ_ELEMENTS·Explore PA module →
-
PA_STRUCTURE_VERSIONS_V selects all structure-related attributes. - For future use
APPS.PA_STRUCTURE_VERSIONS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ JTF_CALENDARS_TL·Explore PA module →
-
APPS.PA_DELIV_ONLY_PROG_HIST_V·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·↳ PA_PROJECTS_ALL·Explore PA module →
-
APPS.PA_ASSIGNMENT_PROG_HIST_V·↳ PA_PROGRESS_ROLLUP·↳ PA_PROGRESS_UTILS·↳ PA_PROJECTS_ALL·Explore PA module →
-
APPS.PA_DELIV_ONLY_PROG_HIST_V·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·↳ PA_PROJECTS_ALL·Explore PA module →
-
PA_STRUCTURE_VERSIONS_V selects all structure-related attributes. - For future use
APPS.PA_STRUCTURE_VERSIONS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ JTF_CALENDARS_TL·Explore PA module →
-
APPS.PA_DELIVERABLE_PROGRESS_V·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
View: PA_TASKS_PUBLISHING_V 12.1.1
APPS.PA_TASKS_PUBLISHING_V·↳ PA_PROJ_ELEMENTS·↳ PA_PROJ_ELEMENTS_UTILS·↳ PA_PROJ_ELEMENT_VERSIONS·Explore PA module →
-
View: PA_TASKS_PUBLISHING_V 12.2.2
APPS.PA_TASKS_PUBLISHING_V·↳ PA_PROJ_ELEMENTS·↳ PA_PROJ_ELEMENTS_UTILS·↳ PA_PROJ_ELEMENT_VERSIONS·Explore PA module →
-
View: PA_STRUC_TASK_SEARCH_V 12.1.1
APPS.PA_STRUC_TASK_SEARCH_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_ALL_ORGANIZATION_UNITS·Explore PA module →
-
PA_LAUNCH_PAGE_OBJECTS_V gives the consolidated list of objects
APPS.PA_LAUNCH_PAGE_OBJECTS_V·↳ HZ_PARTIES·↳ PA_CI_TYPES_B·↳ PA_CI_TYPES_TL·Explore PA module →
-
APPS.PA_TASKS_ASSIGNS_PROGRESS_V·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·↳ PA_PROGRESS_UTILS·Explore PA module →
-
PA_LOOKUPS is a view of system defined lookup codes and their corresponding meaning for Oracle Projects. This view will display the meani ng in the language of the session.
APPS.PA_TASK_DET_EFFORT_COST_V·↳ PA_CURRENCY·↳ PA_LOOKUPS·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
APPS.PA_ASSIGNMENT_PROGRESS_V·↳ PA_CURRENCY·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
PA_PROGRESS_ROLLUP stores rolled up progress information for tasks and structures.
-
This view provides progress data for task assignments.
APPS.PA_TASK_ASSIGNMENTS_AMG_V·↳ PA_EXPENDITURES_UTILS·↳ PA_FIN_PLAN_UTILS·↳ PA_LOOKUPS·Explore PA module →
-
APPS.PA_PROJ_TASK_PROG_DET_V·↳ PA_CURRENCY·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
View: PA_PROGRESS_HIST_DET_V 12.1.1
APPS.PA_PROGRESS_HIST_DET_V·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·↳ PA_PROGRESS_UTILS·Explore PA module →
-
APPS.PA_DELIVERABLE_PROG_HIST_V·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
APPS.PA_ASSIGNMENT_PROG_HIST_V·↳ PA_PROGRESS_ROLLUP·↳ PA_PROGRESS_UTILS·↳ PA_PROJECTS_ALL·Explore PA module →
-
APPS.PA_BACK_PROJ_TASK_PROG_V·↳ PA_LOOKUPS·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·Explore PA module →
-
APPS.PA_PROJ_TASK_PROG_HIST_V·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
APPS.PA_LATEST_PROJ_TASK_PROG_V·↳ PA_CURRENCY·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →