Search Results igi_exp_pos_structures




Overview
Explore in AI Chat

Overview

IGI_EXP_POS_STRUCTURES is a table owned by the IGI schema (Public Sector Financials International) in Oracle E-Business Suite 12.1.1 and 12.2.2. It holds information about position hierarchies defined for each business group. Within the IGI product, position structures represent the organizational reporting hierarchy of positions, enabling public sector organizations to model supervisory relationships, approval chains, and budget responsibility lines that span multiple positions.

The table is a standalone entity in the documented foreign-key graph; it therefore maps naturally to a Data Vault satellite (or, where the position structure is a business concept in its own right, a hub). This classification is a heuristic modeling suggestion derived from the FK structure, not an Oracle-imposed design. The documented physical schema contains 36 columns and a single unique index, SYS_IL0000133861C00036$$, which is a system-managed LOB index rather than a true business-key constraint.

Key Information Stored

The most significant columns in each row are:

Common Use Cases and Queries

Typical uses include reporting on the structure of position hierarchies per business group, identifying primary hierarchies, and driving approval routing or budget roll-up logic.

SELECT ps.position_structure_id,
       ps.name,
       ps.business_group_id,
       ps.primary_position_flag
  FROM   igi.igi_exp_pos_structures ps
 WHERE  ps.business_group_id = :p_bg_id
 ORDER  BY ps.name;

Because IGI_EXP_POS_STRUCTURES is keyed to PER_POSITION_STRUCTURES, join patterns resolve the hierarchy definition to the HR position structure metadata:

SELECT ps.name, pps.position_structure_id
  FROM   igi.igi_exp_pos_structures ps,
         per.per_position_structures pps
 WHERE  ps.position_structure_id = pps.position_structure_id;

Incremental extracts for a data warehouse should filter on LAST_UPDATE_DATE, while DFF-based reporting should pivot the ATTRIBUTE1–ATTRIBUTE20 columns against ATTRIBUTE_CATEGORY.

Related Objects