Database Error Reported When Trying to Mark ACS Customer as Prepaid Charging Customer

(Doc ID 2203434.1)

Last updated on DECEMBER 22, 2016

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.


The problem occurs on Oracle Communications - Network Charging and Control (OC-NCC) 5.0.2 when trying to mark one Advanced Control Services (ACS) customer as Prepaid Charging Customer.

The following 3 errors are raised:

   1. "unique constraint (CCS_ADMIN.CCS_WAL_TYP_NAME_UQ) violated"
   2. "error during execution of trigger 'CCS_ADMIN.CCS_ACS_RES_LIM_MT3'"
   3. "error during execution of trigger 'CCS_ADMIN.CCS_ACS_RES_LIM_MT2'"

This is how the dialog box looks:



 Go to ACS->Customer screen and edit ACS customer. Tick Prepaid Charging Customer checkbox and Save.


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