My Oracle Support Banner

Unable to Apply any Receipt Error APP-FND-00738 APP-FND-00706 (Doc ID 367871.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Receivables - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
ARXRWMAI Receipts Form

Symptoms

Apply Receipt to Invoice fails with error.
Receivables Responsibility
NAV Receipts --> Receipts
Query a Receipt and click Apply
Enter all details and press Save
The following error occurs:

APP-FND-00738: Error detected when attempting to load value sets in routine SETUP_DESCR_VSETS
--------------------------------------------------------------
APP-FND-00706: Routine FDFAVS2: : Detected a data error.
--------------------------------------------------------------
The data that defines the flexfield on this field may be inconsistent. Inform your system administrator that the SQL WHERE clause listed below does not contain the correct number of quotation marks or parentheses. This SQL clause may be in a WHERE_CLAUSE token passed into the flex definition in the form, a WHERE clause in a table-validated value set, or a default value for one of the segments of this flexfield. The first 1000 bytes of the SQL statement that caused the error is:[
[
]
[
]
[CLAUSE] (CLAUSE=SELECT .......

Same error may come while Saving Receipt header or at Adjust Exchange Rate window.

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.