Performance Issue on Subordinate Account Creation with Big Hierarchy Setup

(Doc ID 2337488.1)

Last updated on DECEMBER 29, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.13.0 and later
Information in this document applies to any platform.

Symptoms

On :  7.5.0.13.0 version, Customer Registration

When there is a big hierarchy setup with one parent account having more than 1000 non-paying child accounts, child account creation using MTA is taking a long time because of the lock on parent account balance group while creating each child account. The user has tried to use single thread and fewer fetch records, since child accounts are getting created sequentially.

The MTA calls a wrapper API for child account creation, the wrapped API will first create the account by calling PCM_OP_CUST_COMMIT_CUSTOMER and then later calls PCM_OP_CUST_MODIFY_CUSTOMER to add the service and purchase the products and discounts.

From this KM <Note 1561482.1> - Parent Account Balance Group Locking, there is no way to skip balance group locking.
To avoid auto triggered billing, the user already followed this KM <Note 1112197.1> - About Auto-Triggered Billing, but it does not help.

Assume products are having Currency (Monthly Recurring Fee) and Non currency resource impacts (any non currency resource with some balances).

STEPS
-----------------------
1. Prepare the input flist for creating account and purchasing assets (bundle/product/discount) with backdated date from testnap using the wrapper API which will call the following OOTB opcodes:
    a. PCM_OP_CUST_COMMIT_CUSTOMER
    b. PCM_OP_BILL_PURCHASE_DEAL
    c. PCM_OP_SUBSCRIPTION_SET_BUNDLE
2. The last OOTB opcode "PCM_OP_SUBSCRIPTION_SET_BUNDLE"  is triggering the  OOTB opcode "PCM_OP_BILL_MAKE_BILL"  for all the previous bills till the last accounting cycle.  




Changes

 

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