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:Oracle Life Sciences Data Management Workbench - Version 188.8.131.52 and later
Information in this document applies to any platform.
On Oracle Life Sciences Data Management Workbench (DMW) 184.108.40.206 version users see the following errors in the Transformation Log:
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
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