Results for “hr_h2pi_organization_info”

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

Overview

The HR.HR_H2PI_ORGANIZATION_INFO table is a staging object belonging to the PER (Human Resources) product module in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to serve as a staging table for the Oracle HR to Oracle Payroll Interface (H2PI), storing organization information while a data upload is in progress. Rather than being a permanent system-of-record table, it acts as a transient landing area where organization-level data is collected, validated, and subsequently transferred into the production HR schema objects during the H2PI conversion or integration cycle.

From a heuristic Data Vault modeling perspective, the metadata classifies this object as standalone. In practice, this suggests the table is best modeled as a satellite-like staging structure rather than a true hub or link, because its primary key is a composite surrogate/technical key rather than a purely business-driven natural key. The standalone classification reflects that no downstream referential dependencies are enforced from other tables onto this staging object; it feeds, but does not anchor, the surrounding data model.

Key Information Stored

The table contains 27 documented columns. The most operationally significant are summarized below.

• ORGANIZATION_ID — Identifies the organization being staged. This is a business-key candidate and forms part of the primary key.
• BUSINESS_GROUP_ID — The business group owning the organization record; also part of the primary key and a business-key candidate.
• CLIENT_ID — A multi-tenancy / client discriminator column; the third component of the composite primary key.
• ORG_INFORMATION_ID — The foreign key reference to HR_ORGANIZATION_INFORMATION.ORG_INFORMATION_ID, linking the staged row to its corresponding production organization information record.
• ORG_INFORMATION_CONTEXT — The context (name of the descriptive flexfield / information type) that qualifies the ORG_INFORMATION1..20 values.
• ORG_INFORMATION1 through ORG_INFORMATION20 — A generic set of twenty attribute columns holding the actual organization information values keyed to the context.
• STATUS — Indicates the processing state of the staged row during the upload lifecycle.
• LAST_UPD_DATE — Timestamp of the most recent update, used for change tracking and diagnostics.

The surrogate primary key HR_H2PI_ORGANIZATION_INFO_PK is the composite (ORGANIZATION_ID, BUSINESS_GROUP_ID, CLIENT_ID). The business-key candidates are ORGANIZATION_ID and BUSINESS_GROUP_ID, which pair naturally with ORGANIZATION_INFORMATION in production.

Common Use Cases and Queries

Typical scenarios include monitoring an in-progress H2PI upload, validating that staged organization information matches expected contexts, and troubleshooting rows that failed to migrate into HR_ORGANIZATION_INFORMATION.

• Counting staged rows by status to gauge upload progress.
• Joining staged rows to production organization information to detect discrepancies.
• Auditing flexfield context values before promotion.

Representative SQL:

• SELECT organization_id, business_group_id, org_information_context, status FROM hr.hr_h2pi_organization_info ORDER BY last_upd_date DESC;
• SELECT s.organization_id, s.org_information1, i.org_information1 FROM hr.hr_h2pi_organization_info s JOIN hr.hr_organization_information i ON s.org_information_id = i.org_information_id;
• SELECT status, COUNT(*) FROM hr.hr_h2pi_organization_info GROUP BY status;

Related Objects

• HR_ORGANIZATION_INFORMATION — Joined via ORG_INFORMATION_ID; the destination record for staged organization information.
• HR_ORGANIZATION_UNITS — The parent organization unit referenced through ORGANIZATION_ID.
• HR_ALL_ORGANIZATION_UNITS — Base view over organization units used for validation and reporting.
• HR_ORGANIZATION_INFORMATION_F — Flexible-field representation of organization information, parallel to the staged attribute columns.
• H2PI concurrent programs / loader — The H2PI process that reads from this staging table and promotes rows into the HR schema.
• PER_BUSINESS_GROUPS — Validates the BUSINESS_GROUP_ID context.

Because the object is classified as standalone, no other production tables depend on it; it is consumed by the HRMS conversion process rather than referenced by runtime transactions.