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 22.214.171.124 and later
Information in this document applies to any platform.
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:
- Create an Oracle 12.2 database instance.
- Note the reported error which occurs when creating a P6 EPPM schema.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!