My Oracle Support Banner

The CCS_PC_QUEUE Database Table Entries Are Accumulating Causing Changes to Subscribers Periodic Charges to Fail (Doc ID 1292275.1)

Last updated on APRIL 26, 2021

Applies to:

Oracle Communications Network Charging and Control - Version 3.1.0 and later
Information in this document applies to any platform.


The number of entries in the SMF database table CCS_PC_QUEUE is increasing over time on the Service Management System (SMS).

To check if this issue is happening on your SMS, connect to the SMF database and run the following query:


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
 1. Delete part of the CCS_PC_CHANGE entries via SQL commands
 2. Activate the ccsChangeDaemon Process
 a) Single Node SMS
 b) Clustered SMS

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