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 laterInformation in this document applies to any platform.
Symptoms
On 12.2.4 - UAT Depot Setup:
CSD: Default Service Request Type for Bulk Receiving > SQL validation Error
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.
STEPS
-----------------------
(R) Service
(N) Others > Profile Option Values
- Select Profile Option: "CSD: Default Service Request Type for Bulk Receiving"
- Try to select a value
=> Error.
Changes
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 |
| Changes |
| Cause |
| Solution |