In Position Form, When Querying For Position, Error: APP-FND-01564: ORACLE error 1422 in FDFGCD (Doc ID 457483.1)

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.

Symptoms

Using global HRMS Manager Responsibility.

When attempting to query a Position in the Position Description Form, 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),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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms