My Oracle Support Banner

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 FEBRUARY 20, 2023

Applies to:

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


On Oracle Healthcare Analytics Data Integration (OHADI) version,

After applying the <Patch.22860309> (OHADI, 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:


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

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.


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.