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

MOSC Banner

R12.1.3 : Invalid PA_PWP_SUMM_PKG after upgrading to R12.1.3 ..

edited Feb 28, 2014 8:54AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

hello,

After review the metalink note Doc ID 1157843.1 this is happening due tot the PA_PWP_SUMM_PKG
referred to view, RA_ADDRESSES_ALL, which is obsolete in R12.

Error And versions are :

select text from user_source where name='PA_PWP_SUMM_PKG' and line=2
--  $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 $

Give the errors :

alter package PA_PWP_SUMM_PKG compile

select line,text from user_errors where name='PA_PWP_SUMM_PKG'

375    PL/SQL: ORA-00942: table or view does not exist
342    PL/SQL: SQL Statement ignored


Give the code creating the error

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