"ODI-26184" and "ORA-00001: unique constraint" Of PK_VAR_SB When Executing A Package Step In ODI 12c
Last updated on JANUARY 05, 2018
Applies to:Oracle Data Integrator - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
A Mapping in Oracle Data Integrator (ODI) 12c uses a Knowledge Module which sets one of its option values to an ODI Variable.
A package has two steps, as follows:
- Step 1 -- Declare of Variable above
- Step 2 -- The Mapping above
A BluePrint is defined on the Variable from the Package "Declare Variable" step.
The execution of the whole Package successfully starts. Same for the manual execution of the Mapping, outside the Package.
However, when executing the Mapping from the Package step, using the "Execute Step" feature, no Session is started, and a violation of PK_VAR_SB is received:
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