ORA-00001: Unique Constraint (pin.i_event__id) Violated (Doc ID 880518.1)

Last updated on JUNE 21, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 27-Nov-2012***
***Checked for relevance on 21-JUNE-2017***

Goal

Cannot activate/create accounts in BRM. The following error is thrown in dm_oracle pinlog:

ORACLE error: do_sql_insert: PINStmtExecute: code 1, op 0
=ORA-00001: unique constraint (PIN.I_EVENT__ID) violated

ORACLE error: do_sql_insert: PINStmtExecute: code 1, op 0
=ORA-00001: unique constraint (PIN.I_PURCHASED_PRODUCT__ID) violated



Solution

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