My Oracle Support Banner

When Upgrading the Oracle Database to 12.2 in Preparation for Upgrading P6 to Version 18, Many Objects Are Invalid. (Doc ID 2443138.1)

Last updated on SEPTEMBER 01, 2020

Applies to:

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

Symptoms

When upgrading from Oracle 11G to Oracle 12.2, the following error occurs and several objects are invalid. Attempting to recompile them results in the following error:

PL/SQL: Statement ignored
PLS-00302: component 'FROM_REMOTE' must be declared

 

The issue can be reproduced at will using the following steps:

  1. Create an Oracle 12.2 database instance.
  2. Note the reported error which occurs when creating a P6 EPPM schema.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.