Oracle E-Business Suite: Forms Compilation Error - Form Derleme Hatası

In R12.1.3

Recently we have encountered errors such as these:


Compiling KEY-NXTBLK trigger on QUERY_FIND data block...
Compilation error on KEY-NXTBLK trigger on QUERY_FIND data block:
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 3, column 1
bad bind variable 'parameter.G_query_find'

It turned out that FORMS60_PATH was not set correctly. Whenever forms are compiled FORMS60_PATH is set to:

FORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/US:$AU_TOP/resource

In context file it was set as:

$AU_TOP/resource:$AU_TOP/resource/stub

After correcting this and compiling manually it worked. To make this permanent change the s_f60path to include $AU_TOP/forms/US:$AU_TOP/resource

In R12.2.4 or in R12.2 we should be adding the following to the $FORMS_PATH variable in the context file which is in the $APPL_TOP/$SID_$HOSTNAME.env path  

$AU_TOP/forms/US:$AU_TOP/forms/TR 

After that forms can be compiled with the following command.

E.g.:

frmcmp_batch AKDFLOWB.fmb   apps/apps output_file=$AK_TOP/forms/TR/AKDFLOWB.fmx compile_all=special;


Referanslar:

Forms Compilation hatası
http://oracleappstechnology.blogspot.com.tr/2009/03/forms-compilation-errors.html