Search Results per_organization_structures

Overview

The PER_ORGANIZATION_STRUCTURES table is a core data object within the Oracle E-Business Suite Human Resources (HR) module, specifically in releases 12.1.1 and 12.2.2. It functions as the master repository for organization hierarchy definitions. The table does not store the actual hierarchical relationships between individual organization units; rather, it stores the metadata or the named "containers" for those hierarchies. Each record represents a distinct organizational structure, such as "Management Reporting Line," "Departmental Hierarchy," or "Budgetary Control Structure." These named structures are then populated with specific organization units and their reporting relationships in the related PER_ORG_STRUCTURE_VERSIONS table. Its role is foundational for configuring and managing multiple views of an enterprise's organizational model to support various business processes like reporting, security, and workflow approvals.

Key Information Stored

The table's primary columns, as indicated by its primary and unique keys, are critical for uniquely identifying and classifying each hierarchy definition. The ORGANIZATION_STRUCTURE_ID is the system-generated primary key (PK) surrogate identifier. The NAME column holds the unique, user-defined name for the organizational structure within a given BUSINESS_GROUP_ID, forming a unique key (UK) constraint. The BUSINESS_GROUP_ID is a mandatory foreign key that links the structure definition to a specific HR business group, enforcing data security and partitioning at the multi-org level. This design ensures that hierarchy names are unique and meaningful within the context of a single business group.

Common Use Cases and Queries

This table is central to administrative setup and reporting on organizational hierarchies. A common use case involves generating a list of all defined organizational structures within the system for audit or configuration review. Developers and analysts frequently query this table to obtain the ORGANIZATION_STRUCTURE_ID needed for joining to related tables in more complex reports. For instance, to list all active organization structures with their associated business group code, a typical query would be:

• SELECT pos.NAME, pos.ORGANIZATION_STRUCTURE_ID, bg.NAME AS BUSINESS_GROUP FROM HR.PER_ORGANIZATION_STRUCTURES pos, HR.PER_BUSINESS_GROUPS bg WHERE pos.BUSINESS_GROUP_ID = bg.BUSINESS_GROUP_ID ORDER BY bg.NAME, pos.NAME;

Another critical scenario is during the implementation of security profiles or approval hierarchies, where a specific ORGANIZATION_STRUCTURE_ID must be selected to define the organizational context for a rule or profile.

Related Objects

As documented in the foreign key metadata, PER_ORGANIZATION_STRUCTURES has significant integration across the E-Business Suite. Its most direct relationship is with PER_ORG_STRUCTURE_VERSIONS, which stores the specific versions and the parent-child organization unit links for each structure defined in this table. Furthermore, it is referenced by security objects (PER_SECURITY_PROFILES), project accounting setups (PA_IMPLEMENTATIONS_ALL, PA_IND_RATE_SCHEDULES_ALL_BG), and grants accounting modules (IGW_IMPLEMENTATIONS_ALL). This wide range of foreign key dependencies underscores its role as a key reference point for configuring organizational context in financial, project, and human capital management processes.