Msddemobicrsyn.Sql Fails During 12.1.3 Upgrade (Doc ID 1384477.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.1.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Nov-2013***

Goal



Customer is applying the 12.1.3 Maintenance pack patch 9239090 and the worker failing on the msddemobicrsyn.sql

The logs show the following error

Time when worker started job: Fri Nov 04 2011 11:13:27


Start time for file is: Fri Nov 04 2011 11:13:27

sqlplus -s APPS/***** @MSD_TOP/patch/115/sql/msddemobicrsyn.sql
Connected.
DECLARE
*
ERROR at line 1:
ORA-04063: package body "APPS.MSD_DEM_COMMON_UTILITIES" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"APPS.MSD_DEM_COMMON_UTILITIES"
ORA-06512: at line 18




Time when worker failed: Fri Nov 04 2011 11:13:29


Time when worker started job: Fri Nov 04 2011 11:13:29


Start time for file is: Fri Nov 04 2011 11:13:29

sqlplus -s APPS/***** @MSD_TOP/patch/115/sql/msddemobicrsyn.sql
Connected.
DECLARE
*
ERROR at line 1:
ORA-04063: package body "APPS.MSD_DEM_COMMON_UTILITIES" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"APPS.MSD_DEM_COMMON_UTILITIES"
ORA-06512: at line 18




Time when worker failed: Fri Nov 04 2011 11:13:30


The Package Body is invalid



SQL> select status,object_type from dba_objects where object_name='MSD_DEM_COMMON_UTILITIES';

STATUS OBJECT_TYPE
------- -------------------
INVALID PACKAGE BODY
VALID PACKAGE

SQL> SET SERVEROUTPUT ON
SQL> alter package apps.MSD_DEM_COMMON_UTILITIES compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY APPS.MSD_DEM_COMMON_UTILITIES:

LINE/COL ERROR
-------- -----------------------------------------------------------------
125/15 PLS-00323: subprogram or cursor 'UPDATE_SYNONYMS' is declared in
a package specification and must be defined in the package body

306/16 PLS-00323: subprogram or cursor 'UOM_CONV' is declared in a
package specification and must be defined in the package body

316/16 PLS-00323: subprogram or cursor 'GET_LOOKUP_CODE' is declared in
a package specification and must be defined in the package body

325/16 PLS-00323: subprogram or cursor 'GET_LEVEL_NAME' is declared in
a package specification and must be defined in the package body

LINE/COL ERROR
-------- -----------------------------------------------------------------

336/16 PLS-00323: subprogram or cursor 'GET_DEMANTRA_DATE' is declared
in a package specification and must be defined in the package
body

347/16 PLS-00323: subprogram or cursor 'IS_USE_NEW_SITE_FORMAT' is
declared in a package specification and must be defined in the
package body

353/16 PLS-00323: subprogram or cursor 'GET_DEMANTRA_VERSION' is
declared in a package specification and must be defined in the

LINE/COL ERROR
-------- -----------------------------------------------------------------
package body

362/16 PLS-00323: subprogram or cursor 'GET_APP_ID_TEXT' is declared in
a package specification and must be defined in the package body

381/15 PLS-00323: subprogram or cursor 'UPDATE_DEM_APCC_SYNONYM' is
declared in a package specification and must be defined in the
package body

396/13 PLS-00323: subprogram or cursor 'GET_CTO_EFFECTIVE_DATE' is
declared in a package specification and must be defined in the

LINE/COL ERROR
-------- -----------------------------------------------------------------
package body


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