WSH Forms Compilation Error In Adadmin

Oracle Shipping Execution - Version 11.5.10.2 and later
Information in this document applies to any platform.
Checked for relevance on 05-Mar-2012


Goal


The following Oracle Forms objects did not generate successfully:

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

Compiling package body DLVB_EVENT...
Compilation error on package body DLVB_EVENT:
PL/SQL ERROR 907 at line 1, column 1
cannot load library unit APPS.WSH_DELIVERY_DETAILS_PKG (referenced by APPS.WSH_
DELIVERY_DETAILS_GRP)
PL/SQL ERROR 0 at line 474, column 5
Statement ignored

Compiling package body TRIP...
Compilation error on package body TRIP:
PL/SQL ERROR 907 at line 1, column 1
cannot load library unit APPS.WSH_TRIPS_PVT (referenced by APPS.WSH_TRIPS_GRP)
PL/SQL ERROR 0 at line 541, column 5
Statement ignored



Fix


Go to $WSH_TOP/patch/115/sql and execute the following :

1. sqlplus apps/apps@db @WSHDDTHS.pls
2. sqlplus apps/apps@db @WSHDDTHB.pls

3. sqlplus apps/apps@db @WSHTRTHS.pls
4. sqlplus apps/apps@db @WSHTRTHB.pls

Now Go to $WSH_TOP/forms/US and compile the files using the command f60genm.

f60genm

@dbsid compile_all=YES