My Oracle Support Banner

PER027 - Vets 4212 Incorrect Count (Doc ID 2163112.1)

Last updated on SEPTEMBER 14, 2023

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The count in columns C (Protected Vets (New Hires)) and D (Total New Hires) are incorrect.

In the SQR PER027, the procedure "Process-Estab-For-New-Hires2" has incorrect aliases associated with the column variable &JC2.EEO1CODE and &A2.MILITARY_STATUS.

Currently, the alias for EEO1CODE is JC2, and the alias for MILITARY_STATUS is A2.

I believe EEO1CODE should be aliased with JC22.EEO1CODE and MILITARY_STATUS should be aliased with A22.MILITARY_STATUS.
 
Expect VETS-4212 to count veterans correctly.


The issue can be reproduced at will with the following steps:
1. Navigation: Main Menu > Workforce Monitoring > Meet Regulatory Rqmts >
VETS Reports > VETS Process
2. Run PER027 process
3. Navigation: Main Menu > Workforce Monitoring > Meet Regulatory Rqmts >
VETS Reports > VETS Analysis
4. Run PER027B process

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.