Rerating Usage Results in Positive Resource Value

(Doc ID 1610319.1)

Last updated on NOVEMBER 02, 2015

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.1 [Release 7.3.0]
Information in this document applies to any platform.

Symptoms

On : BRM 7.3.0.0.0 version, Subscription Management

Issue:

Rerating is performed after purchasing a backdated offer (with additional free resource) and result is that the non-currency resource ( additional free resource) value becomes positive after rerating while it should not go above zero.

Scenario:

 01. create an account
 02. create a service (telephony)
 03. set service aliases
 04. purchase basic offer ( telephony)
 05. create a second service ( data )
 06. purchase second service offer (data)
 07. set PVT +3 days
 08. rate delayed usage ( telephony )
 09. load rated events using rel
 10. set PVT +3 days
 11. perform backdated purchase of another offer (telephony and data) to 6 days ago
 12. request rerating on 'telephony' since 6 days ago, that is, create rerate job
 13. request rerating on 'data' since 6 days ago, that is, create rerate job
 14. run rerating
 15. get balances for telephony bal_group
 16. see that, for example, resource 2101001 ( from backdated offer ) contains positive value while it is expected to be zero :

0 PIN_FLD_BALANCES      ARRAY [978] allocated 20, used 7
1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
1     PIN_FLD_CONSUMPTION_RULE   ENUM [0] 0
1     PIN_FLD_CURRENT_BAL  DECIMAL [0] 57.807
1     PIN_FLD_CREDIT_LIMIT DECIMAL [0] NULL
1     PIN_FLD_CREDIT_FLOOR DECIMAL [0] NULL
1     PIN_FLD_CREDIT_THRESHOLDS    INT [0] 0
0 PIN_FLD_REALTIME_CNTR    INT [0] 14
0 PIN_FLD_BALANCES      ARRAY [100002] allocated 20, used 7
1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
1     PIN_FLD_CONSUMPTION_RULE   ENUM [0] 0
1     PIN_FLD_CURRENT_BAL  DECIMAL [0] -0.42857
1     PIN_FLD_CREDIT_LIMIT DECIMAL [0] 0
1     PIN_FLD_CREDIT_FLOOR DECIMAL [0] NULL
1     PIN_FLD_CREDIT_THRESHOLDS    INT [0] 0
0 PIN_FLD_BALANCES      ARRAY [2101001] allocated 20, used 7
1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
1     PIN_FLD_CONSUMPTION_RULE   ENUM [0] 0
1     PIN_FLD_CURRENT_BAL  DECIMAL [0] 1286
1     PIN_FLD_CREDIT_LIMIT DECIMAL [0] 0
1     PIN_FLD_CREDIT_FLOOR DECIMAL [0] NULL
1     PIN_FLD_CREDIT_THRESHOLDS    INT [0] 0

  

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