ORA-04062 signature of package APPS.WSH_DELIVERY_DETAILS_INV has been changes

Error message:
=========== 

APP-WSH-231210 An unexpected Error Occurred for Line .. The Error is ORA-04062 signature of package APPS.WSH_DELIVERY_DETAILS_INV has been changes

EBS R12.1.1
DB 11.1.0.7.0

Scenario when the error occurs :
=======================

while checking transaction status in Order Management
Responsibility - Order Management Super User, Vision Operations (USA)
Navigation : Shipping >> Transaction

Reference :

WSHFSTRX: ORA-04062: Signature of package APPS.WSH_DELIVERY_DETAILS_INV [ID 1303005.1]

Solution :
=======

a) Apply patch 8294645 (For EBS 12.1)
b) Drop package APPS.WSH_DELIVERY_DETAILS_INV
c) Create package spec and body by running  $WSH_TOP/patch/115/sql/@WSHDDICS.pls & @WSHDDICB.pls
d) Finally compile forms WSHSTREF.fmb, WSHFSTRX.fmb, WSHQSSUI.fmb


Note :

We have moved the fmb and the pls manually instead of applying this patch as we face some problem in applying it in other instance :


Steps to follow :

1.Download the patch and copy the pls file from the patch (8294645) to WSH_TOP/patch/115/sql by taking the existing as backup
2. Copy the fmb file from patch (8294645) to AU_TOP/forms/US by taking the existing as backup
3. Now drop the package APPS.WSH_DELIVERY_DETAILS_INV
4. Create package spec and body by running  $WSH_TOP/patch/115/sql/@WSHDDICS.pls & @WSHDDICB.pls as apps user
5. compile the fmb and move the fmx to WSH_TOP/forms/US
6. Retest the issue

[applmgr@sysr12 sql]$ pwd
/R12/apps/apps_st/appl/wsh/12.0.0/patch/115/sql

[applmgr@sysr12 sql]$ mv WSHDDICS.pls WSHDDICS.pls_bkp
[applmgr@sysr12 sql]$ mv WSHDDICB.pls WSHDDICB.pls_bkp

Now copy those three files from the patch directory

Now Drop the package APPS.WSH_DELIVERY_DETAILS_INV

[applmgr@sysr12 sql]$ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jan 10 13:13:03 2013

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

SQL> @WSHDDICS.pls

Package created.

Commit complete.

SQL> @WSHDDICB.pls

Package body created.

Commit complete.

Now copy the fmb from the patch location to AU_TOP/forms/US

/R12/apps/apps_st/appl/au/12.0.0/forms/US

Now compile the forms

frmcmp_batch module=/R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHSTREF.fmb userid=apps/apps output_file=/R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHSTREF.fmx module_type=form compile_all=special

frmcmp_batch module=/R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHQSSUI.fmb userid=apps/apps output_file=/R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHQSSUI.fmx module_type=form compile_all=special

frmcmp_batch module=/R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHFSTRX.fmb userid=apps/apps output_file=/R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHFSTRX.fmx module_type=form compile_all=special

[applmgr@sysr12 US]$mv  /R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHSTREF.fmx $WSH_TOP/forms/US/WSHSTREF.fmx
[applmgr@sysr12 US]$mv  /R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHQSSUI.fmx $WSH_TOP/forms/US/WSHQSSUI.fmx
[applmgr@sysr12 US]$mv  /R12/apps/apps_st/appl/au/12.0.0/forms/US/WSHFSTRX.fmx $WSH_TOP/forms/US/WSHFSTRX.fmx

/R12/apps/apps_st/appl/au/12.0.0/forms/US
[applmgr@sysr12 US]$ mv WSHSTREF.fmx /R12/apps/apps_st/appl/wsh/12.0.0/forms/US/WSHSTREF.fmx
[applmgr@sysr12 US]$ mv WSHQSSUI.fmx /R12/apps/apps_st/appl/wsh/12.0.0/forms/US/WSHQSSUI.fmx
[applmgr@sysr12 US]$ mv WSHFSTRX.fmx /R12/apps/apps_st/appl/wsh/12.0.0/forms/US/WSHFSTRX.fmx

Now bouce the opmn after clearing the Persistance