OHADI: ODI-1228 and ORA-00933 With Code ETL Load (Doc ID 1645546.1)

Last updated on AUGUST 15, 2017

Applies to:

Oracle Healthcare Analytics Data Integration - Version 2.0.2 and later
Information in this document applies to any platform.

Symptoms

OHADI 2.0.2 version, when attempting to execute the Load_HDM_CD_SYS ETL, the following error occurs:

ERROR
-----------------------
ODI-1228 Task VAR_RULE_ID_NATURAL_KEY_NULL(Variable) fails on target connection HMC.
Caused By: java.sql.SQLSyntaxErrorException: ORA00933: SQL command not properly ended.


STEPS
-----------------------
The issue can be reproduced in Customer's environment with the following steps:
1. From ODI, connect to the Working repository;
2. Open Oracle Healthcare Analytics Data Integration/DI_MASTER_DATA_MANAGEMENT/Load_HDM_CD_SYS/Packages/Scenarios
3. Attempt to execute "PKG_HDM_CD_SYS Version 001"



Cause

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