Duplicate Employee Count In VETS-4212 (per027.sqr) (Doc ID 2152244.1)

Last updated on JUNE 21, 2016

Applies to:

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

Symptoms

On : 9.1 version, Workforce Monitoring

ACTUAL BEHAVIOR
---------------
Delivered per027.sqr for VETS-4212 report is generating duplicate count for same employee due to incorrect SQL.
SQL in Procedure: Process-Estab-For-New-Hires2

In the above procedure the sql "FROM (PS_PERS_DATA_EFFDT A32 left outer join PS_PERS_DATA_USA A22 ON A32.EMPLID=A22.EMPLID),"
fetching mutiple count for an employee.

EXPECTED BEHAVIOR
-----------------------
SQL in Procedure: Process-Estab-For-New-Hires2 should return the correct count of employees.

STEPS
-----------------------

1. Go to Biographical>Job Information>Job Data
Employee having multiple rows (4 rows) in Biographical History section
Employee is active and he is “Regular” as of 04/16/2015.
Employee was active and in “Temporary” status as of 10/25/1981
Employee is in the same establishment (KU001) and company (GBI) all the time.
2. In the “Region” page under Country USA section, 4 Rows are present.
3.Go to Workforce Monitoring>Meet Regulatory Rqmts>VETS reports>VETS Analysis
Run report
4. Employee appears twice in the report output.


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