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

Last updated on JULY 05, 2016

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms