Search Results pay_eosurvey_pkg




Overview
Explore in AI Chat

Overview

PAY_EOSURVEY_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Equal Opportunity (EO) Survey reporting process used by U.S. payroll customers. The package encapsulates the cursor definitions, data-gathering logic, and insert routines required to produce the EO Survey report, a federally mandated statistical summary of workforce composition by race, ethnicity, gender, job category, and location. Its internal comment header identifies it as the package that "defines the cursors needed for EO Survey report."

The package belongs to the payroll (PY) module and is classified as OTHER in the ETRM catalog. It performs ETL-style processing: it reads assignment, person, organization, and balance data, computes period-based counts for hires, terminations, promotions, and full-time equivalents (FTE), and writes summarized results into reporting tables. It is also tied to a concurrent request context, since its principal driver accepts a payroll action identifier and thread number, indicating parallel processing support for large payroll populations.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions:

  • FIND_PERSONS — The primary driver procedure. It accepts a payroll action identifier (from PAY_ASSIGNMENT_ACTIONS) and a thread number, allowing the survey to be processed across multiple parallel workers. It identifies the persons and assignments that fall within the survey scope for a given payroll action.
  • APP_FIRE_COUNT — Gathers applicant and fire (termination) counts for a specified establishment entity, hierarchy version, and reporting period.
  • P_INSERT — The principal insert routine. It writes a fully assembled EO Survey record containing entity, sequence, location, FEIN, assignment and person identifiers, job category, race, person type, gender-based applicant/hire/terminate/promotion/FTE counts, monetary compensation, tenure, minority and ethnic group codes, and establishment/FTE flags.
  • HIRE_OR_FTE — Determines hire and FTE treatment for an assignment over a period, using effective start and end dates to establish eligibility windows.
  • GRE_NAME — Resolves the name of a general hierarchy (GRE) node or entity used on the report.
  • MINORITY — Derives or validates minority classification codes for reporting.
  • PROMOTION — Calculates promotion counts, with the header history indicating additional parameters were added under Bug 3993335.
  • MALE_FEMALE_COUNT — Aggregates counts split by gender for the survey categories.
  • JOB_RACE_INSERT — Inserts job-and-race statistical breakdown rows into the reporting tables.

Tables Accessed

Through APPS synonyms, the package reads assignment and action context from PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, and PAY_ACTION_INTERLOCKS; person and assignment data from PER_ALL_ASSIGNMENTS_F, PER_PERIODS_OF_SERVICE, PER_ASSIGNMENT_STATUS_TYPES, and PER_JOBS; organization and hierarchy data from HR_ORGANIZATION_INFORMATION, HR_LOCATION_EXTRA_INFO, PER_GEN_HIERARCHY_VERSIONS, and PER_GEN_HIERARCHY_NODES; and balance information from PAY_BALANCE_TYPES, PAY_BALANCE_DIMENSIONS, and PAY_DEFINED_BALANCES. Results are written to PAY_US_RPT_TOTALS, the U.S. reporting totals table that stores the computed EO Survey figures.

Usage Notes

PAY_EOSURVEY_PKG is typically invoked indirectly by an Oracle Payroll concurrent program or report process rather than called from a form or client-side code. The FIND_PERSONS signature—payroll action ID plus thread number—confirms it is designed for submission as a parallel-enabled concurrent request, with each thread processing a subset of the population. No other packages reference it, and it is not published as a callable business API, so customization should be limited to executing it through the standard EO Survey concurrent program. The nocopy modifier noted for out parameters in the version history reflects performance tuning for the large result sets this report generates.