Search Results hr_organization_information

Overview

The HR_ORGANIZATION_INFORMATION table is a core data structure within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. It functions as a flexible extension table designed to store additional, context-specific attributes for organizational units. Its primary role is to support the classification system for organizations, allowing for the storage of varied information types—such as financial, geographic, or operational details—that are not captured in the base organization definition table (HR_ALL_ORGANIZATION_UNITS). This design enables a single organization record to possess multiple, distinct sets of supplementary data based on its assigned classes and the associated information types defined within the application.

Key Information Stored

The table's structure is centered around a key-context-value model. The primary key is ORG_INFORMATION_ID, a unique system-generated identifier. Two critical foreign key columns define the record's context and parent organization: ORGANIZATION_ID links to HR_ALL_ORGANIZATION_UNITS, and ORG_INFORMATION_CONTEXT links to HR_ORG_INFORMATION_TYPES, which defines the valid information type (e.g., 'Accounting Information', 'Work Day Information'). The actual attribute data is stored in the ORG_INFORMATION1 through ORG_INFORMATION20 columns, with the meaning of each column being determined by the context. Additional columns like ORG_INFORMATION21 to ORG_INFORMATION30 may exist for extended flexfield storage. The LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, and CREATED_BY columns provide standard EBS audit trail information.

Common Use Cases and Queries

A primary use case is retrieving all supplementary information for a specific organization, which is essential for comprehensive organization reports or data feeds to downstream systems like General Ledger or Payroll. For example, to find the accounting flexfield (e.g., Company, Cost Center) assigned to an organization, a typical query would join on the context. Reporting often involves pivoting multiple rows (different contexts) for a single organization into a single row. Developers also frequently interact with this table when writing custom interfaces or extensions that need to populate or validate organization-specific attributes beyond the standard fields.

• Retrieve all information for a specific organization ID: SELECT * FROM hr_organization_info WHERE organization_id = <org_id> ORDER BY org_information_context;
• Find organizations with a specific information type and value: SELECT hou.name FROM hr_organization_units hou, hr_organization_info hoi WHERE hou.organization_id = hoi.organization_id AND hoi.org_information_context = 'CLASS' AND hoi.org_information1 = 'DEPARTMENT';

Related Objects

As indicated by the foreign keys in the metadata, HR_ORGANIZATION_INFORMATION has direct dependencies on two principal tables. HR_ALL_ORGANIZATION_UNITS is the parent table containing the core definition of the organization (name, location, type). HR_ORG_INFORMATION_TYPES is the reference table that validates the ORG_INFORMATION_CONTEXT and defines which of the ORG_INFORMATION# columns are used and their meaning for that context. In application logic, this table is typically accessed via public APIs or views rather than directly. Key related views may include HR_ORGANIZATION_UNITS (a view on HR_ALL_ORGANIZATION_UNITS) and per_org_info_types_vl. Custom reporting often joins this table with HR_LOCATIONS and financial tables like GL_CODE_COMBINATIONS when the stored information includes accounting segments.