Error: "P6 Professional Has Stopped Working: Windows Can Check Online For a Solution To The Problem. ORA-06550: line 2, column 13: PLS-00905: Object ADMPRM$PM.PROJSHAR_INSERT_MULTIPLE_IDS is invalid" Connecting To Oracle XE 10g (Doc ID 2246697.1)

Last updated on APRIL 20, 2017

Applies to:

Primavera P6 Professional Project Management - Version 16.1.6.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to login to P6 Professional and/or open a project in P6 Professional while connecting to a schema hosted within Oracle XE 10g, the following error occurs:

ERROR #1
-------------
P6 Professional has stopped working
Windows can check online for a solution to the problem.


Exception: TDBXError in moduelPM.exe at 00229D1A.
ORA-06550: line 2, column 13:
PLS-00905: Object ADMPRM$PM.PROJSHAR_INSERT_MULTIPLE_IDS is invalid
ORA-06550: line 2, column 3:
PL/SQL: Statement Ignored



ERROR #2
-------------
Application Exception
Type: TDBXError
Event Code: ORAL2-1218-C
Description: ORA-06550: line 2, column 13;PLS-00905: object
ADMPRM$PM.PROJSHAR_INSERT_MULTIPLE_IDS is invalidORA-06550: line 2, column
3:PL/SQL: Statement ignored

 

Changes

 The issue is not seen in the base release of 16.2, as the change to procedure was included with the first interim fix onward as a result of code changes to resolve other issues.

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