Performance Issue on Subordinate Account Creation with Big Hierarchy Setup
Last updated on DECEMBER 29, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.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).
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:
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.
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