ORA-01427 Error Generated when Running Int_HDI_PT_HDM_IND_PRTY Incremental Load (Doc ID 2123466.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

ISSUE CLARIFICATION
==================
On Oracle Healthcare Analytics Data Integration (OHADI) 2.0.2 with ODI with a RAC database,
The following error message is generated when running Int_HDI_PT_HDM_IND_PRTY Incremental Load:

ERROR
-----------------------



STEPS
-----------------------
The issue can be reproduced with the following steps:
1. From ODI login to OHADI 2.0.2 repository;
2. Go to "DI_HDWF_INCREMENTAL_LOAD"/"Load_DI_HDWF_INCREMENTAL_LOAD_HDI_PT" folder.
3. Run the PKG_OHADI_HDI_PT_INCREMENTAL scenario;

The execution fails during step "21 - Int_HDI_PT_HDM_IND_PRTY" execution.

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