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

Last updated on MARCH 30, 2017

Applies to:

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

Symptoms

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

ERROR
-----------------
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.

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