My Oracle Support Banner

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.


On : 12.2.6 version,

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
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
4958,13586,@2 12538 , 2
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

Shouldn't have session block issue

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.


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.