My Oracle Support Banner

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

Last updated on JANUARY 15, 2019

Applies to:

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


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

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.

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"


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.