Human Capital Management - EBS (MOSC)

MOSC Banner

Reuse ASSIGNMENT STATUTORY SEGMENT resulting in FDFGCD failed due to ORA-01422 error

edited Oct 12, 2011 11:17PM in Human Capital Management - EBS (MOSC) 1 commentAnswered
In the process of re-using an obsolete segment on the assignment statutory form, I encounter the following 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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center