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 22.214.171.124.0 to 126.96.36.199.2 [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:
- Create two source tables including 13 Rows each.
- 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.
- If a row has a failure Date at Line 11, the insert to the logtable does not occur.
- 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