In Position Form, When Querying For Position, Error: APP-FND-01564: ORACLE error 1422 in FDFGCD
Last updated on JULY 19, 2016
Applies to:Oracle Human Resources - Version 12.0.2 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Using global HRMS Manager Responsibility.
When attempting to query a Position in the Position Description Form, the following error occurs:
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),SEGMENT2,POSITION_DEFINITION_ID FROM PER_POSITION_DEFINITIONS WHERE ID_FLEX_NUM = :num AND SEGMENT2 =
:SEGMENT2 and was executed from the file &ERRFILE.
Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Using Global Super HRMS Manager.
2. Navigate to Work Structures> Position> Description.
3. Create a new Position,error is received.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms