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.0Information 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 (
where total < 0;
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
)
Changes
None - This is a known behavior with the software.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
Changes
Cause
Solution