My Oracle Support Banner

After Modifying ODI (Sunopsis) Integration Interfaces Table Prefixes Then The Loading is Problematic (Doc ID 453758.1)

Last updated on SEPTEMBER 16, 2022

Applies to:

Oracle Data Integrator - Version to [Release 10gR3]
Information in this document applies to any platform.
This problem can occur on any platform.


Having changed the Work table prefixes of ODI (Sunopsis) Integration Interfaces Target table to CA$, IA$ instead of C$, I$, in the Topology Manager > Physical Architecture then ODI (Sunopsis) is no longer able to retrieve the Collect tables.

Infact, ODI (Sunopsis) continues to load from C$XXX table and NOT the expected table (CA$XXX).


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.