DEADLOCK Issue in PCM_OP_CUST_SET_STATUS While Disconnecting Service (Doc ID 2367637.1)

Last updated on JUNE 03, 2022

Applies to:

Symptoms

Consider the below scenario where a DEADLOCK is observed for PCM_OP_CUST_SET_STATUS opcode while disconnecting all services within an account having 45 services.

Scenario:
------------
- One enterprise customer account is having 45 services. All these services are under same bill_unit.
- While running the collection, at last step, the user has sending the disconnection order to Billing and Revenue Management (BRM).
- The Order and Service Management (OSM) send disconnection order to Fusion MiddleWare (FMW) and FMW calls "PCM_OP_CUST_SET_STATUS" opcode in BRM.
- In this flow of 45 services, a couple of calls got passed and services got disconnected, but most of the rest are failed.
- For the rest of calls, there are deadlock issues while the service detail has getting updated in uniqueness table.
- From the logs, it is clear that while updating uniqueness_t, it is taking account level lock and which is causing deadlock.

ERROR in cm.pinlog:
----------------------

STEPS
-----------------------
1. Create an account from Siebel with 50-60 service under one billing profile.
2. Disconnect all the services from Siebel.

Changes

Cause

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