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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms