My Oracle Support Banner

Invalid FPA Views After Upgrade to 12.2.x (Doc ID 2694029.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Project Portfolio Analysis - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.8 version

Invalid packages are showing up

Errors for PACKAGE BODY FPA_MAIN_PROCESS_PVT:

41/5 PL/SQL: SQL Statement ignored
48/10 PL/SQL: ORA-00942: table or view does not exist
637/4 PL/SQL: SQL Statement ignored
643/7 PL/SQL: ORA-00942: table or view does not exist
697/1 PL/SQL: SQL Statement ignored
699/8 PL/SQL: ORA-00942: table or view does not exist
746/4 PL/SQL: SQL Statement ignored
749/27 PL/SQL: ORA-00942: table or view does not exist
1382/7 PL/SQL: SQL Statement ignored
1386/14 PL/SQL: ORA-00942: table or view does not exist
1478/3 PL/SQL: Statement ignored
1478/3 PLS-00201: identifier 'FPA_PROJECT_PVT.LOAD_PROJECT_DETAILS_AW'
  must be declared


1573/18 PL/SQL: Item ignored
1573/18 PLS-00201: identifier 'FPA_AW_PC_INFO_V.PC_STATUS' must be
  declared

1582/4 PL/SQL: Statement ignored
1582/4 PLS-00320: the declaration of the type of this expression is
  incomplete or malformed

1585/4 PL/SQL: Statement ignored
1587/60 PLS-00320: the declaration of the type of this expression is
  incomplete or malformed


1636/4 PL/SQL: Statement ignored
1636/4 PLS-00201: identifier
  'FPA_PORTFOLIO_PROJECT_SETS_PVT.ADD_PROJECT_SET_LINES' must be
  declared

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!


In this Document
Symptoms
Cause
Solution
References


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