API Programming Error for Field p_urgency_id in Customer Support when Creating Service Requests
(Doc ID 746823.1)
Last updated on JULY 21, 2020
Applies to:Oracle Customer Support - Version 220.127.116.11 to 18.104.22.168 [Release 11.5]
Information in this document applies to any platform.
-- Problem Statement:
When trying to create a Service Request from HTML Service the following error is received:
"API Programming Error (CS_ServiceRequest_UTIL.Validate_Urgency): The value "1" for field p_urgency_id is invalid."
As part of the solution provided in <Note 726136.1>, this error should be fixed by setting the Site value for the 'Service: Default Service Request Urgency' profile option.
When trying to set the value after navigating to:
System Administrator responsibility
Open Profile System Values
Search for "Service: Default Service Request Urgency"
Trying to select a value from the LOV, the following error is reported:
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
Action: Check the message stack for anySQL statement failure messages.
Check to make sure your SQL statement works in SQL*Plus.(Routine=fdlfch)
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