Blank/Error LOV in ICP Code under Manage Compensation --> Additional Compensation

Content

Blank/Error LOV in ICP Code under Manage Compensation --> Additional Compensation.

This is working fine Classic UI but having issues with Responsive UI. It's a custom value set.

Error:

ORA-01841: (full) year must be between -4713 and +9999, and not be 0 ORA-06512: at "FUSION.PAY_FF_FUNCTIONS", line 656 ORA-06512: at line 1

Value Set Query:

SELECT
ffv.flex_value
FROM
per_all_assignments_m       paf_asg,            
hr_all_organization_units_f haouf,     
fnd_flex_value_sets ffvs ,     
fnd_flex_values ffv ,     
fnd_flex_values_tl ffvt
WHERE
1=1
   AND paf_asg.organization_id = haouf.organization_id
   and paf_asg.person_id = :{PARAMETER.PersonId}