My Oracle Support Banner

Wrong Resource Balance After Set_status With End_t As 1st Day Of Month (Doc ID 1121818.1)

Last updated on JUNE 07, 2012

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.4.0.0.0 [Release 7.3.1 to 7.4.0]
Information in this document applies to any platform.

Symptoms


PCM_OP_CUST_SET_STATUS opcode to change the status of account to 10102 with end_t as 1st month result to wrong resource balances.

1. Set pin_virtual_time(pvt)  to 1st of the month
2. Create account A1 with any -ve non-currency resource balance which is of type cycle_forward
3. Move pvt to 1st of second month
4. Change status of A1 with PCM_OP_CUST_SET_STATUS to 10102 with end_t as 1st of second month (which is today according to pin_virtual_time).
5. Now, check the balances are corrupted with +ve balance
6. Change status of A1 to active 10100
7. Check the resources corrupted even more

 

=======================================================================================
Balance group after account creation
=======================================================================================
===> database 0.0.0.1 from pin.conf "userid"
nap(23325)> # number of field entries allocated 20, used 13
0 PIN_FLD_POID POID [0] 0.0.0.1 /balance_group 39335056151 2
0 PIN_FLD_CREATED_T TSTAMP [0] (1267398008) Mon Mar 01 00:00:08 2010
0 PIN_FLD_MOD_T TSTAMP [0] (1267398050) Mon Mar 01 00:00:50 2010
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "L"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 39335057943 0
0 PIN_FLD_BATCH_CNTR INT [0] 0
0 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 39335055639 0
0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1267398000) Mon Mar 01 00:00:00 2010
0 PIN_FLD_NAME STR [0] "Balance Group<Account>"
0 PIN_FLD_OBJECT_CACHE_TYPE ENUM [0] 0
0 PIN_FLD_REALTIME_CNTR INT [0] 4
0 PIN_FLD_BALANCES ARRAY [1000899] allocated 20, used 6
1 PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
1 PIN_FLD_CREDIT_PROFILE INT [0] 2
1 PIN_FLD_NEXT_BAL DECIMAL [0] 0
1 PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1 PIN_FLD_SUB_BALANCES ARRAY [2] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2 PIN_FLD_CURRENT_BAL DECIMAL [0] -50
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 39335058135 0
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
2 PIN_FLD_VALID_FROM TSTAMP [0] (1267398000) Mon Mar 01 00:00:00 2010
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (1270072800) Thu Apr 01 00:00:00 2010
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0
1 PIN_FLD_SUB_BALANCES ARRAY [4] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2 PIN_FLD_CURRENT_BAL DECIMAL [0] -50
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 39335058135 0
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
2 PIN_FLD_VALID_FROM TSTAMP [0] (1270072800) Thu Apr 01 00:00:00 2010
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (1272664800) Sat May 01 00:00:00 2010
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0

=======================================================================================
Balance group after account set_status to 10102 (Inactive)
=======================================================================================
===> database 0.0.0.1 from pin.conf "userid"
nap(24509)> # number of field entries allocated 20, used 14
0 PIN_FLD_POID POID [0] 0.0.0.1 /balance_group 39335056151 5
0 PIN_FLD_CREATED_T TSTAMP [0] (1267398008) Mon Mar 01 00:00:08 2010
0 PIN_FLD_MOD_T TSTAMP [0] (1270245616) Sat Apr 03 00:00:16 2010
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "L"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 39335057943 0
0 PIN_FLD_BATCH_CNTR INT [0] 0
0 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 39335055639 0
0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1267398000) Mon Mar 01 00:00:00 2010
0 PIN_FLD_NAME STR [0] "Balance Group<Account>"
0 PIN_FLD_OBJECT_CACHE_TYPE ENUM [0] 0
0 PIN_FLD_REALTIME_CNTR INT [0] 8
0 PIN_FLD_BALANCES ARRAY [756] allocated 20, used 5
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 [0] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
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_product 39335055959 1
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 0
2 PIN_FLD_VALID_FROM TSTAMP [0] (1270072799) Wed Mar 31 23:59:59 2010
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
0 PIN_FLD_BALANCES ARRAY [1000899] allocated 20, used 8
1 PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
1 PIN_FLD_CREDIT_PROFILE INT [0] 2
1 PIN_FLD_NEXT_BAL DECIMAL [0] 0
1 PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1 PIN_FLD_SUB_BALANCES ARRAY [2] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2 PIN_FLD_CURRENT_BAL DECIMAL [0] -50
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 39335058135 0
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
2 PIN_FLD_VALID_FROM TSTAMP [0] (1267398000) Mon Mar 01 00:00:00 2010
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (1270072800) Thu Apr 01 00:00:00 2010
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0
1 PIN_FLD_SUB_BALANCES ARRAY [4] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2 PIN_FLD_CURRENT_BAL DECIMAL [0] -50
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 39335058135 0
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
2 PIN_FLD_VALID_FROM TSTAMP [0] (1270072800) Thu Apr 01 00:00:00 2010
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (1272664800) Sat May 01 00:00:00 2010
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0
1 PIN_FLD_SUB_BALANCES ARRAY [6] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2 PIN_FLD_CURRENT_BAL DECIMAL [0] -50
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 39335058135 1
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
2 PIN_FLD_VALID_FROM TSTAMP [0] (1272664800) Sat May 01 00:00:00 2010
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (1275343200) Tue Jun 01 00:00:00 2010
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0
1 PIN_FLD_SUB_BALANCES ARRAY [8] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2 PIN_FLD_CURRENT_BAL DECIMAL [0] 100  ---corrupted
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 39335058135 2
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 0
2 PIN_FLD_VALID_FROM TSTAMP [0] (1267398000) Mon Mar 01 00:00:00 2010
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (1270072800) Thu Apr 01 00:00:00 2010
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0

