EPY: PAY_EARNINGS_VW Incorrectly Brings Back The Wrong Job Record

(Doc ID 2047986.1)

Last updated on FEBRUARY 09, 2016

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
The effdt/effseq logic of the view is incorrectly written and the view does not bring back the latest job record.

EXPECTED BEHAVIOR
-----------------------
Bring back the view on the latest job record.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Have several effective dated sequence on Job for the employee
2. Go to additional pay and click the earnings code
3. Verify what earnings the system is bringing back for that employee

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see the view bring back the latest job record for the employee.

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