User Session Is Blocking The Whole Application Session Due to CSM_HTML5_PKG.SYNC_THREAD_JOB

(Doc ID 2417114.1)

Last updated on JUNE 28, 2018

Applies to:

Oracle Mobile Field Service - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version,

ACTUAL BEHAVIOR
---------------
There are having session block issue running in PROD which is causing slowness on application and program is getting stocked its not moving at all.

These are the blocker session got from our DBA.

BEGIN CSM_HTML5_PKG.SYNC_THREAD_JOB(:1,:2,:3,:4,:5,:6,:7,:8);end;

4:17:49 PM: 15,210,@2 6818 , 2 e:CSM:bes:oracle.apps.jtf.cac.task.createTask:CSM/OMFS_PALM
964,48352,@4 21269 BLOCKER 3 e:CS:bes:oracle.apps.jtf.cac.notes.create:CS/SERVICE
1670,38334,@1 29100 , 2 e:CS:bes:oracle.apps.wf.notification.send:CS/TGCS_NA_TS_HDW_SUPP_REP
2128,47745,@4 7470 , 1 e:CS:bes:oracle.apps.jtf.cac.task.updateTask:CS/TGCS_GLOBAL_TS_HDW_SUPP_REP
2838,11031,@4 2823 BLOCKER 3 e:CS:bes:oracle.apps.ar.hz.PartySite.create:CS/TGCS_GLOBAL_TS_HDW_SUPP_REP
4958,13586,@2 12538 , 2 e:CS:bes:oracle.apps.wf.notification.send:CS/TGCS_NA_TS_HRDWARE_SUPP_SU
6185,28801,@2 32161 , 1 e:CS:bes:oracle.apps.jtf.cac.task.updateTask:CS/TGCS_NA_TS_HDW_SUPP_REP
So please let us know if parall forms open why the session is getting blocked. User also facing the slow ness

EXPECTED BEHAVIOR
-----------------------
Shouldn't have session block issue


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1 - Service - Sevice Request - Find Service Request - User refresh the Task to see the Status getting updated or not
2 - CRM Administrator - Task and escalation Manager - Task -Tasks - Find Task and try to the schedule it .
3 - Field service Manager - Field Service Dispatcher - Dispatch center - This is also used by some of the Dispatcher to Assign the task to the technician.
So when user keep opening the above forms it seems the application session is getting blocked and it causing the slowness.



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