Receiving form, Search a RMA, Error APP-FND-01564: ORACLE Error 1722 In FDFGVD
(Doc ID 2511059.1)
Last updated on AUGUST 24, 2020
Applies to:Oracle Inventory Management - Version 12.1.1 and later
Information in this document applies to any platform.
On : 12.1.1 version, Receiving Functions
When attempting to find a RMA on receipt 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 VENDOR_ID,VENDOR_NAME VALUE, VENDOR_NAME DESCRIPTION, NVL(SUMMARY_FLAG, 'N'), NVL(TO_NUMBER(NULL), -1), NULL, NVL(ENABLED_FLAG, 'Y'), NVL(TO_CHAR(START_DATE_ACTIVE, 'J'), 0), NVL(TO_CHAR(END_DATE_ACTIVE, 'J'), 0) FROM PO_VENDORS WHERE (VENDOR_TYPE_LOOKUP_CODE = 'DDTF_VENDOR') AND VENDOR_ID = :X and was executed from the file &ERRFILE.
The issue can be reproduced at will with the following steps:
2. receiving transaction - Receipts -RMA tab, give the RMA number
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document