My Oracle Support Banner

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

Last updated on FEBRUARY 20, 2019

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

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
Symptoms
Changes
Cause
Solution
References


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