PER034.SQR (Internal Resume) Internal Resume Report Incorrect Job Performance Ratings (Doc ID 1575878.1)

Last updated on OCTOBER 09, 2015

Applies to:

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

Symptoms

Steps to replicate:
1) Navigate Worforce Development > Profile Management > Reports > Internal Resume. Populate the run control page with emplid = KU0044. Run report.
2) Create query of EP_APPR table for emplid KU004 - SELECT A.EP_APPRAISAL_ID, A.EMPLID, TO_CHAR(A.PERIOD_BEGIN_DT,'YYYY-MM-DD'), TO_CHAR(A.PERIOD_END_DT,'YYYY-MM-DD'), A.RATING_MODEL, A.EP_CALC_METHOD, A.REVIEW_RATING, A.REVIEW_POINTS, A.EP_REVIEW_TYPE
  FROM PS_EP_APPR A
3) Compare results from PER034.sqr report (Internal Resume) to query results. The results should match but do not.

The issue appears to be a problem with the Get-Review-Rating-Descr procedure. The $Review_Rating_Descr variable needs to be cleared each time the procedure is called in case no results are retrieved in that procedure. Also, the part of the where clause - AND RRT.REVIEW_RATING = 'A' - looks wrong.

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