Create Oracle Tables and Views Load Set Fails with ORA-06508: PL/SQL: could not find program unit being called in Package cdr_df_loadset Procedure createLoadSet (Doc ID 1672801.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Life Sciences Data Hub - Version 2.2.0.5 and later
Information in this document applies to any platform.

Symptoms

Attempting to create a new Load Set definition and instance of type Oracle Tables and Views in Oracle LSH , the following error occurs:

ORA-20099: ** ERROR: CDR_WC81_CEBF59_1.CDR_ATK_OracleDB.CreateLogFilePlannedOutput -
ORA-06508: PL/SQL: could not find program unit being called in Package cdr_df_loadset Procedure createLoadSet

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a new Load set definition and instance.
2. Select Oracle Tables and Views adapter type
3. Click Apply

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