"ORA-00001: unique constraint (ODIW_PROD_12A.PK_SCEN_TASK) violated" while Generating a New ODI Scenario (Doc ID 2091713.1)

Last updated on JULY 12, 2016

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 to 12.2.1.0.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

Creating a new ODI 12.1.3.0.0. scenario for a package fails with the following error message:

Changes

The environment was migrated from Release 10. The versions of the scenario do not have the expected values of 001,002,...,00n but rather 1,2,3,4.

The same error occurs if the scenarios are changed from their defaults to letters or numbers regardless of the version the repository was created in.

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