My Oracle Support Banner

CSD: Default Service Request Type For Bulk Receiving >Sql Validation Error (Doc ID 2265502.1)

Last updated on FEBRUARY 06, 2022

Applies to:

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


On 12.2.4 - UAT Depot Setup:

CSD: Default Service Request Type for Bulk Receiving > SQL validation Error  


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() failes 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)

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

(R) Service
(N) Others > Profile Option Values

 - Select Profile Option: "CSD: Default Service Request Type for Bulk Receiving"
 - Try to select a value
 => Error.




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

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