My Oracle Support Banner

Inventory Value Reports Error with APP-FND-00738 (Doc ID 141667.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Cost Management - Version and later
Information in this document applies to any platform.
CSTRAIVR - All Inventories Value Report
CSTRINVR - Inventory Value Report
CSTREIVR - Elemental Inventory Value Report
CSTRSAVR - Subinventory Account Value Report
POXRRCVV - Receiving Value Report


Inventory Value Reports fails with error:

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
APP-FND-00936: 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.
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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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