While Trying To Find A Job, Receiving Error: APP-FND-01564: ORACLE error 1422 in FDFGCD filed due to ORA-01422: exact fetch returns more than requested number of rows.
(Doc ID 2995660.1)
Last updated on FEBRUARY 21, 2024
Applies to:
Oracle Human Resources - Version 12.1 HRMS RUP14 and laterInformation in this document applies to any platform.
Symptoms
When attempting to find a specific Job, the following error occurs
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, JOB_DEFINITION_ID FROM PER_JOB_DEFINITIONS WHERE ID_FLEX_NUM = :num AND SEGMENT1 = :SEGMENT1 AND SEGMENT2 = :SEGMENT2 and was executed from the file &ERRFILE.
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, JOB_DEFINITION_ID FROM PER_JOB_DEFINITIONS WHERE ID_FLEX_NUM = :num AND SEGMENT1 = :SEGMENT1 AND SEGMENT2 = :SEGMENT2 and was executed from the file &ERRFILE.
Steps To Reproduce
- Navigate to 'US Super HRMS Manager' responsibility -> Work Structures -> Jobs -> Define
- Click on Find Jobs
- Enter Job Group (Flex Details)
Example:
Name:
Enter Job Code: 9999
Job Title: PROJECT MANAGER
Click OK button. - Click Find Button (In the Find Jobs form)
- Shows Error.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |