Results for “org_structure_version_id”

50+ results




Overview
Explore in AI Chat

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

Overview

PA_R_HIERARCHIES_V is a reporting view owned by the APPS schema within the Oracle Projects (PA) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to expose the organizational hierarchies configured for the two principal Projects structures: the expenditure organization hierarchy and the project organization hierarchy. These hierarchies are maintained in Oracle HRMS (PER) and referenced by Oracle Projects implementations, so the view serves as a denormalized, join-ready presentation layer that allows developers and report writers to retrieve hierarchy identifiers, versions, names, and the associated operating unit context without manually joining the underlying HRMS and Projects tables.

Because the view consolidates both structure types through a UNION, it is well suited for cross-module reporting, data conversion, and integration routines that require a single source of truth for hierarchy metadata across multiple operating units or business groups. The view is registered as VALID in the ETRM metadata, confirming that it is a supported, active database object at the documented release levels.

Underlying Base Objects

The view is defined over the following documented base objects:

  • PA_IMPLEMENTATIONS_ALL (synonym) — supplies the implementation-level reference to the expenditure and project organization structure versions, as well as the business group, operating unit (ORG_ID), and structure identifiers.
  • PER_ORG_STRUCTURE_VERSIONS (synonym) — supplies the version number associated with each organization structure version.
  • PER_ORGANIZATION_STRUCTURES (synonym) — supplies the descriptive name of the organization structure.
  • PA_ALL_ORGANIZATIONS (synonym) — supplies the organization-level detail and the PA_ORG_USE_TYPE flag that distinguishes expenditure structures from project structures.
  • PA_RESOURCE_UTILS (package) — a PL/SQL utility package invoked in the SELECT list to resolve organization names via GET_ORGANIZATION_NAME, returning the organization name and the operating unit name.

The joins tie the implementation record to the structure version, then to the structure definition, and finally to the organization via ORG_ID, filtered by the relevant PA_ORG_USE_TYPE and by the omission of inactive organizations (INACTIVE_DATE IS NULL).

Key Columns

  • ORG_STRUCTURE_ID — identifier of the organization structure (expenditure or project, depending on the UNION branch).
  • ORG_STRUCTURE_VERSION_ID — identifier of the specific version of the structure.
  • ORG_STRUCTURE_NAME — the descriptive name of the organization structure.
  • VERSION_NUMBER — the version number of the structure version.
  • ORGANIZATION_ID — the organization identifier associated with the hierarchy record.
  • ORGANIZATION_NAME — resolved organization name via PA_RESOURCE_UTILS.GET_ORGANIZATION_NAME.
  • ORG_STRUCTURE_TYPE — literal value 'EXPENDITURE' or 'PROJECT', indicating which hierarchy branch produced the row.
  • BUSINESS_GROUP_ID — business group context for the implementation.
  • ORG_ID — operating unit identifier.
  • OU_NAME — resolved operating unit name, again via PA_RESOURCE_UTILS.GET_ORGANIZATION_NAME.

Common Use Cases and Queries

Typical uses include validating hierarchy assignments during implementation, driving reports on structure versions by operating unit, and feeding downstream integrations that need to map organization structures to projects or expenditures. Because two columns are resolved through a PL/SQL function call, performance-sensitive queries should filter aggressively on ORG_STRUCTURE_TYPE, ORG_ID, or BUSINESS_GROUP_ID.

A representative query:

  • SELECT org_structure_type, org_structure_name, version_number, ou_name FROM pa_r_hierarchies_v WHERE org_structure_type = 'PROJECT' AND org_id = :p_org_id;
  • SELECT org_structure_id, org_structure_version_id, organization_name FROM pa_r_hierarchies_v WHERE business_group_id = :p_bg_id ORDER BY org_structure_name;
  • SELECT DISTINCT org_structure_type, org_structure_name FROM pa_r_hierarchies_v;

These patterns allow report authors and integrators to obtain hierarchy metadata directly, avoiding error-prone manual joins across PA_IMPLEMENTATIONS_ALL, PER_ORGANIZATION_STRUCTURES, PER_ORG_STRUCTURE_VERSIONS, and PA_ALL_ORGANIZATIONS.