My Oracle Support Banner

Detect "Account Reference ID" and "Wallet ID" Data Corruption in VWS Database (Doc ID 1383245.1)

Last updated on FEBRUARY 28, 2019

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

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!


In this Document
Purpose
Scope
Details
 VWS basic database structure
 SQL to show Account Reference IDs and Wallet IDs
    SQL linking tables left to right (to detect "Child" corruptions)
    SQL linking tables right to left (to detect "Orphan" corruptions)
 What is a consistent account regarding Account Reference IDs and Wallet IDs ?
 What does this article mean by "Child" corruption
 What does this article mean by "Orphan" corruption
 Detect "Child" corruptions
    Missing "Child" Wallet ID from BE_BUCKET
    Missing "Child" Wallet ID from BE_BALANCE
    Missing "Child" Wallet ID from BE_WALLET
    Missing "Child" Wallet ID from CCS_ACCT
    Missing "Child" Account Reference from CCS_ACCT_ACCT_REFERENCES
    All of these missing "Child" Wallet / Account Reference IDs at the same time
 Detect "Orphan" corruptions
    Missing "Orphan" Account Reference ID from CCS_ACCT_REFERENCE
    Missing "Orphan" Wallet ID / Account Reference ID from CCS_ACCT_ACCT_REFERENCES
    Missing "Orphan" Wallet ID from CCS_ACCT
    Missing "Orphan" Wallet ID from BE_WALLET
    All of these "Orphan" Wallet / Account Reference IDs at the same time
 Advices on solving the corruption
 List the corrupted accounts using the queries above
 Manually update / remove the corrupted Accounts or Wallet using the NCC application
 Manually update / remove the corrupted Accounts or Wallet from the database
 Recreate the Account or Wallet using PI
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.