PER027 - Vets 4212 Incorrect Count (Doc ID 2163112.1)

Last updated on JULY 20, 2016

Applies to:

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

Symptoms

On : 9.2 version, Workforce Monitoring

ACTUAL BEHAVIOR
---------------
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.
 

EXPECTED BEHAVIOR
-----------------------
Expect VETS-4212 to count veterans correctly.

STEPS
-----------------------
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

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot .

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms