11i Forms compilation errors

ByMohammed Sameer

Forms compilation errors parameter

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/resour

Similar Posts

Oracle Apps Patch info Scripts

ByMohammed Sameer

/* Query to find out if any patch except localisation patch is applied or not, if applied, that what all drivers it contain and time of it’s application*/ select A.APPLIED_PATCH_ID, A.PATCH_NAME, A.PATCH_TYPE, B.PATCH_DRVIER_ID, B.DRIVER_FILE_NAME, B.ORIG_PATCH_NAME, B.CREATION_DATE, B.PLATFORM, B.SOURCE_CODE, B.CREATIONG_DATE, B.FILE_SIZE, B.MERGED_DRIVER_FLAG, B.MERGE_DATE from AD_APPLIED_PATCHES A, AD_PATCH_DRIVERS B where A.APPLIED_PATCH_ID = B.APPLIED_PATCH_ID and A.PATCH_NAME = ‘<patch…

Chaning GUEST Password

ByMohammed Sameer

1.Change the GUEST user statement to the following in $CONFIG_FILE <oa_user type=”GUEST”> <username oa_var=”s_guest_user”>GUEST</username> <password oa_var=”s_guest_pass”>GUEST</password> Use upper case letters. 3. Run AP Tier Autoconfig. 4. Verify the $FND_TOP/secure/<host>.dbc file the entry for GUEST_USER_PWD is set in the same letter case.

How To License A New Product in Oracle Applications

ByMohammed Sameer

How To License A New Product in Oracle Applications 1. After purchasing a license for an Application Product/Module, the first thing is to use license manager to record that the product/module is now licensed. License manager can be run 2 ways: a. log in through Oracle Application Manager (OAM) and select Site Map -> Administration…

concurrent manager has timed out waiting for the Output Post-processor to finish this request

ByMohammed Sameer

The Following error had occured while running the xml report “concurrent manager has timed out waiting for the Output Post-processor to finish this request” Cause: Once the Output Post Processor picks up the request, the XML Publisher engine is invoked to generate the final output file. The time that this takes will depends on various…

IP Restriction for Oracle EBS

ByMohammed Sameer

1. Oracle TNS Listener Security ENABLE VALID NODE CHECKING Valid Node Checking allows or denies access from specified IP addresses to Oracle services. To enable Valid Node Checking, set the following parameters in $TNS_ADMIN/sqlnet.ora tcp.validnode_checking = YES tcp.invited_nodes = (X.X.X.X, hostname,) tcp.excluded_nodes = (hostname, X.X.X.X …) The first parameter turns on Valid Node Checking. The…

Leave a Reply

Your email address will not be published. Required fields are marked *