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

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

3 comments
Matt says May 16, 2012

Oracle provide adadmin for regenerating apps forms, why not use that? If you login as the applications owner all environment variables should be set if your .profile calls the .env file also.

Food for thought and saves lots of typing.

Reply
Ridhi Sundar says November 20, 2012

@Atul

I am getting below error while compiling forms.

“Compilation errors have occurred.
Form not created”

Where can I find the details of error? Which package could not be compiled? Can you help me solving this problem?

Reply
HV says August 11, 2015

or you can use adadmin utility to compile specific forms

Reply
Add Your Reply

Not found