BILL_NOW Fails If First Customer Order Is After Account Create Date (Doc ID 2225519.1)

Last updated on MAY 21, 2024

Applies to:

Symptoms

With custom implementation, the account creation and the first order for the account can be on different days. The account is billed using BILL_NOW on the first order date. After Billing and Revenue Management (BRM) is upgraded to 7.5 Patch Set (PS) 15, the first bill using BILL_NOW is failing when the account creation and first order are done on different days. The same scenario is working fine in BRM 7.5 PS12.

Scenario:

· An account is created on 1st Jan 2020
· The first order comes on 2nd Jan 2020
· After the first order, execute BILL_NOW on the customer to generate its first bill
· This BILL_NOW is failing in PS15 with below reason:
   o During the billing, the flow calls the PCM_OP_ACT_USAGE in CALC_ONLY mode to get the correct rate_plan for the customer. Since it is called in CALC_ONLY mode, the code uses dummy cycle info.
   o The product is purchased only on the 2nd Jan but the START_T is set to 1st Jan (account creation date). This results in no rate_plan and hence the error.

Error:

Steps to reproduce:

The issue can be reproduced with the following steps:
i. Account is created on 1st Jan 2020
ii.The first order comes on 2nd Jan 2020.
Following the custom flow:
1. The customer account gets created first.
2. Once the customer is provisioned (which is outside of BRM), BRM receives an order from front end to create the services and purchase the required products.
3. At this time, the customers DOM is changed to the first order date. This change is done in a way that next_bill_t is also updated according to the new DOM.
4. A deferred action is set for the same day to run BILL_NOW
5. After the first order, execute BILL_NOW on the customer to generate its first bill
6. Pin_deferred_acts then picks up this action and executes the BILL_NOW.

Changes

Cause

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