High Number of Suspensed Records Due to Concurrent Usage in Sharing Group for Bulk SMS (Doc ID 2671591.1)

Last updated on AUGUST 25, 2023

Applies to:

Symptoms

In a product system it was observed that there was high usage suspense majorly due to bulk Short Message Service (SMS) coming concurrently from two members who belong to same sharing group, where both are trying to get a lock on the sharing group owner in parallel and it is causing suspense as one of it could not get lock with the retry limit. Even if one moves old files and tries to process them in batches, as new files of same two numbers are coming as well, it is suspending them.

Steps to reproduce:

1. Created a Charge Offering (CO) with TeloGsmSms
2. Created a Charge sharing object in Pricing Design Center (PDC)
3. Created four accounts parent1, child1, child2 and child3 with above CO
4. Associated all the three child account to parent account for charge sharing
5. Processed 8250 records

Observation: 2453 records failed with error CUSTOMER_IN_TRANSACTION and moved to Suspense.

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.