My Oracle Support Banner

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

Last updated on JULY 20, 2024

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"



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


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