DMW: Transformation Execution Encounters ORA-06508: PL/SQL: Could Not Find Program Unit Being Called (Doc ID 2976882.1)

Last updated on SEPTEMBER 26, 2023

Applies to:

Symptoms

On Oracle Life Sciences Data Management Workbench (DMW) 3.1.1.2 version users see the following errors in the Transformation Log:

ERROR
-------------
Processing static installed program id and ver:42901 6

Connected to Database using ZZ user for processing PLSQL operation :: 08-09-2023 01:24:47.351

Setting session details :: 08-09-2023 01:24:47.353

Identifying parameters needed for this executable instance :: 08-09-2023 01:24:47.356
This executable instance does not have parameters.Proceeding further.. :: 08-09-2023 01:24:47.424

Initiating source code execution. :: 08-09-2023 01:24:47.425
Job failed with error(s). :: 08-09-2023 01:24:47.532
ORA-04063: package body "<CDR_WSCHEMA_NAME>.<PACKAGE_NAME>" has errors
ORA-06508: PL/SQL: could not find program unit being called: "<CDR_WSCHEMA_NAME>.<PACKAGE_NAME>"
ORA-06512: at line 1

Closed connection after completing ZZ user operation :: 08-09-2023 01:24:47.538

Changes

Cause

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