Second Bill Run Fails If Any Address Updates Are Done Before The 1st Bill Run (Doc ID 2206419.1)

Last updated on AUGUST 27, 2023

Applies to:

Goal

On Oracle Communications Billing and Revenue Management (BRM) Applications 7.5.0.11.0 version, Core Billing,

It is observed that the 2nd bill run is getting failed if there is any address updates done before the 1st bill run. 

This issue is occurring only for address change before first billing scenario. In other scenarios like if address is changed after first billing then there is no issue in billing.

Scenario-1 (success):

1.  To create the first bill in the first month after billing account creation, for billinfo create event, modify fm_act_pol and set/override PIN_FLD_BILL_ACTGCYCLES_LEFT to 1.
2. Create B2B account on 12th Aug with bill_when 3, so the expected values should be
       actg_next_t - Sep 1
       actg_future_t - Oct 1
       next_bill_t - Sept 1 ( The bill required to be generated in next month)
       future_bill_t - Sep 1+3 months - Dec 1
3. Perform billing on Sep 1.
4. Do address update on Sep 5th(after first billing) (please find attached flist for PCM_OP_CUST_UPDATE_CUSTOMER which we are using e2e).
5. Perform billing on  Oct 1 -- No issues found
6. Perform billing on  Nov 1 -- No issues found
7. Final billing generated successfully on Dec 1st.

Scenario-2 (failure):

1. To create the first bill in the first month after billing account creation, for billinfo create event, modify fm_act_pol  and set/override PIN_FLD_BILL_ACTGCYCLES_LEFT to 1
2. Create B2B account on 12th Aug with bill_when 3, so the expected values should be
       actg_next_t - Sep1
       actg_future_t - Oct 1
       next_bill_t - Sept 1 ( The bill required to be generated in next month)
       future_bill_t - Sep 1+3 months - Dec 1
3. Do address update on the same day or before 1st billing.
4. Perform billing on Sep 1.
5. Perform billing on Oct 1 (fail).

Query:Why the 2nd scenario is failing?

Solution

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