Account Balance Report Shows Incorrect Values for "Time" Balance Type (dwsublist)
Last updated on SEPTEMBER 06, 2016
Applies to:Oracle Communications Network Charging and Control - Version: 4.3.0
Information in this document applies to any platform.
PrerequisitesOCNCC provides Reports functionality, part of CCS product.
The Account Balance Report details the wallet information for each subscriber. Account Balance (csv) Report provides items comma separated. It is ordered by Product Type and Wallet State. The report shows the current status of wallets at the time it was run.
Account Balance Report is configurable via SMS (Service Management System) Screen:
(Operator Function --> Report Function --> Account Balance Report)
For further information about Reports, refer to SMS and CCS user documentation in Doc 1341844.1.
IssuesBuckets having their balance_unit being "Time" (as opposed to, for instance, "Cash") are stored in centi-seconds in Database.
Here under an example of a bucket having 600000 centi-seconds value:
SQL> select id,wallet,balance_type,expiry,value from be_bucket where id = "
ID WALLET BALANCE_TYPE EXPIRY VALUE
------- ------ ------------ ------------- ------
2758586 861 460 20111208161454 600000
- When opening Wallet details for this subscriber in the screen (SMS -> ChargingMax -> Subscribers Management -> Select Subscriber), the value shown will be: 6000 (100:00)
- When checking Reports output, the value is:
acs_oper@sms01:/oracle/data1/EDR_MANAGEMENT/Reports$ grep 123456789 ccsAccountBalanceCSV-20111110000000
123456789,861,Staff,A,20121108161526,BillShock,,Consumer Bundle SMS,250,Consumer Bundle Voice Minutes,60,Free SMS,,General Cash,179.88,Monthly Exp,.00,National Data,,National Onnet Voice,,National SMS,,National Voice,,Promo SMS,,Promotional Cash,,Promotional Cash,,Topup Bonus Eligibility,,Yearly Exp,.00
In other words, the Screens will show the Value in Seconds (as designed) while the Report will divide again by 100.
Business ImpactReport and screens do not show the same value.
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