Business Operations Center Errors "ORA-00001: Unique Constraint xxx Violated" When Searching For Rating Flows (Doc ID 1354282.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.4.0.0.0 to 7.4.0.0.0 - Release: 7.4.0 to 7.4.0
Information in this document applies to any platform.

Symptoms

In Business Operation Center when searching for rating flows, the SQL package RA_SEARCH_PACK raises an error from the temporary table BATCH_IDS on the unique index on BATCH_ID column.

dm_oracle.log shows the following error:

ORACLE error: do_proc_execute : PINStmtExecute: code 1, op 0
  =ORA-00001: unique constraint (DBAIN.BATCH_IDS_I) violated
  ORA-06512: at "DBAIN.RA_SEARCH_PACK", line 45

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