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

Last updated on MAY 17, 2017

Applies to:

Oracle Depot Repair - Version 12.2.4 and later
Information 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.

WHAT IS WORKING
------------------------------
No errors in TEST instance.

BUSINESS IMPACT
-----------------------
This profile is used to received the items in bulk QTY through receive return function for which I am receiving an below error:

Error: Service Request Creation failed
Party id :50380
API Error (CS_ServiceRequest_PUB.Create_ServiceRequest): The value for parameter SR Type cannot be "NULL".

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