Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Wednesday, March 25, 2009

Forms compilation errors parameter.G_query_find

Recently all custom forms compilation failed with errors like these:

FRM-18108: Failed to load the following objects.

Source Module:APPSTAND
Source Object: STANDARD_PC_AND_VA
Source Module:APPSTAND
Source Object: STANDARD_TOOLBAR
Source Module:APPSTAND
Source Object: STANDARD_CALENDAR
Compiling package specification APP_CUSTOM...
No compilation errors.

or

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

2 comments:

Galarza said...

thanks

Anonymous said...

Hi i am facing the same problem

FRM-18108: Failed to load the following objects.

Source Module:APPSTAND.fmb
Source Object: STANDARD_FOLDER
Source Module:APPSTAND
Source Object: STANDARD_PC_AND_VA
Source Module:APPSTAND
Source Object: STANDARD_TOOLBAR
Source Module:APPSTAND
Source Object: STANDARD_CALENDAR
Compiling package specification APP_CUSTOM...
No compilation errors.

Compiling package specification XXFIN_GBL_CREDITMEMO_PKS...
No compilation errors.

Compiling package specification XXFIN_GBL_QUERY_PKS...
No compilation errors.

Compiling package specification XXFIN_GBL_MAIN_PKS...
No compilation errors.

Compiling package body APP_CUSTOM...
No compilation errors.

Compiling package body XXFIN_GBL_CREDITMEMO_PKS...
No compilation errors.

Compiling package body XXFIN_GBL_QUERY_PKS...
Compilation error on package body XXFIN_GBL_QUERY_PKS:
PL/SQL ERROR 49 at line 102, column 13
bad bind variable 'parameter.g_query_find'
PL/SQL ERROR 49 at line 102, column 13
bad bind variable 'parameter.g_query_find'
PL/SQL ERROR 49 at line 104, column 13
bad bind variable 'parameter.g_query_find'

Compiling package body XXFIN_GBL_MAIN_PKS...
Compilation error on package body XXFIN_GBL_MAIN_PKS:
PL/SQL ERROR 49 at line 124, column 12
bad bind variable 'parameter.g_query_find'
PL/SQL ERROR 49 at line 124, column 12
bad bind variable 'parameter.g_query_find'
PL/SQL ERROR 49 at line 186, column 12
bad bind variable 'parameter.g_query_find'



HOW TO SET THE FORMS PATH :

When i do echo $FORMS_PATH i get the path as
[applmgr@usmlrh212 US]$ echo $FORMS_PATH
/rh212/u02/applmgr/utyeb03/apps/apps_st/appl/au/12.0.0/resource:/rh212/u02/applmgr/utyeb03/apps/apps_st/appl/au/12.0.0/resource/stub

is it corect ? if not how to set it?

Its very urgent please reply soon...