My Oracle Support Banner

The "insert flow into I$ table" Step Hangs in an ODI Integration Interface (Doc ID 424158.1)

Last updated on OCTOBER 04, 2022

Applies to:

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


In an ODI Integration Interface processing a very large number of records, the Insert flow into I$ table step appears to hang indefinitely. Moreover, the server appears to continue processing.

Is there a problem here ?

Note that an SQL Function was applied to a Primary Key in the where clause of the join instruction.


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.