BRM Object Updates Negatively Impacting DML Queue Size - Service_t DML During Daily Batch Billing (Doc ID 2945399.1)

Last updated on MAY 05, 2023

Applies to:

Symptoms

On : 12.0.0.3.0 version, Core Billing

ACTUAL BEHAVIOR
---------------
During billing, in spite of prior ITEM_POID_LIST column values already being ""(NULL) BRM sets them to "" for closed services again, this is causing the performance of billing.


EXPECTED BEHAVIOR
-----------------------
When ITEM_POID_LIST column values already being ""(NULL), can BRM avoid set them to "" again. Which can help in improving performance of billing.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
A. Configuration

One has to disable all pre-created item objects including /item/misc, so that cycle billing does not populate ITEM_POID_LIST without event activity with currency (even $0) balance impacts. Either/both in business parameters and pin.conf settings.
Disable "bill suppression" & "delayed billing" if it is enabled.
Use dm_oracle DM_DEBUG{1,2,3}=0xffffffff settings to get full dm_oracle debug (in dm_oracle.log).

B. Steps thereafter:
1. Create an Email/IP sample pricing subscription with invoice pay type.
2. Close the subscription immediately but leave the account open.
3. Execute Bill Now.
4. Advance PVT 1 month and run PCM_OP_BILL_MAKE_BILL. Note the "update service_t ...item_poid_list" for each /service object (and one for /account too but different SQL columns).
5. Repeat #4 above again. Updates show up again, i.e. in spite of prior ITEM_POID_LIST column values already being "" (NULL) BRM sets them to "" (NULL) again.
6. Every month this account shows these updates. Imagine multiplying these updates by 450 million subscriptions each with 3-4 service objects each - 2 still active and 1-2 closed but all receiving ITEM_POID_LIST updates whenever PCM_OP_BILL_MAKE_BILL moves to the next billing (or perhaps accounting) cycle.



 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.