My Oracle Support Banner

Seeing Database Locks Due to UPDATE CSM_CONTR_BUSS_TXN_TYPES_ACC Causing Complete System To Lock Down (Doc ID 2423217.1)

Last updated on FEBRUARY 20, 2019

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
---------------
Seeing session block issue running in the Telesevice module which is causing slowness in the application and the program is not moving at all.

Blocker session details :
 CSM/OMFS_PALM - e:CSM:bes:oracle.apps.jtf.cac.task.createTask
which is runing
UPDATE CSM_CONTR_BUSS_TXN_TYPES_ACC SET percent_covered = :1 ,
 up_to_amount = :2 WHERE contract_service_id = :3 AND business_p
 rocess_id = :4 AND txn_billing_type_id = :5

Ora User : APPS
Details :CS:frm:JTFTKMAN
Current SQL statement:
begin CSM_WF_PKG.Task_Assignment_Post_Ins(:1); end;
Previous SQL statement:
begin CSM_WF_PKG.Task_Assignment_Post_Ins(:1); end;
Session Waits:
WAITING: enq: TX - row lock contention
Locks:
DML/DATA ENQ H: RX R: NONE - CSM_PARTIES_ACC
DML/DATA ENQ H: RX R: NONE - JTF_TASK_ASSIGNMENTS_AUDIT_B
DML/DATA ENQ H: RX R: NONE - CSM_PARTY_SITES_ACC
DML/DATA ENQ H: RX R: NONE - CSM_CONTR_BUSS_TXN_TYPES_ACC
DML/DATA ENQ H: RX R: NONE - ASG_SYSTEM_DIRTY_QUEUE
DML/DATA ENQ H: RX R: NONE - CSM_NOTES_ACC
DML/DATA ENQ H: RX R: NONE - JTF_TASK_ASSIGNMENTS
DML/DATA ENQ H: RX R: NONE - CSM_MTL_SYSTEM_ITEMS_ACC
DML/DATA ENQ H: RX R: NONE - CSM_INCIDENTS_ALL_ACC
DML/DATA ENQ H: RX R: NONE - CSM_SR_CONTACTS_ACC

begin CSM_WF_PKG.Task_Assignment_Post_Ins(:1); end;
begin CSM_WF_PKG.Task_Assignment_Post_Ins(:1); end;
begin CSM_WF_PKG.Task_Assignment_Post_Ins(:1); end;

Ora User : APPS
Details :  e:CS:bes:oracle.apps.jtf.cac.task.updateTask
Status Flags: ACTIVE DEDICATED USER
Current SQL statement:
begin CSM_WF_PKG.Task_Assignment_Post_Ins(:1); end;
Previous SQL statement:
begin CSM_WF_PKG.Task_Assignment_Post_Ins(:1); end;
Session Waits:
WAITING: enq: TX - row lock contention


EXPECTED BEHAVIOR
-----------------------
Shouldn't have session block issue for TeleService module



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.



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.