Account Balance Report Shows Incorrect Values for "Time" Balance Type (dwsublist) (Doc ID 1378298.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

Prerequisites

OCNCC 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.


Issues

Buckets 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:

On VWS,
ccs_oper$sqlplus /
SQL> select id,wallet,balance_type,expiry,value from be_bucket where id = "
2758586";

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 Impact

Report and screens do not show the same value.

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