Cannot use a table validation type Value Set for GL Segment LOV
Hi,
For one of our accounting segments, I defined a Table validation type based on a custom view XX_TASK_LOV_TEST4. I am able to see the LOV but when I select a value from the LOV and click OK, I get the below error.
APP-FND-01564: ORACLE error 1406 in FDFGVD Cause: FDFGVD failed due to ORA-01406: fetched column value was truncated. The SQL statement being executed at the time of the error was: SELECT TASK_NBR,TASK_NBR VALUE, TASK_DESC DESCRIPTION, NVL('N', 'N'), NVL(TO_NUMBER(NULL), -1), NULL, NVL('Y', 'Y'), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0) FROM XX_TASK_LOV_TEST4 WHERE 1=1 AND TASK_NBR = :X and was executed from the file &ERRFILE.
0