Search Results per_us_eeo4_pkg




Overview
Explore in AI Chat

Overview

APPS.PER_US_EEO4_PKG is a PL/SQL package body in the Oracle E-Business Suite (EBS) Applications schema (APPS). Its purpose is to support U.S. Equal Employment Opportunity (EEO) regulatory reporting — specifically the EEO-4 report format administered by the U.S. Equal Employment Opportunity Commission (EEOC). The EEO-4 report is used by state and local government employers to report the composition of their workforce by job category, race/ethnicity, gender, and salary range.

The package operates by generating structured XML output that conforms to the EEO-4 reporting schema. It queries Human Resources (HR) organization and location data, derives employment category information, constructs XML segments, and writes the resulting content to a concurrent program output file via FND_FILE. The package status is VALID in Oracle EBS 12.1.1 and 12.2.2, and it is classified as an "OTHER" API type rather than a standard business API.

Key Procedures and Functions

The package exposes 18 documented procedures and functions that collectively build the EEO-4 report. They can be grouped by function:

Tables Accessed

Dependencies for this package are drawn from HR and Applications objects:

  • HR_ALL_ORGANIZATION_UNITS — The primary source for organization and reporting entity information used as the report's business grouping unit.
  • HR_ORGANIZATION_INFORMATION — Provides additional organization attributes required for report validation and classification.
  • HR_LOCATIONS — Supplies location data associated with reporting establishments.
  • HR_LOOKUPS — Used by GET_LOOKUP_MEANING to resolve coded values.
  • PQH_EMPLOYMENT_CATEGORY — Supplies employment category classification used grouping employee data.
  • DBMS_SQL, PLITBLM — Oracle-supplied utilities used for dynamic SQL execution and PL/SQL table manipulation.
  • FND_FILE — Oracle Applications utility used to write output to the concurrent program log and output file.

Usage Notes

This package is not referenced by any other database object, which indicates it is invoked directly — most likely from a concurrent program registered to run the EEO-4 regulatory report. When a user submits the EEO-4 concurrent request from the Submit Requests form, the concurrent manager invokes the package, which dynamically assembles SQL over the HR organization and employee tables, populates internal PL/SQL table structures, constructs the EEO-4 XML document, and writes the result to the report output file using FND_FILE. Because it is a package body with no public API contract, it should not be called directly from custom code; extensions should instead rely on the underlying HR tables and the concurrent program registration. The dynamic-SQL and lookup-driven design means the output respects the current HR setup and lookup configuration at runtime.