Search Results published_name

Overview

PA_FIN_STRUCTURE_VERSIONS_V is an APPS-owned reporting view in the Oracle E-Business Suite Projects (PA) module. It exposes the financial structure versions maintained for a project's workplan, presenting structure-level attributes such as version number, description, effective dates, status, lock state, publication state, and baseline information. The view consolidates element, element version, and element-version-structure data into a single queryable surface, making it suitable for reporting and integration where the full set of structure-related attributes is required without navigating the multi-table join normally needed to reconstruct a workplan version.

Because the object is documented as a view that "selects all structure-related attributes," it functions as a denormalized access point over the workplan financial structure model. It is validated and present in both 12.1.1 and 12.2.2 environments, with the documented metadata referencing schema APPS.

Underlying Base Objects

The view is defined over a set of Projects base and synonym objects together with supporting lookups and utilities. The core Projects objects are PA_PROJ_ELEMENTS, PA_PROJ_ELEMENT_VERSIONS, PA_PROJ_ELEM_VER_STRUCTURE, PA_PROJECTS_ALL, PA_PROJECT_STATUSES, PA_PROJ_STRUCTURE_TYPES, PA_STRUCTURE_TYPES, and PA_PROJECT_STRUCTURE_UTILS. Supporting objects include PA_LOOKUPS, FND_LOOKUPS, PER_ALL_PEOPLE_F (referenced through synonyms such as PP1, PP2, and PAPF for person names), and FND_GLOBAL.

The primary join chain links PA_PROJ_ELEMENTS (ELE) to PA_PROJ_ELEMENT_VERSIONS (EVR) on PROJ_ELEMENT_ID, and associates PA_PROJ_ELEM_VER_STRUCTURE (STC) to both the element version and the project. Project status name is resolved through PA_PROJECT_STATUSES, while lock status, original flag, current flag, and latest effective published flag are resolved through PA_LOOKUPS and FND_LOOKUPS. Two package functions are invoked: PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_STRUCTURE and PA_PROJ_ELEMENTS_UTILS.CHECK_CHILD_ELEMENT_EXIST, which supply the structure type for a workplan element and a child-existence indicator respectively.

Key Columns

• PROJ_ELEMENT_ID, ELEMENT_VERSION_ID, PEV_STRUCTURE_ID — the identifiers tying the element, its version, and the structure version record together.
• PROJECT_ID — the owning project.
• ELEMENT_NUMBER, NAME — the workplan element and its version name.
• VERSION_NUMBER, DESCRIPTION, EFFECTIVE_DATE — identifying and dating the structure version.
• STATUS_CODE, PROJECT_STATUS_NAME — the structure version status and its descriptive project status name.
• LOCK_STATUS_CODE, LOCKED_DATE, LOCKED_BY_PERSON_ID — lock state and lock audit information.
• PUBLISHED_DATE, PUBLISHED_BY_PERSON_ID — publication state of the version, central to the "published_name" search context.
• ORIGINAL_FLAG, CURRENT_FLAG, LATEST_EFF_PUBLISHED_FLAG — YES/NO indicators resolved through FND_LOOKUPS.
• STRUCTURE_TYPE, STRUC_TYPE (derived) — the structure type classification.
• RECORD_VERSION_NUMBER attributes and WBS_RECORD_VERSION_NUMBER — optimistic locking / concurrency indicators.
• MANAGER_PERSON_ID, BASELINE_START_DATE, BASELINE_FINISH_DATE, BASELINE_AS_OF_DATE — ownership and baseline details.
• CHANGE_REASON_CODE with its lookup meaning, and CHECK_CHILD_ELEMENT_EXIST (derived) — change tracking and hierarchical child presence.

Common Use Cases and Queries

Typical uses include reporting on published workplan structure versions, auditing lock and publication history (who published or locked a version and when), and identifying the current or latest effective published version for a project element. A representative query selecting publication details is:

SELECT PROJECT_ID, ELEMENT_NUMBER, NAME, VERSION_NUMBER,
       PUBLISHED_DATE, PUBLISHED_BY_PERSON_ID,
       CURRENT_FLAG, LATEST_EFF_PUBLISHED_FLAG
FROM   APPS.PA_FIN_STRUCTURE_VERSIONS_V
WHERE  PROJECT_ID = :p_project_id
AND    CURRENT_FLAG = 'Y';

For status and lock auditing, filter on STATUS_CODE or LOCK_STATUS_CODE and join the exposed person identifiers to PER_ALL_PEOPLE_F to resolve full names. The derived STRUC_TYPE value returned by PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_STRUCTURE supports filtering to WORKPLAN structures, while CHECK_CHILD_ELEMENT_EXIST assists in distinguishing leaf from parent elements. Because the view includes version and baseline dates, it is also well suited to effective-dated reporting and to integration interfaces that must synchronize published structure versions into external systems.