PERWSLOC APP-FND-01564 ORACLE Error 1722 in FDFGVD (Doc ID 865532.1)

Last updated on JUNE 07, 2017

Applies to:

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

Symptoms

On 11.5.10.2 or 12.x:

When selecting 'Brazilian (International) on the Location Form, the following error occurs:

ERROR

APP-FND-01564: ORACLE error 1722 in FDFGVD

Cause: FDFGVD failed due to ORA-01722: invalid number.

The SQL statement being executed at the time of the error was: SELECT
LOCATION_SEGMENT_ID,LOCATION_SEGMENT_VALUE VALUE, LOCATION_SEGMENT_DESCRIPTION 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 AR_LOCATION_VALUES WHERE (
AR_LOCATION_VALUES.LOCATION_SEGMENT_QUALIFIER = 'COUNTRY' AND
AR_LOCATION_VALUES.LOCATION_STRUCTURE_ID IN ( SELECT LOCATION_STRUCTURE_ID FROM
AR_SYSTEM_PARAMETERS )) AND LOCATION_SEGMENT_ID = :X and was executed from the file &ERRFILE.


APP-FND-00730: This flexfield has an invalid value set. It may use a special value set that uses
an Edit event user exit, and the user exit has failed. If you are using a form on a graphical
user interface (GUI) you may have an invalid value set of a different type, possibly a
table-validated value set where the table or view does not exist or where there is an invalid
WHERE clause.

Contact your system administrator or support representative to check and correct the value sets
this flexfield uses.



-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. BR 865 AR Localizations Superuser Responsibility
2. Setup > System > Organizations > Locations
3. Change Address Style to Brazil (International) and press TAB. The error shows and doesn't allow
to input the address.

Changes

 

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