EM 12c: Creating a Service ATS based service test fails with ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at (Doc ID 2015855.1)

Last updated on JUNE 08, 2015

Applies to:

Oracle Application Testing Suite - Version 12.1.0.1.0 and later
Enterprise Manager Base Platform - Version 12.1.0.4.0 and later
Information in this document applies to any platform.

Symptoms

Log in to the Enterprise Manager Cloud Control console
Go to the page Services and then click on the Create menu and select the option "Generic Service - Test base"
Enter a service name and press the Next button.
Select the Test Type "ATS Transaction", fill in the fields, upload a ATS script and click Next.

You will get the following error:
Getting ora exception "
ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at
"SYSMAN.EMD_BCNTXN", line 8668 ORA-00001: unique constraint
(SYSMAN.BCN_TXN_STEP_DEFN_PRIMARY_KEY) violated ORA-06512: at
"SYSMAN.EMD_BCNTXN", line 8853 ORA-06512: at "SYSMAN.EMD_BCNTXN", line 9719
ORA-06512: at line 1"  

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