How to Delete Large Vouchers Batches Through SQL Operations (Doc ID 1269895.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Communications Network Charging and Control - Version 4.3.0 and later
Oracle Communications Convergent Charging Controller - Version 6.0.0 and later
Information in this document applies to any platform.

Goal

This article will explain a method of deleting a large batch of vouchers (that can not be deleted using the Service Management System (SMS)) screens in a safe manner which will have as little impact on a production system as possible.

This method is applicable to all versions of Oracle Communications Network Charging and Control (OCNCC or NCC) and Oracle Communications Convergent Charging Controller (OC3C).

It is not recommended to delete large vouchers batches as it has an impact on replication load and can cause service degradation, all nodes are hit with lots of updates (well deletes) at the same time.

Solution

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