ODI 12.1.3 Mapping generates Inline view name _13 causes ORA-00911: invalid character error

ODI 12.1.3 Mapping generates Inline view name _13 causes ORA-00911: invalid character error

INLINE_VIEW_N is being generated incorrectly which is causing ORA-00911: invalid character errrors.

Ex:

Pattern like:

INLINE_VIEW_11
INL_12
_13

The _13 causes the error below

ODI-1228: Task Load xxx Oracle Insert- fails on the target
connection xx_xxxxxxxxxxxx.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

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)


This issue fixed in ODI 12.2.1. For ODI 12.1.3, download and apply Patch 20206720


Related Posts:

ODI 12.1.3 - Applying Patch 20206720: 12.1.3 Generates Inline view name _13 which causes ORA-00911: invalid character

ODI 12.1.3 - Installing a collocated agent from the ODI Enterprise Installation