Update Synonyms error --- ORA-20001: Error in Procedure DEFINE_GLOBAL_VARIABLE ORA-06508: PL/SQL: could not find program unit being called (Doc ID 2147883.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2 and later
Information in this document applies to any platform.

Goal

Customer has done the 12.2.4.1 and after that is ran the concurrent program 'Update Synonyms' and got below error

Calling CALL_DM_BUILD_PROCEDURES.
ORA-20001: Error in Procedure DEFINE_GLOBAL_VARIABLE ORA-06508: PL/SQL: could not find program unit being called

When they tried to execute below command get below error

exec demantra.CALL_DM_BUILD_PROCEDURES;

Error starting at line : 6 in command -
exec demantra.CALL_DM_BUILD_PROCEDURES
Error report -
ORA-20001: Error in Procedure DEFINE_GLOBAL_VARIABLE ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "DEMANTRA.DATA_MODEL", line 18
ORA-06512: at "DEMANTRA.DATA_MODEL", line 11796
ORA-06512: at "DEMANTRA.DATA_MODEL", line 12268
ORA-06512: at "DEMANTRA.CALL_DM_BUILD_PROCEDURES", line 72
ORA-06512: at line 1
 

Solution

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