PERWSLOC APP-FND-01564 ORACLE Error 1722 in FDFGVD
Last updated on JUNE 07, 2017
Applies to:Oracle Human Resources - Version 220.127.116.11 and later
Information in this document applies to any platform.
On 18.104.22.168 or 12.x:
When selecting 'Brazilian (International) on the Location Form, the following error occurs:
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
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.
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