TriniDBA

Unable to compile WSH_FTE_TP_INTEGRATION, WSH_TRIP_STOPS_GRP Package Bodies

Problem:

While running patch 9239090 (R12.1.3 RUP) on Windows, the following Oracle Forms objects did not generate successfully:

wsh     forms/US        WSHQSSUI.fmx
wsh     forms/US        WSHSTREF.fmx
wsh     forms/US        WSHFSTRX.fmx

To resolve this, the invalid WSH packages were identified and compiled. However, while compiling the invalid WSH package bodies, compilation errors resulted.

Solution: Flush the shared pool before compiling the package bodies.

The following errors occurred while compiling the package bodies:

SQL> select owner, object_name, object_type from dba_objects where status = 'INVALID'
and object_name like 'WSH%';

OWNER  OBJECT_NAME             OBJECT_TYPE
-----  ----------------------  --------------------------------------------
APPS   WSH_FTE_TP_INTEGRATION  PACKAGE BODY
APPS   WSH_TRIP_STOPS_GRP      PACKAGE BODY

SQL> alter package body WSH_FTE_TP_INTEGRATION compile;
alter package body WSH_FTE_TP_INTEGRATION compile
                   *
ERROR at line 1:
ORA-00922: missing or invalid option

SQL> alter package WSH_FTE_TP_INTEGRATION compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY WSH_FTE_TP_INTEGRATION:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      PLS-00907: cannot load library unit APPS.WSH_TRIP_STOPS_PVT
         (referenced by APPS.WSH_FTE_TP_INTEGRATION)

SQL> alter package  WSH_TRIP_STOPS_GRP compile body;

SQL> show errors
Errors for PACKAGE BODY WSH_TRIP_STOPS_GRP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      PLS-00907: cannot load library unit APPS.WSH_TRIP_STOPS_PVT
         (referenced by APPS.WSH_FTE_TP_INTEGRATION)

0/0      PLS-00907: cannot load library unit APPS.WSH_TRIP_STOPS_PVT
         (referenced by APPS.WSH_FTE_TP_INTEGRATION)

1395/12  PL/SQL: Statement ignored
3042/12  PL/SQL: Statement ignored

Note that the scripts that contain the packages are located in cd $WSH_TOP/patch/115/sql

Header information can be obtained using the following command:

strings -a WSHSTTHB.pls|grep  ‘$Header’

G:oracleVIS12appsapps_stapplwsh12.0.0patch115sql>sqlplus apps/apps @ WSHSTTHB.pls

SQL*Plus: Release 10.1.0.5.0 - Production on Sat Sep 17 11:46:11 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Package body created.

Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

G:oracleVIS12appsapps_stapplwsh12.0.0patch115sql>

Log on to SQL*Plus and flush the shared pool before compiling the package:

SQL> alter system flush shared_pool;

System altered.

SQL> alter package WSH_FTE_TP_INTEGRATION compile;

Package altered.

SQL> alter package WSH_FTE_TP_INTEGRATION compile body;

Package body altered.

SQL> show errors
No errors.
SQL>

SQL> alter package  WSH_TRIP_STOPS_GRP compile body;

Package body altered.

SQL> show errors
No errors.
SQL>

Reference:

https://forums.oracle.com/forums/thread.jspa?threadID=964082