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

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Cost Management - Version 11.5.10.3 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


***Checked for relevance on 23-Apr-2013***

Symptoms

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.

Cause

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 hundreds of Community platforms