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 AUGUST 19, 2019

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:

ccs_oper@sms $ sqlplus /

SQL> select count(*) from ccs_pc_queue;

This should return a low count of entries (or nothing) if the entries are being processed correctly.


This problem can happen if the CCSChangeDaemon process has been disabled or has never been enabled during initial server installation and configuration.

Note: ccsChangeDaemon was called ccsPCChange in versions of CCS earlier than 3.1.8.


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.