Attempt To Set Profile Option "CSD: Default Completion Sub-Inventory" Fails With Error APP-FND-01436 (Doc ID 2111032.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Depot Repair - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

The following errors are seen when attempting to set the profile option "CSD: Default Completion Sub-Inventory" (CSD_DEF_HV_CMP_SUBINV):

* Window 1:

 APP-FND-01436: List of Values cannot find any values for you to choose
 Cause: The List of Values execution failed to find any values.
 Cause: The SQL statement specified to fdlfch() failed to return any values.
 Action: Check the message stack for any SQL statement failure messages. Check to make sure your SQL statement works in SQL*Plus. (ROUTINE=fdlfch)

* Window 2:

 Profiles couldn't determine the valid values for profile CSD_DEF_HV_CMP_SUBINV.
 This problem is usually due to an error in the SQL validation for that profile.
 Use the 'Define Profiles' form to fix the SQL Validation for the CSD_DEF_HV_CMP_SUBINV profile.
 This error may appear immediately following an Oracle error, which gives more information about what was wront with the SQL Validation.
 

Solution

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