When Opening The Contact Form, Error: APP-FND-01564: ORACLE error 1422 in FDFGVD
Last updated on DECEMBER 02, 2015
Applies to:Oracle Human Resources - Version 22.214.171.124 and later
Information in this document applies to any platform.
When attempting to open the Contact form, the following error occurs. This issue only happens to one (1) employee.
Cause: FDFGVD 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 P.PERSON_ID,P.FULL_NAME VALUE,
O.NAME DESCRIPTION, NVL('N', 'N'), NVL(TO_NUMBER(NULL), -1), NULL, NVL('Y', 'Y'),
NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0)
FROM PER_PEOPLE_F P, PER_ASSIGNMENTS_F A, HR_ORGANIZATION_UNITS O
WHERE ( P.PERSON_ID=A.PERSON_ID
AND A.ORGANIZATION_ID = O.ORGANIZATION_ID
AND P.CURRENT_EMPLOYEE_FLAG = 'Y'
AND A.PRIMARY_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND
AND TRUNC(SYSDATE) BETWEEN A.EFFECTIVE_START_DATE AND
AND P.PERSON_ID = :X
and was executed from the file &ERRFILE.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Login to the Applications.
2. Choose an HRMS responsibility, e.g. US Super HRMS Manager.
3. Navigate to 'People-> Enter and Maintain'.
4. Query the affected employee.
5. Click on 'Others-> Contact'.
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