Search Results structure_working

Overview

APPS.PA_FIN_PERCENT_COMP_HIST_V is a reporting view in the Oracle E-Business Suite Projects (PA) module that consolidates percent-complete and progress-rollup history for financial structures and their associated tasks. It joins structural hierarchy data from the project element version structure tables with percent-complete records and progress rollup records, producing a unified historical perspective of completion percentages across the financial breakdown structure (FBS). The view is defined over financial structures only, filtering on structure type identifier 6, and it spans both published and working structure versions. Its principal role is to support percent-complete reporting, progress analysis, and downstream integration where a single historical record per task or structure version is required.

Underlying Base Objects

The view is defined over the following documented base objects:

• PA_PROJ_ELEM_VER_STRUCTURE (SYNONYM) — supplies structure version membership, status codes, and parent structure version linkage.
• PA_PROJ_ELEMENT_VERSIONS (SYNONYM) — provides element version identifiers, record version numbers, and structure version names.
• PA_PROJ_ELEMENTS (SYNONYM) — supplies the project element identity, object type, element number, and name.
• PA_PROJ_STRUCTURE_TYPES (SYNONYM) and PA_STRUCTURE_TYPES (SYNONYM) — together restrict the result to financial structures (structure_type_id = 6).
• PA_PERCENT_COMPLETES (SYNONYM) — source of computed percent-complete records, descriptions, and progress comments.
• PA_PROGRESS_ROLLUP (SYNONYM) — source of rolled-up percentage completion and rollup as-of dates.
• PA_PROJ_ELEMENTS_UTILS (PACKAGE) — invoked in the SELECT list via CHECK_IS_FINANCIAL_TASK to flag financial tasks.

Structure version selection honors either the latest effective published version or the current working version where no published version exists, which is directly relevant to callers searching on "structure_working."

Key Columns

• object_type — Distinguishes PA_STRUCTURES from PA_TASKS, driving conditional formatting of element number and name.
• element_version_id, proj_element_id, project_id — Identify the structure or task version and its owning project.
• parent_structure_version_id — Links tasks to their parent structure version.
• percent_complete_id, progress_rollup_id — Keys into the source percent-complete and rollup records.
• as_of_date — NVL of the percent-complete computed date and the rollup as-of date.
• completed_percentage — The effective completion figure, coalescing percent-complete, rollup, and effective rollup values.
• current_flag, published_flag — Indicate currency and publication state of the record.
• description, progress_comment — Narrative detail from percent-complete records.

Common Use Cases and Queries

The view is typically queried for project percent-complete reporting, FBS progress dashboards, and history extracts that must respect the published-versus-working structure logic. A representative query follows:

• SELECT project_id, proj_element_id, object_type, completed_percentage, as_of_date, current_flag, published_flag FROM APPS.PA_FIN_PERCENT_COMP_HIST_V WHERE project_id = :p_project_id ORDER BY as_of_date DESC;
• Filtering on current_flag = 'Y' isolates the latest effective completion value per structure or task.
• Filtering on published_flag = 'Y' restricts output to records tied to published structure versions, while records with working-only versions surface when no published version exists.

Because the view embeds the working-structure predicate (status_code = 'STRUCTURE_WORKING' with current_working_flag = 'Y'), it is the appropriate source when consumers must resolve progress against either a published baseline or an in-progress working structure.