APP-WSH-231210 An unexpected Error Occurred for Line .. The Error is ORA-04062 signature of package

in Order Management ( Responsibility Order Management Super User, Vision Operations (USA) : Navigation : Shipping >> Transaction) trainees faced error 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

Looking at error message it is clear that fix is to compile invalid database objects andrecompile form. Fix is well explained in My Oracle Support Note # 1315451.1 Shipping Transactions Form Errors: APP-WSH-231210, ORA-04062 which is to

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

 

What this note doesn’t cover is how to compile forms and if you are not familiar with how to compile forms in EBS R12 then compiling forms is task in itself.

.

File with fmb extension is source form file where as file withfmx extension iscompiled form . fmb’s in Oracle E-Business Suite (11i or R12)are stored in AU_TOP/forms/<US> directory where arefmx’s are stored in<PRODUCT_TOP>/forms/<US> directory (for example compiled forms related to WSH products should be in $WSH_TOP/forms/<US> directory )

 

To compile form in R12 (to convert fmb to fmx)

• Set environment file on apps tier R12_BASE/ apps/ apps_st/ appl/ APPS<sid>_<hostname>.env
• export FORMS_PATH and add AU_TOP/forms/US in FORMS_PATH like
  export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US
• Change to form compilation executable directory (10.1.2 Oracle Home in R12)
  cd $ORACLE_HOME/bin
• Compile three forms using frmcmp_batch.sh|bat as./frmcmp_batch.sh module=$AU_TOP/forms/US/WSHSTREF.fmb userid=APPS/apps output_file=$WSH_TOP/forms/US/WSHSTREF.fmx module_type=form
• Repeat this for WSHQSSUI.fmb and WSHFSTRX.fmb

Note:Ensure that timestamp changes for above three fmx in $WSH_TOP/forms/US/

Note: If you get error like “ORA-12154: TNS:could not resolve the connect identifier specified” during forms compilation, check My Oracle Support Note 431324.1

Note: If you get error like “Compiling package body INVENTORY_CONTROLS…Compilation error on package body INVENTORY_CONTROLS:PL/SQL ERROR 49 at line 867, column 5 bad bind variable ‘parameter.wms_installed‘” make sure that FORMS_PATH includes $AU_TOP/forms/US

 

From: http://onlineappsdba.com/index.php/2012/05/08/compiling-forms-in-oracle-apps-r12-app-wsh-231210-ora-04062-wsh_delivery_details_inv/