Results for “hr_h2pi_cost_allocations”

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

Overview

The HR.HR_H2PI_COST_ALLOCATIONS table is a staging object within the PER (Human Resources) product module of Oracle E-Business Suite 12.1.1 and 12.2.2. It supports the Oracle HR to Oracle Payroll Interface (H2PI), a batch integration mechanism that transfers employee assignment and cost allocation data from the HR schema into Oracle Payroll for processing. During an H2PI data upload run, records are written to this table and held temporarily while the interface program validates, transforms, and ultimately forwards them to the destination payroll tables. The table therefore acts as an intermediate persistence layer rather than as a system of record for cost allocations.

The documentation classifies this object as standalone from a data-vault modeling perspective. Rather than functioning as a hub, link, or satellite within a normative Data Vault design, it is best treated as a transient staging construct whose lifecycle is governed by the H2PI batch process. Rows are typically purged or replaced on subsequent runs, and the table should not be relied upon as an authoritative source for historical cost allocation reporting.

Key Information Stored

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

• COST_ALLOCATION_ID — Surrogate identifier for the cost allocation record and the leading column of the primary key.
• EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — Date-tracked validity bounds for the allocation; both participate in the composite primary key.
• BUSINESS_GROUP_ID and CLIENT_ID — Multi-tenancy and client discriminator columns, also part of the primary key.
• PERSON_ID and ASSIGNMENT_ID — References to the employee and their assignment to which the allocation applies.
• PROPORTION — The percentage or fraction of cost assigned to the given distribution.
• CONCATENATED_SEGMENTS — The concatenated accounting flexfield string representing the target cost account.
• ID_FLEX_NUM — Identifies the key flexfield structure used to interpret the SEGMENTn values.
• SEGMENT1 through SEGMENT30 — The individual accounting flexfield segment values comprising the cost allocation target.
• SUMMARY_FLAG, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE — Standard key flexfield control attributes governing hierarchy and activity status.
• STATUS — Processing state of the staging row during the H2PI upload cycle.
• LAST_UPD_DATE — Audit timestamp for the most recent modification.

The primary key HR_H2PI_COST_ALLOCATIONS_PK is a composite of COST_ALLOCATION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, BUSINESS_GROUP_ID, and CLIENT_ID. Business-key identification therefore relies on the natural combination of the allocation identifier with its effective dating and tenancy columns; no separate unique index is documented in the supplied metadata.

Common Use Cases and Queries

Typical usage centers on monitoring and troubleshooting H2PI upload runs. Administrators frequently query rows by STATUS to determine whether records are pending, successfully processed, or failed. Effective-dated joins to PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F allow confirmation that each allocation references a valid assignment for the corresponding period.

A representative query pattern is:

• SELECT COST_ALLOCATION_ID, ASSIGNMENT_ID, PERSON_ID, PROPORTION, CONCATENATED_SEGMENTS, STATUS FROM HR.HR_H2PI_COST_ALLOCATIONS WHERE BUSINESS_GROUP_ID = :p_bg_id AND TRUNC(EFFECTIVE_START_DATE) <= TRUNC(SYSDATE) AND TRUNC(EFFECTIVE_END_DATE) >= TRUNC(SYSDATE);

Reporting teams also use the table to reconcile the distribution of payroll cost across accounting flexfield segments before the data reaches the payroll cost tables, and to validate that the sum of PROPORTION values per assignment equals 100 percent.

Related Objects

The following objects are most significant in relation to HR_H2PI_COST_ALLOCATIONS:

• PER_ALL_ASSIGNMENTS_F — Joins on ASSIGNMENT_ID for assignment validation.
• PER_ALL_PEOPLE_F — Joins on PERSON_ID to resolve employee identity.
• HR_ALL_ORGANIZATION_UNITS — Supports BUSINESS_GROUP_ID resolution for the operating unit context.
• PAY_COST_ALLOCATIONS_F — Destination table populated by the H2PI process once staging rows are validated.
• FND_ID_FLEX_STRUCTURES — Resolves ID_FLEX_NUM to the accounting flexfield definition.
• FND_FLEX_VALUES — Validates the SEGMENTn values against defined flexfield value sets.
• H2PI upload concurrent programs — Read and process rows from this staging table during each interface run.