Search Results hr_h2pi_data_feed_hist_s

Overview

The APPS.HR_H2PI_DOWNLOAD package body is a PL/SQL program unit within the Oracle E-Business Suite 12.1.1 / 12.2.2 environment that supports the H2PI download facility for Human Resources organization and hierarchy data. The name associates it with the "H2PI" data feed construct, which is used to extract HR setup information — principally organization units, organization classifications, and organization information types — and to serialize that information into a structured format for downstream consumption.

The package is classified as OTHER in the ETRM repository, indicating that it is not a formally published public API but rather an internal utility invoked by concurrent processing logic. Its status is VALID in both releases, and it operates entirely within the APPS schema. The package body is not referenced by any other database object, which confirms its role as a top-level driver rather than a library consumed by other PL/SQL units.

Key Procedures and Functions

Four procedures and functions are documented for this package:

• DOWNLOAD — The principal driver of the package. It orchestrates the extraction of HR organization data, invokes the XML generation utilities, and writes the resulting payload to the concurrent manager output file. It is the entry point normally called by the concurrent program that owns this functionality.
• WRITE — A helper routine responsible for emitting text to the output destination using FND_FILE. It centralizes file writing so that formatting and buffering behavior remain consistent across the download.
• GET_REQUEST_ID — Returns the concurrent request identifier associated with the currently executing run. This value is used to correlate the generated feed with the concurrent request record in FND_CONCURRENT and to derive filenames or header metadata.
• GET_VALUE_FROM_ID — A lookup utility that resolves a descriptive value from an identifier. It is used to translate internal organization or information-type identifiers into their user-facing descriptions for inclusion in the output.

Parameter lists are not documented in the ETRM metadata and are therefore not reproduced here.

Tables Accessed

The package references the following tables, largely through APPS synonyms:

• HR_H2PI_DATA_FEED_HIST and HR_H2PI_DATA_FEED_HIST_S — The history table and its sequence, which record each execution of the H2PI data feed. The "_S" suffix denotes the sequence used to populate the surrogate key in the history record. These are the objects most directly associated with the search term "hr_h2pi_data_feed_hist_s".
• HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_UNITS — Provide the organization definitions that form the core of the extracted hierarchy.
• HR_ORGANIZATION_INFORMATION — Supplies the attribute values attached to each organization.
• HR_ORG_INFORMATION_TYPES and HR_ORG_INFO_TYPES_BY_CLASS — Define the valid information types and their association to organization classifications.
• FND_DESCR_FLEX_COLUMN_USAGES — Supports resolution of descriptive flexfield segment information.
• DUAL — Used for scalar expressions.

Usage Notes

This package is invoked from a concurrent program, most likely one registered against the H2PI data feed responsibility. Execution is initiated by the concurrent manager; the package then uses FND_FILE to write output, FND_CONCURRENT and GET_REQUEST_ID to identify the run, FND_MESSAGE for user-facing diagnostics, and DBMS_LOB / DBMS_XMLQUERY to assemble the XML payload. FND_DATE and FND_FLEX_DESCVAL handle date formatting and flexfield value resolution respectively.

Because the package body is not referenced by any other database object, customizations should call DOWNLOAD directly only through a cloned concurrent program rather than modifying the seeded unit. Administrators troubleshooting the feed should inspect HR_H2PI_DATA_FEED_HIST for run history and review the concurrent request log for messages emitted via FND_FILE.