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

Last updated on APRIL 17, 2024

Applies to:

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

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