Search Results upload_hr_organization

Overview

The APPS.HR_H2PI_BG_UPLOAD package is a PL/SQL upload utility within Oracle E-Business Suite Human Resources. Its name reflects its role as a "H2PI" (Human Resources to Payroll Interface) business group upload driver. The package provides the server-side logic that moves staging data held in the HR_H2PI_* interface tables into the operational HR and Payroll tables for a specified business group. It is the counterpart to the data-loading steps that precede payroll processing, ensuring that locations, organization units, organization classifications, and element types created or modified in an external or staging context are propagated into the base EBS entities.

The package is declared with AUTHID CURRENT_USER, so it executes with the privileges of the calling user rather than the definer, and it exposes two package globals, g_to_business_group_id and g_request_id, which carry the target business group and the concurrent request identifier through the upload session. The header revision string indicates an original 2005 build (120.0) that has remained stable across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

• UPLOAD_LOCATION — Loads location records from the staging interface into the HR locations tables for the given client identifier.
• UPLOAD_HR_ORGANIZATION — Creates or updates HR organization units from the staging organization data.
• UPLOAD_ELEMENT_TYPE — Uploads payroll element type definitions into the element type table.
• ORG_EXISTS — A Boolean-style numeric function that determines whether a given organization already exists, accepting a client identifier, an organization identifier, and a table indicator to target the appropriate source. This is the object referenced by the "org_exists" lookup, and it carries a PRAGMA RESTRICT_REFERENCES(..., WNDS) declaration, guaranteeing that it writes no database state and can be safely called from SQL.
• GET_ID_FROM_VALUE — Returns a string identifier derived from organization information, keyed by an organization information identifier and an information number.

Tables Accessed

The package reads and writes a coherent set of interface and base tables. The staging side is represented by HR_H2PI_LOCATIONS, HR_H2PI_HR_ORGANIZATIONS, HR_H2PI_ORGANIZATION_CLASS, HR_H2PI_ORGANIZATION_INFO, and HR_H2PI_ELEMENT_NAMES. The target side includes HR_LOCATIONS_ALL, HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, and PAY_ELEMENT_TYPES_F. Supporting lookups include FND_DESCR_FLEX_COLUMN_USAGES for descriptive flexfield definitions and FND_SESSIONS for session context; DUAL is used for scalar evaluations. This combination confirms the package's role as a controlled migration path from interface tables to the live HR and Payroll schema.

Usage Notes

The procedures are typically invoked from concurrent programs or feeder scripts that first populate the HR_H2PI_* interface tables and then call the corresponding upload routine for the relevant business group. The g_to_business_group_id global must be set to the intended target business group before execution, and g_request_id is populated so that downstream processing can tie the load to its originating concurrent request. Because ORG_EXISTS is declared with the WNDS restriction and is a pure query, it is safe to call from SQL statements and PL/SQL conditions during the upload to avoid duplicate organization creation. The package is referenced by one other package in the ETRM inventory, indicating it is a component of a larger interface flow rather than a standalone entry point. Given the fixed 2005 header and its documented continuity into 12.2.2, the interface should be treated as a stable but low-level utility: customizations should call the documented procedures rather than manipulate the interface tables directly, and any changes to business group context should be made before the first upload call in a session.