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 12.2.1.3.0 to 12.2.1.3.2 [Release 12c]Information in this document applies to any platform.
Symptoms
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.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |