MyOracleWorld.Net  .........

 

PA_PWP_SUMM_PKG Invalid after 12.1.1 upgrade to 12.1.3

Errors:

 

SQL> select owner,object_name,object_type from dba_objects where status='INVALID'; 

 

OWNER               OBJECT_NAME                   OBJECT_TYPE 

------------------- ----------------------------- ------------------- 

APPS                PA_PWP_SUMM_PKG               PACKAGE BODY 

 

SQL> 

 

SQL> alter package apps.PA_PWP_SUMM_PKG compile body;

 

Warning: Package Body altered with compilation errors.

 

SQL> show errors;

Errors for PACKAGE BODY APPS.PA_PWP_SUMM_PKG:

 

LINE/COL ERROR

-------- -----------------------------------------------------------------

342/1     PL/SQL: SQL Statement ignored

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

SQL>

 

 

 

Solution:

 

After upgrade to 12.1.2/3 you might see 1 invalid object called PA_PWP_SUMM_PKG.
The solution is to create a synonym apps.ra_addresses_all for ar.ra_addresses_all;
and verify you dont have any invalid object with name PA_PWP_SUMM_PKG

 

SQL> create synonym apps.ra_addresses_all for ar.ra_addresses_all;

 

Synonym created. 

 

SQL> commit; 

 

Commit complete. 

 

SQL> alter package apps.PA_PWP_SUMM_PKG compile body; 

 

Package body altered. 

 

SQL> 

 

SQL> select owner,object_name,object_type from dba_objects where status='INVALID'; 

 

no rows selected 

 

SQL> 

 

 

 

Rules for commenting:

  • Only comment to articles on this page - each page have it's own comment box.
  • Comments/questions irrelevant to the content of this page will be removed.
  • Non-valid email adresses will be treated as SPAM and will be deleted by htmlcommentbox, without me even knowing about it. I have no control over what adresses gets detected by htmlcommentbox as invalid.

 

 
HTML Comment Box is loading comments...