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

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)
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

[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


[applmgr@sysr12 sql]$ sqlplus apps/******

SQL*Plus: Release – Sachin on Sun Dec 28 01:06:03 2014

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

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


Package created.

Commit complete.


Package body created.

Commit complete.

Now copy the fmb from the patch location to AU_TOP/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

[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