"ORA-00001: Unique Constraint Violated" Error While Creating More Than One Periodic Charge (Doc ID 2012262.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Communications Network Charging and Control - Version 5.0.2 to 5.0.3 [Release 5.0]
Information in this document applies to any platform.

Symptoms

In Oracle Communications Network Charging and Control (NCC) version 5.0.2, the below error is reported while creating a new Periodic Charge (PC) via the Wallet Management → Periodic Charge Screen on the SMS.

An SQL Error has occurred.
ORA-00001': unique constraint (CCS_ADMIN.CCS_BALTY_CDRNAME_UQ) violated
ORA-06512: at "CCS_ADMIN.CCS_PERIODIC_CHARGE_BI", line 9
ORA-04088: error during execution of trigger 'CCS_ADMIN.CCS_PERIODIC_CHARGE_BI'

This happens each time an attempt is made to create a new PC after the first PC.

Changes

Creating more than one PC on the platform.

Cause

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