My Oracle Support Banner

CM Taking Too Long Time to Cache Impact Categories for Large Rate Plans (Doc ID 2153614.1)

Last updated on MARCH 01, 2021

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

On : 7.5.0.12.0 version, CM

The user has created some products in BRM for usage rating where they have created many impact categories (approximately 20,000) for rateplan. It uses rate plan selector.
CM is taking long to cache these entries in memory and causing performance issues in subscription creation and usage rating.

1. CM is taking too long time for loading impact categories into cache. Its taking approximately 10 mins to load about 20,000 impact categories.
    This is breaking performance SLA and hence severely impacting usage rating and subscription setup. Its also observed that its taking long time for impact categories having long string length.

2. Why CM is caching usage rating rate plan details when subscription is created using PCM_OP_CUST_MODIFY_CUSTOMER even though there is no usage rating happening during subscription setup?
    How to avoid caching during purchase product? Its only required during usage processing.

3. Why caching is so slow and how to improve ?

Steps to reproduce the issue:

1. Create a product with a rate plan having large number of rate bal impacts entries.
2. Invoke below opocode.

nap(4854)> r gp 1
nap(4854)> xop PCM_OP_RATE_GET_RATEPLAN_LIST 0 1
xop: opcode 510, flags 0
# number of field entries allocated 20, used 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /product 1851101 0

It takes long time.

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.