My Oracle Support Banner

Troubleshooting the Use of Sequences with ODI (Doc ID 423872.1)

Last updated on DECEMBER 18, 2023

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Symptoms

What are the possible approaches to use Sequences in Oracle Data Integrator (ODI) and how to troubleshoot their usage?

After defining an ODI Sequence to map the primary key column in an ODI 12c Mapping (or ODI 11g / 10g Integration Interface), certain messages are signaled. What are they due to?

Case 1. Unique constraint violated

This message is signaled at runtime when the Sequence is set on the default (staging area) and referenced in a sub-select statement of (for example) the Insert into flow table step of an ODI 12c Mapping (or ODI 11g / 10g Integration Interface).

The article applies to all releases of ODI like the current 12C as well as to previous releases.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.