=======================================================================================
Balance group after account set_status to 10100 (Active)
=======================================================================================
===> database 0.0.0.1 from pin.conf "userid"
nap(28357)> # number of field entries allocated 20, used 14
0 PIN_FLD_POID POID [0] 0.0.0.1 /balance_group 39335056151 7
0 PIN_FLD_CREATED_T TSTAMP [0] (1267398008) Mon Mar 01 00:00:08 2010
0 PIN_FLD_MOD_T TSTAMP [0] (1270246047) Sat Apr 03 00:07:27 2010
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "L"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 39335057943 0
0 PIN_FLD_BATCH_CNTR INT [0] 0
0 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 39335055639 0
0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1267398000) Mon Mar 01 00:00:00 2010
0 PIN_FLD_NAME STR [0] "Balance Group<Account>"
0 PIN_FLD_OBJECT_CACHE_TYPE ENUM [0] 0
0 PIN_FLD_REALTIME_CNTR INT [0] 10
0 PIN_FLD_BALANCES ARRAY [756] allocated 20, used 5
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 [0] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
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_product 39335055959 1
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 0
2 PIN_FLD_VALID_FROM TSTAMP [0] (1270072799) Wed Mar 31 23:59:59 2010
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
0 PIN_FLD_BALANCES ARRAY [1000899] allocated 20, used 9
1 PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
1 PIN_FLD_CREDIT_PROFILE INT [0] 2
1 PIN_FLD_NEXT_BAL DECIMAL [0] -50
1 PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1 PIN_FLD_SUB_BALANCES ARRAY [2] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2 PIN_FLD_CURRENT_BAL DECIMAL [0] -50
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 39335058135 0
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
2 PIN_FLD_VALID_FROM TSTAMP [0] (1267398000) Mon Mar 01 00:00:00 2010
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (1270072800) Thu Apr 01 00:00:00 2010
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0
1 PIN_FLD_SUB_BALANCES ARRAY [4] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2 PIN_FLD_CURRENT_BAL DECIMAL [0] -50
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 39335058135 0
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
2 PIN_FLD_VALID_FROM TSTAMP [0] (1270072800) Thu Apr 01 00:00:00 2010
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (1272664800) Sat May 01 00:00:00 2010
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0
1 PIN_FLD_SUB_BALANCES ARRAY [6] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2 PIN_FLD_CURRENT_BAL DECIMAL [0] -100
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 39335058135 4
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
2 PIN_FLD_VALID_FROM TSTAMP [0] (1272664800) Sat May 01 00:00:00 2010
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (1275343200) Tue Jun 01 00:00:00 2010
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0
1 PIN_FLD_SUB_BALANCES ARRAY [8] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2 PIN_FLD_CURRENT_BAL DECIMAL [0] 100 ---corrupted
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 39335058135 2
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 0
2 PIN_FLD_VALID_FROM TSTAMP [0] (1267398000) Mon Mar 01 00:00:00 2010
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (1270072800) Thu Apr 01 00:00:00 2010
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0
1 PIN_FLD_SUB_BALANCES ARRAY [10] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2 PIN_FLD_CURRENT_BAL DECIMAL [0] -50
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 39335058135 4
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
2 PIN_FLD_VALID_FROM TSTAMP [0] (1270245600) Sat Apr 03 00:00:00 2010
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (1272664800) Sat May 01 00:00:00 2010
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0

 

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.