PCM_OP_SUBSCRIPTION_RERATE_REBILL Creates Unnecessary Sub_balances (Doc ID 795314.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.2.1.0.0
HP-UX Itanium

Symptoms

-- Problem Statement:
A call to PCM_OP_SUBSCRIPTION_RERATE_REBILL causes unnecessary SUB_BALANCES to be created.
As listed in the FLIST below, there are more than one PIN_FLD_SUB_BALANCES for the
PIN_FLD_BALANCE array. There was only 1 before rerating, and there is the original sub balance plus and additional one for each event rerated. See highlighted text below.

0 PIN_FLD_BALANCES ARRAY [840] allocated 26, used 26
1   PIN_FLD_CREDIT_PROFILE INT [0] 0
1   PIN_FLD_NEXT_BAL DECIMAL [0] 0
1   PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1   PIN_FLD_SUB_BALANCES ARRAY [0] allocated 20, used 7
2     PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2     PIN_FLD_CURRENT_BAL DECIMAL [0] 0.25
2     PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2     PIN_FLD_NEXT_BAL DECIMAL [0] 0
2     PIN_FLD_ROLLOVER_DATA INT [0] 0
2     PIN_FLD_VALID_FROM TSTAMP [0] (1214190847) Sun Jun 22 22:14:07 2008
2     PIN_FLD_VALID_TO TSTAMP [0] (0) <null>
1   PIN_FLD_SUB_BALANCES ARRAY [4] allocated 20, used 7
2     PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2     PIN_FLD_CURRENT_BAL DECIMAL [0] 0
2     PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2     PIN_FLD_NEXT_BAL DECIMAL [0] 0
2     PIN_FLD_ROLLOVER_DATA INT [0] 0
2     PIN_FLD_VALID_FROM TSTAMP [0] (1232644576) Thu Jan 22 11:16:16 2009
2     PIN_FLD_VALID_TO TSTAMP [0] (0) <null>


-- Steps To Reproduce:
-Create some usage events.
-Run pcm_op_subscription_rerate_rebill


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