My Oracle Support Banner

Perfomance Issue With Service Request API in call to Package JTF_CALENDAR_PUB_24HR under Get_Available_Time_slot (Doc ID 1534905.1)

Last updated on FEBRUARY 06, 2022

Applies to:

Oracle Teleservice - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On 11.5.10.2 -

ACTUAL BEHAVIOR  
---------------
Perfomance issue with service request API.

Calling CS_ServiceRequest_PUB.Create_ServiceRequest API first time is taking too much time to create service request.
After that it completes within few seconds.

EXPECTED BEHAVIOR
-----------------------
It takes more than 3 minutes, when it should take less than 30 seconds.

STEPS
---------
Calling CS_ServiceRequest_PUB.Create_ServiceRequest API.

Creating just a service request and using autoassignment.




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.