Subscription Reactivation Within The Same Day Gives Incorrect Bill Amount Result (Doc ID 1265000.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.4.0.0.0 to 7.4.0.0.0 - Release: 7.4.0 to 7.4.0
Oracle Solaris on SPARC (32-bit)

Symptoms

A product with scaled amount 200(for eg) is inactivated on 15th of a month using opcode PCM_OP_CUST_SET_STATUS with END_T as 00:00:00 16th of the same month.
Again on the same day i.e. 15th, if the product is again re-activated using opcode PCM_OP_CUST_SET_STATUS with END_T as 00:00:01 16th of the same month then the following was observed.

The first month's total billing amount is 100.
The second month's billing amount is 300.

i.e., the amount is bifurcated and the remaining balance is billed in next to next month

Replication Steps:
-------------------

1. Created a product with Monthly Cycle Arrear Event with scaled amount as 200.

2. On 1st June,2009 created an account with the above product.

3. On 15th June,2009, used the opcode PCM_OP_CUST_SET_STATUS with the following input flist to inactivate the account with END_T 16th June 2009, 00:00:00.

0 PIN_FLD_POID POID [0] 0.0.0.1 /account 5054260 14
0 PIN_FLD_PROGRAM_NAME STR [0] "xxxxxxxxxxxxx"
0 PIN_FLD_END_T TSTAMP [0] (1245110400) Tue Jun 15 18:30:00 2009
0 PIN_FLD_STATUSES ARRAY [0] allocated 20, used 2
1 PIN_FLD_STATUS ENUM [0] 10102
1 PIN_FLD_STATUS_FLAGS INT [0] 64

4. On the same day i.e., 15th June,2009 at 1600 hrs again re-activate the account with END_T 16th June 2009, 00:00:01. Used the opcode PCM_OP_CUST_SET_STATUS with the following input flist.

0 PIN_FLD_POID POID [0] 0.0.0.1 /account 5054260 14
0 PIN_FLD_PROGRAM_NAME STR [0] "xxxxxxxxxxxxx"
0 PIN_FLD_END_T TSTAMP [0] (1245110401) Tue Jun 16 00:00:00 2009
0 PIN_FLD_STATUSES ARRAY [0] allocated 20, used 2
1 PIN_FLD_STATUS ENUM [0] 10100
1 PIN_FLD_STATUS_FLAGS INT [0] 64

5. On 2nd July, 2009, billed the account. Total amount is 100.

6. On 2nd August, 2009, billed the account. Total amount is 300.

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