Compiling Forms in Oracle Apps R12 : APP-WSH-231210 ORA-04062 WSH_DELIVERY_DETAILS_INV
.
Last week for our Order Management training while checking transaction status 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 and recompile 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 with fmx extension is compiled form . fmb’s in Oracle E-Business Suite (11i or R12) are stored in AU_TOP/forms/<US> directory where are fmx’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
References/Related
- R12.1: Shipping Transactions Form Errors: APP-WSH-231210, ORA-04062 [ID 1315451.1]
- 1085928.1 – R12: How to Compile a Form in Release 12
- 431324.1 R12: Manual Forms compilation In R12 fails With: FRM-91500: Unable to start/complete the build