ETL Jobs Fail With ODI-1228 for New OPLA Installation on Linux Environment

(Doc ID 2096071.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Product Lifecycle Analytics - Version 3.4.0 and later
Generic Linux


When running Analytics_ETL Version 001, gets below error while Task: Integration, odi_int_CREATE_DBLINK, Delete records from Target is run

ODI-1228: Task odi_int_CREATE_DBLINK (Integration) fails on the target ORACLE connection TRG_ODMCONN_PHYSICAL.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

Below SQL is run:

The issue can be reproduced at will with the following steps:
1. Run Analytics_ETL Version 001


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms