Search Results generate_xml_data

Overview

APPS.PER_US_EEO5_PKG is a United States–specific statutory reporting package in Oracle E-Business Suite Human Resources. It supports the EEO-5 Report, the Equal Employment Opportunity Commission's biennial survey of public elementary and secondary school systems, which requires the reporting of staff counts by job category, race/ethnicity, and gender for a designated reporting year. In Oracle EBS 12.1.1 and 12.2.2, the package supplies the data extraction and aggregation logic used to produce the structured report payload consumed by the EEO-5 Reporting concurrent program.

The package is declared with AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking schema rather than the defining APPS schema. This is significant because the concurrent program and any custom wrappers calling the package must therefore resolve the underlying HR tables through APPS synonyms, and callers require the appropriate grants on those objects. The package body is classified as API type OTHER in ETRM, indicating it is an internal reporting utility rather than a supported public API; Oracle does not guarantee its interface across releases.

Key Procedures and Functions

Two program units are documented in the package specification.

• GET_SUM — A function that returns the total number of employees represented across the ten constituent counting buckets passed to it. Each parameter corresponds to a distinct male or female headcount within a race/ethnicity category (white, black, Hispanic, Asian, and Indian). Its purpose is to consolidate segmented headcount figures into a single summary value for the report.
• GENERATE_XML_DATA — A procedure invoked by the EEO-5 Reporting concurrent program. It accepts the reporting year, type of agency, total enrollment figure, and business group identifier, and returns the standard concurrent program status out parameters (errbuf and retcode). Its role is to build the XML data set that populates the EEO-5 report output. The name of this procedure is the most common search target for this package, since it is the entry point used by the concurrent program and by custom integrations reproducing the standard report format.

Tables Accessed

The package reads from the following tables (typically via APPS synonyms):

• PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F — Date-tracked person and assignment records supplying employee demographics, job, and assignment dates used to determine inclusion in each reporting category.
• PER_ASSIGNMENT_STATUS_TYPES — Assignment status values used to filter to active or otherwise reportable employees.
• PER_JOBS — Job definitions used to classify staff into the EEO-5 job categories.
• PER_PERIODS_OF_SERVICE — Periods of service used to determine continuous service and reportable employment within the reporting year.
• HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION — Organization definitions and their flexfield/attribute information, used to scope the report by business group and agency/organization structure.

Usage Notes

GENERATE_XML_DATA is designed to be called from the EEO-5 Reporting concurrent program in the US HR legislative reporting responsibility. In practice it is not invoked directly from a form; administrators submit the concurrent program and the program calls this procedure, writing results to the concurrent manager output and return status. Because the package is classified as OTHER and is not a registered public API, custom extensions should call it only through a wrapper that treats the interface as subject to change on patching, particularly given the version-specific header comment lineage (peuseeo5.pkh). Customers requiring modified report content must therefore treat the package as an internal dependency and validate behavior after any HR legislative patch applied under 12.1.1 or 12.2.2.