My Oracle Support Banner

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 to [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

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