Microsoft Project Objects Will Not Compile when created or clone WAM Database instance (Doc ID 565531.1)

Last updated on OCTOBER 17, 2011

Applies to:

Oracle Utilities Work and Asset Management - Version: 1.7.10 and later   [Release: 1.7 and later ]
Information in this document applies to any platform.

Symptoms

I used EXP to dump my Synergen user out of my 9i LIVE database. I then used IMP to bring the data
into my 10g DEV database. Everything worked fine except the MSproject stuff. I can't seem get
these compiled.


SQL> spool off
SQL> /* User Instructions:
SQL> Run this script again if there are still "INVALID" objects.
SQL> This script will recompile any "INVALID" objects.
SQL> The following objects are now invalid
SQL> */
SQL> select substr(object_name,1,30),object_type from user_objects
2 where status = 'INVALID';
SV_MSPROJECT_TASK VIEW
SV_MSPROJECT_SUBPROJECT VIEW
SV_MSPROJ98_TASK VIEW
SV_MSPROJ98_SUBPROJECT VIEW
SV_MSPROJ98_RESOURCE VIEW
SV_MSPROJECT_RESOURCE VIEW
SV_MSPROJ98_ITEM VIEW
SV_MSPROJECT_ITEM VIEW
SDBP_GET_MSPROJ98_STATUS PROCEDURE
SDBP_GET_MSPROJECT_STATUS PROCEDURE
SDBP_BOOLEAN_WRAPPER PROCEDURE
MSP_BACKUP_TASK PROCEDURE
SDBT_AU_MSP_PROJECTS TRIGGER
SDBP_GENERATE_MSPROJECT PACKAGE BODY
SDBP_GENERATE_MSPROJECT98 PACKAGE BODY
SDBP_UPDATE_MSPROJECT PACKAGE BODY

16 rows selected.







Cause

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