My Oracle Support Banner

ODI Integration Interfaces and the Use of Identity Fields (Doc ID 423778.1)

Last updated on AUGUST 28, 2023

Applies to:

Oracle Data Integrator - Version 4.1.01.05 to 11.1.1.9.99 [Release 4.1.01 to 11gR1]
Information in this document applies to any platform.

Goal

Case 1.
In the case where the primary key of a Datastore is an Identity column and is used as an update key in an interface, the flow control fails with a Column does not exist message on the Insert PK errors step.

Case 2.
Having an Identity column mapped for the target Datastore results in failure on the Create error table flow control step.

Case 3.
How may I map a target Identity-type column in order to use automatically generate values in Microsoft SQLServer?

Solution

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.