Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

PA_PWP_SUMM_PKG is invalid after upgrade database from 9.2.0.8 to 11.2.0.2 and application from 11.5

edited Jun 22, 2018 11:43AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓
PA_PWP_SUMM_PKG is invalid after upgrade database from 9.2.0.8 to 11.2.0.2 and application from 11.5.8 to 12.1.3:SQL> select text from user_source where name='PA_PWP_SUMM_PKG' and line=2;

TEXT
--------------------------------------------------------------------------------
--  $Header: PAPWPSMS.pls 120.0.12010000.2 2009/01/17 06:07:06 jjgeorge noship $


--  $Header: PAPWPSMB.pls 120.0.12010000.17 2009/08/07 11:56:03 sosharma noship
$


SQL> alter package PA_PWP_SUMM_PKG compile;

Warning: Package altered with compilation errors.

SQL> show error;
No errors.
SQL>
SQL> select line,text from user_errors where name='PA_PWP_SUMM_PKG';

     LINE
----------
TEXT
--------------------------------------------------------------------------------
      375
PL/SQL: ORA-00942: table or view does not exist

      342
PL/SQL: SQL Statement ignored

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center