My Oracle Support Banner

Order Entry Gets Errored Out While Trying To Save Sales Order: APP-FND-01564: ORACLE error 1722 (Doc ID 1381147.1)

Last updated on FEBRUARY 03, 2020

Applies to:

Oracle Order Management - Version and later
Information in this document applies to any platform.


====Issue Clarification====

On : version, Transaction Fulfillment

When attempting to save the sales order,
the following error occurs.

#1 error
APP-FND-01564: ORACLE error 1722 in FDFGDF

Cause: FDFGDF failed due to ORA-01722: Invalid Number

The SQL statement being executed at the time of the error was:
WHERE SITE_USE_ID = :a1 and was executed from the file &ERRFILE.

#2 error
APP-FND-00730: This flexfield has an invalid value set. It may use a special value
set that sues 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.

The issue can be reproduced at will with the following steps:
1. OM--> Responsibility
2. Orders/Return
3. Enter sales order line--> Save
4. Error occurs

The issue has the following business impact:
Due to this issue, users cannot save the sales order.


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

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