Balances Initialized Is Having Incorrect Valid_To When Selected As Never (Doc ID 845544.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.1.0.0 and later   [Release: 7.3.1 and later ]
HP-UX Itanium
Checked for relevance on 18-FEB-2011

Symptoms

-- Problem Statement:
Balances initialized with a product and with a discount have a different valid_to set when the valid to is selected as "Never".

There is a product which initialises a resource 1000004 on a MCF event with a balance of 470. This has a valid from of Immediately and valid_to of Never.

There is a discount which works on a purchase event, and this discount reduces the balance of 1000004 by 10. The discount balance impact has a impact type of "Impact" and the valid from and valid_to are set to "Immediately" and "Never".

Check the database in bal_grp_sub_bals_t, for the sub balance created from the product the valid to is set to "0". From the balance dump this value is shown as given below

0 PIN_FLD_BALANCES ARRAY [1000004] allocated 20, used 9
1 PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
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 [4] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] "0.0.0.1 /purchased_product 14907511"
2 PIN_FLD_CURRENT_BAL DECIMAL [0] 470
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 14907511 0
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 0
2 PIN_FLD_VALID_FROM TSTAMP [0] (1239811200) Thu Apr 16 00:00:00 2009
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (0) <null>
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0
** See the PIN_FLD_VALID_TO is set to 0.


When the discount adds a -15 with a valid_to set to never in the "Balance Impact", the database has a value of 28800 in the valid_to and the balance object contains as shown below
1 PIN_FLD_SUB_BALANCES ARRAY [18] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] "0.0.0.1 /purchased_product 14907511"
2 PIN_FLD_CURRENT_BAL DECIMAL [0] -15
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_discount 14908343 0
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 0
2 PIN_FLD_VALID_FROM TSTAMP [0] (1239894891) Thu Apr 16 23:14:51 2009
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (28800) Thu Jan 1 16:00:00 1970
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0
** See the PIN_FLD_VALID_TO is set to 28800.


When the balances modules tries to retrieve the balance which has a valid to of 28800, it does  not return these sub balances.

The pipeline initialized balance sets a valid_to of 28800, when the valid_to should be set to 'Never'. But real time balances module does not seem to consider the valid_to of 28800 as a valid_to of never.


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