Error: "PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be declared" Upgrading Oracle Database To P6 EPPM Or Installing A New P6 EPPM Database

(Doc ID 1622981.1)

Last updated on MARCH 30, 2017

Applies to:

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


When attempting to install or upgrade an Oracle Database to r8.3.2.0, the following error occurs:

ERROR>RuntimeException: Could not complete because the job "Perform post upgrade steps" failed. (Could not complete because the job "Perform post upgrade steps" failed.)
OUTPUT>[ERROR] [TIMESTAMP] Database Error: error number=6550
OUTPUT>[ERROR] [TIMESTAMP] Error Message: ORA-06550: line 2, column 3:
OUTPUT>PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be declared
OUTPUT>ORA-06550: line 2, column 3:
OUTPUT>PL/SQL: Statement ignored
OUTPUT>USER [WARN] : Could not complete because the job "Run SQL Script orpm_ctxindex.sql" failed.


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