Detect "Account Reference ID" and "Wallet ID" Data Corruption in VWS Database
(Doc ID 1383245.1)
Last updated on SEPTEMBER 15, 2023
Applies to:
Oracle Communications Network Charging and Control - Version 4.3.0 and later Oracle Solaris on SPARC (64-bit)
Purpose
This article provides the necessary background information on the E2BE Database structure, and useful SQLs to detect accounts corrupted with missing Account Reference IDs or Wallet IDs in tables
CCS_ACCT_REFERENCE
CCS_ACCT_ACCT_REFERENCES
CCS_ACCT
BE_WALLET
BE_BALANCE
BE_BUCKET
Scope
This document is intended to Oracle Communication Network Charging and Control (OCNCC or NCC) Engineers and System Administrator who are looking for possible corruption in the main E2BE tables that hold references to CLI, Account Reference, Wallets, Balances and Buckets of every user.
A basic understanding of the OCNCC Charging and Control Services (CCS) and Voucher Wallet Server (VWS) applications as well as basic understanding of Oracle SQL are necessary.
Details
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
