My Oracle Support Banner

ODI Mapping Failure when Loading Data using Database Table-Function (Doc ID 2448539.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Information in this document applies to any platform.


Oracle Data Integrator (ODI) 12c Table-Function tables are not processing all the rows as expected.

Steps to Reproduce the Issue:

  1. Create two source tables including 13 Rows each.
  2. Mapping will contain a join of the two tables based on a Table-Function that verifies the Dates to compare if a (begindate) is less than an (enddate).  If the (enddate) is less than the (begindate), the table function returns a "self-made errorcode", which gets inserted into a logtable.
  3. If a row has a failure Date at Line 11, the insert to the logtable does not occur.
  4. If executing the SQL of the Mapping directly in the database using SQL*Plus or SQLDeveloper, the rows gets inserted into the logtable correctly.




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.