Fast Formula: Need Help to Pull Latest Talent Rating Recorded

Content

In our compensation worksheet, I was able to successfully pull performance rating from Talent Ratings page based from the solution provided here: Doc ID 2331384.1. The performance rating being pulled from though is the first rating and we want to pull the latest performance rating added.

 

Here's the FF used:

FF1: /* RS CC Get Perf Ratings */

Inputs are CMP_IV_PLAN_EXTRACTION_DATE (date)

L_RETURN_VALUE = 'AAA'

l_person_id = get_context(PERSON_ID, -1)

l_eff_date = CMP_IV_PLAN_EXTRACTION_DATE

CHANGE_CONTEXTS(EFFECTIVE_DATE = l_eff_date)

SET_INPUT('TALENT_PROFILE_CONTENT_TYPE','PERFORMANCE_RATING')

RET = ESS_LOG_WRITE('Executing Parent Formula Starts'||TO_CHAR(l_eff_date))