APP-FND-01564: Oracle error 1406 in FDFGCD
Please help me resolve this error. I know it is happening because of the fetch value is larger than what it can hold but how to resolve this?
Background on error: Error in HR Form
The SQL statement being executed at the time of the error
SELECT enabled_flag,
summary_flag,
NVL(TO_CHAR(start_date_active,'J'),0),
NVL(TO_CHAR(end_date_active,'J'),0),
segment1,
segment2,
segment3,
job_definition_id
FROM per_job_definitions
WHERE id_flex_num = :num
AND job_definition_id = :id;