Search Results per_vets_mag_report




Overview
Explore in AI Chat

Overview

APPS.PER_VETS_MAG_REPORT is a PL/SQL package body in the Oracle E-Business Suite Human Resources (PER) product family. The name associates it with veteran reporting — specifically the VETS (Veterans' Employment and Training Service) Management Aggregate Report (MAG) mandated by the U.S. Department of Labor for federal contractors and subcontractors. The package assembles the data required to produce the VETS-4212 (historically VETS-100/VETS-100A) filing, which reports the number of protected veterans and disabled veterans employed by job category and hiring location.

The package is classified as OTHER under the ETRM API classification scheme, indicating it is an internal reporting utility rather than a public API. It is registered in the APPS schema with a status of VALID, confirming that the database object compiles and is available at runtime. The object exposes a single documented procedure, VETS_MAG_REPORT, which serves as the entry point for report generation.

Key Procedures and Functions

The package body defines one documented procedure: VETS_MAG_REPORT.

  • VETS_MAG_REPORT — The primary and only documented routine in the package. It drives the extraction, aggregation, and output of veterans employment data. Because it is a report driver, it is expected to query the underlying HR tables, compute aggregate headcounts by veteran category and organizational hierarchy, and write the formatted results through the FND_FILE utility to a concurrent program output file. No parameter list is documented in the ETRM metadata, so the invocation signature is not reproduced here.

The package body also relies on the FND_DATE and HR_UTILITY packages for date conversion and HR-specific utility operations, and on FND_FILE for the file I/O that produces the report output.

Tables Accessed

The ETRM dependency listing confirms that this package references the following APPS synonyms and physical tables:

  • PER_ALL_PEOPLE_F — The dated person record, providing employee identity and effective-dated person attributes used to identify veterans and protected veterans.
  • PER_ALL_ASSIGNMENTS_F — The dated assignment record, supplying job, organization, location, and employment category information needed to segment the report by EEO job group.
  • PER_JOBS — Job definitions, used to map individuals to EEO-1 job categories.
  • PER_PERIODS_OF_SERVICE — Periods of service, used to determine active versus terminated employment status as of the reporting date.
  • PER_GEN_HIERARCHY_NODES — The generic hierarchy node table, supporting organizational roll-up and reporting hierarchy traversal.
  • HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_UNITS — Organization definitions used to group results by establishment or reporting unit.
  • HR_ORGANIZATION_INFORMATION — Organization-level descriptive information.
  • HR_LOCATIONS_ALL — Location definitions, required because VETS reporting is organized by hiring location and establishment.
  • HR_LOCATION_EXTRA_INFO — Location-level descriptive flexfield or additional attributes.
  • HR_LOOKUPS — Lookup codes resolving veterans status, disability, and related classification values into reportable descriptions.

No database object references this package, confirming it functions purely as a consumer of HR data.

Usage Notes

PER_VETS_MAG_REPORT is typically invoked through an Oracle HRMS concurrent program that generates the VETS Management Aggregate report output. The package is designed for batch execution rather than interactive use; FND_FILE writes the results to the concurrent manager log and output files, which are then downloaded and used to complete the regulatory filing.

Because the package is classified as OTHER and is not referenced by any other database object, customizations should not depend on it as a stable interface. Sites with additional compliance requirements — such as supplemental federal contractor reporting — generally create their own concurrent program or BI Publisher report rather than extending this package. Analysts tracing veterans reporting logic in EBS 12.1.1 or 12.2.2 should start with the VETS_MAG_REPORT procedure and follow its queries into the PER and HR tables listed above.