ePerformance SQL Statement EP_SEL_RATING_VALUES Is incorrect

(Doc ID 2115675.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise HCM ePerformance - Version 9.2 and later
Information in this document applies to any platform.


The ePerformance EP_SEL_RATING_VALUES SQL that returns review_points and ep_rating does not work when there are multiple effective dated rows for the selected rating, it should only bring back the most recent effective dated row

The issue can be reproduced at will with the following steps:

  1. Log in to the back end of the environment
  2. Run the delivered SQL EP_SEL_RATING_VALUES


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