Reuse ASSIGNMENT STATUTORY SEGMENT resulting in FDFGCD failed due to ORA-01422 error
APP-FND-01564: ORACLE error 1422 in FDFGCD
Cause: FDFGCD failed due to ORA-01422: exact fetch returns more than requested number of rows.
The SQL statement being executed at the time of the error was: SELECT ENABLED_FLAG, SUMMARY_FLAG, NVL(TO_CHAR(START_DATE_ACTIVE, 'J'), 0),NVL(TO_CHAR(END_DATE_ACTIVE, 'J'), 0),SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT17, SEGMENT12, SEGMENT13, SEGMENT16, SEGMENT18, SEGMENT15, SEGMENT19, SOFT_CODING_KEYFLEX_ID FROM HR_SOFT_CODING_KEYFLEX WHERE ID_FLEX_NUM = :num AND SEGMENT1 = :SEGMENT1 AND SEGMENT2 = :SEGMENT2 AND SEGMENT3 = :SEGMENT3 AND SEGMENT4 IS NULL AND SEGMENT5 IS NULL AND SEGMENT6 IS NULL AND SEGMENT7 IS NULL AND SEGMENT8 IS NULL AND SEGMENT9 IS NULL AND SEGMENT10 IS NULL AND SEGMENT11 IS NULL AND SEGMENT17 IS NULL AND SEGMENT12 IS NULL AND SEGMENT13 IS NULL