My Oracle Support Banner

PCM_OP_SUBSCRIPTION_RERATE_REBILL Creates Unnecessary Sub_balances (Doc ID 795314.1)

Last updated on SEPTEMBER 26, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution
  References

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