PKG_HDI_PT Execution Fails with 'ORA-12813: value for PARALLEL or DEGREE must be greater than 0' (Doc ID 2252361.1)

Last updated on APRIL 25, 2017

Applies to:

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

Symptoms

ISSUE CLARIFICATION
==================
On Oracle Healthcare Analytics Data Integration (OHADI) 3.1.0.2 version,

After applying the <Patch.22860309> (OHADI 3.1.0.2), when attempting to execute the Package PKG_HDI_PT from a custom created Load Plan
with ODI J2EE Agent, it fails during the Step "44 - Integration - Int_HDI_PT_HDM_PRTY - OHADI alter session force parallel dml"
with the following error:

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


This errors seems to happen for all Packages loading HDI data, except the ones with Code Data.

STEPS
-----------------------
The issue can be reproduced with the following steps:
1. From ODI connect to Oracle healthcare Analytics Data Integration repository;
2. Navigate to Load Plans and Scenarios and execute the custom created Load Plan with a J2EE agent.


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