Balance Goes Negative with CCSSC1=ADD Command (Doc ID 1308880.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle Communications Network Charging and Control - Version: 4.2.0 and later   [Release: 4.2 and later ]
Information in this document applies to any platform.

Symptoms


Subscribers obtain a negative amount in a bucket in the general cash balance after deduction through PI (Provisioning Interface).
Besides this the negative buckets get an expiry date the same as the last bucket created ( the one with largest expiry time) .

When there is more than 1 bucket within a Balance Type
1. CCSSC1 PI Command allows the General Cash balance to go -ve.
2. The expiry date of the first expiring bucket is modified.
3. Subsequent charge should not be allowed once the balance of a Balance Type is -ve


Example 1.1:

General Cash:
Bucket #1: 8  Euro (exp 30/08)
Bucket #2: 10 Euro (exp 30/09)

CCSSC1=ADD:MSISDN=31637001801,CHARGE=1000,REFUND=0,BALANCE_TYPE=General
Cash,EXTRA_EDR="ORGN=DEKA_SCMB",SYNSTAMP=XXX;


Result 1.1:

General Cash:
Bucket #1: -2 Euro (exp 30/09)
Bucket #2: 10 Euro (exp 30/09)


We observe two problems here, the bucket supposed to expire first went negative AND its expiry date has been modified.


Example 1.2:

General Cash:
Bucket #1: -2 Euro (exp 30/09)
Bucket #2: 10 Euro (exp 30/09)

CCSSC1=ADD:MSISDN=31637001801,CHARGE=1000,REFUND=0,BALANCE_TYPE=General
Cash,EXTRA_EDR="ORGN=DEKA_SCMB",SYNSTAMP=XXX;


Result 1.2:

General Cash:
Bucket #1: -12 Euro (exp 30/09)
Bucket #2: 10 Euro (exp 30/09)

Here the command has been acknowledged and the negative bucket has been charged, which leads the a total Balance negative

In case you want to identify all Accounts and their negative Balance type, use the following query which must be run on the VWS node:

select * from (
  select car.cli, cbt.name, sum(bb.value) as total
  from be_bucket bb, ccs_acct_reference car, ccs_acct_acct_references caar,
ccs_balance_type cbt
  where bb.wallet = caar.account and caar.acct_reference = car.id
  and bb.balance_type = cbt.id
  group by car.cli, cbt.name
  ) where total < 0;



Changes

None - This is a known behavior with the software.

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