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 28, 2019

Applies to:

Oracle Customer Support - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
When trying to create a Service Request from HTML Service the following error is received:

ERROR
      "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
values.
Action: Check the message stack for anySQL statement failure messages.
Check to make sure your SQL statement works in SQL*Plus.(Routine=fdlfch)

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
References


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