'ORA-00904: Invalid Identifier' Displayed When Running ODI 12c Mappings Set Up For CDC Processing
(Doc ID 1968822.1)
Last updated on MAY 05, 2021
Applies to:
Oracle Data Integrator - Version 12.1.3.0.0 to 12.1.3.0.1 [Release 12c]Information in this document applies to any platform.
Symptoms
When consuming journalized data with Oracle Data Integrator (ODI) 12c, each Mapping has two physical designs, one for full load direct from source, one for delta loads through journalizing via CDC.
At Mapping runtime, the following error stack is displayed:
ODI-1228: Task Load <NAME> Oracle Insert- fails on the target connection <NAME>.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: "<NAME>"."JRN_DATE": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
...
Examining the generated code shows clearly that the owner prefix for the JRN_... columns does not follow the naming of the inline views but keeps referring to the original table name.
When experimenting with the alias values in the mapping for the source table shows clearly what is happening in the generated code. More specifically, the journal columns JRN_DATE, JRN_FLAG and JRN_SUBSCRIBER get as prefix, the table's name and not the name of the inline view.
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 |