Query to get the list of contexts for each formula type in Oracle Fusion HCM

select t.base_formula_type_name

,      ttl.formula_type_name

,      ttl.description

,      c.base_context_name

from   ff_formula_types_b t

,      ff_formula_types_tl ttl

,      ff_ftype_context_usages u

,      ff_contexts_b c

where  t.formula_type_id = u.formula_type_id

and    ttl.formula_type_id = t.formula_type_id

and    ttl.language = userenv('LANG')

and    ttl.formula_type_name like 'Performance Rating Calculation'--'Oracle%Payroll%'

and    c.context_id = u.context_id

Worker Self Evaluation - Calculated Rating Issue - Invalid Rating Level in Oracle Fusion HCM Performance Rating Calculation

One of the possible reason to fail is if the Length of the Goal Name is more than 255 Characters. Try to  reduce the Goal Name length to below 250 characters and use description for detailed information about the Goal.

Note: Please check with Oracle before you do any changes.