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 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms


====Issue Clarification====

On : 11.5.10.2 version, Transaction Fulfillment

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

ERROR
-----------------------
#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:
SELECT ATTRIBUTE2
FROM HZ_CUST_SITE_USES_ALL
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.

STEPS
-----------------------
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

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

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.