R12: Oracle Project Portfolio Analysis Packages Become Invalid After Upgrade from 11.5.10.2 to 12.1.1 (Doc ID 1124370.1)

Last updated on APRIL 11, 2023

Applies to:

Symptoms

The following Project Portfolio packages are invalid after 12.1.1 upgrade from 11.5.10.2:

APPS FPA_PLANNINGCYCLE_PVT PACKAGE BODY
APPS FPA_PROJECT_PVT PACKAGE BODY
APPS FPA_SCENARIO_PVT PACKAGE BODY
APPS FPA_VALIDATION_PROCESS_PVT PACKAGE BODY
APPS FPA_PORTFOLIO_PROJECT_SETS_PVT PACKAGE BODY
APPS FPA_MAIN_PROCESS_PVT PACKAGE BODY

Using adadmin or compile these invalids manually did not work.  Show errors on compilation gives:

SQL> alter package FPA_PLANNINGCYCLE_PVT compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY FPA_PLANNINGCYCLE_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-00201: identifier 'FPA_PLANNINGCYCLE_PVT' must be declared
1/14 PLS-00304: cannot compile body of 'FPA_PLANNINGCYCLE_PVT' without
its specification

SQL> alter package FPA_PLANNINGCYCLE_PVT compile;
alter package FPA_PLANNINGCYCLE_PVT compile
*
ERROR at line 1:
ORA-04043: object FPA_PLANNINGCYCLE_PVT does not exist

Changes

Upgraded from 11.5.10.2 to 12.1

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.