Attempting to Update Employee Address, Errors: APP-FND-01564: ORACLE error 1422 in FDFGVD and APP-FND-01388: Cannot read value for profile option FND_DEVELOPER_MODE in routine &ROUTINE. (Doc ID 1387294.1)

Last updated on APRIL 12, 2017

Applies to:

Oracle Self-Service Human Resources - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.0.6 version, Person / Assignment Issues

When attempting to update employee address, the following error occurs.

APP-FND-01564: ORACLE error 1422 in FDFGVD

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 PR.PROVINCE_ABBREV,
PR.PROVINCE_ABBREV VALUE,
PR.PROVINCE_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 PAY_CA_PROVINCES_V PR, PAY_CA_CITIES_V CT, PAY_CA_POSTAL_CODES_V PC
WHERE ( PR.PROVINCE_CODE = CT.PROVINCE_CODE AND PR.PROVINCE_CODE = PC.PROVINCE_CODE AND CT.CITY_CODE = PC.CITY_CODE
AND :b1 = CT.CITY_NAME AND SUBSTR(:b2,1,7) BETWEEN SUBSTR(PC.CODE_START,1,7) AND SUBSTR(PC.CODE_END,1,7) )
AND PR.PROVINCE_ABBREV = :X and was executed from the file &ERRFILE.

APP-FND-01388: Cannot read value for profile option FND_DEVELOPER_MODE in routine &ROUTINE.



Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Super HRMS Manager > Fastpath > Address
2. Query Employee
3. Shows Error.

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