My Oracle Support Banner

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

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
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.