My Oracle Support Banner

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.

Symptoms

On : 12.1.1 version, Receiving Functions

When attempting to find a RMA on receipt 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 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.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Purchasing
2. receiving transaction - Receipts -RMA tab, give the RMA number
3. Find

Cause

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.