Forms facts



Last updated on October 18th, 2015 at 06:54 pm

In this post, I have noted down all the important Forms facts

1. Forms run time trace

‘http://:/dev60cgi/f60cgi?play=&record=
collect&log=/tmp/form1.frd’

2.

When-logon-Change error comes
1 Complie invalids
2. Compile all the pll and bounce the forms server

3 Jisniter Dowload URL

http://:/jinitiator/oajinit.exe

4.User-exit ere third generation languages which you can cretae and call during forms
Application include variaous USER+EXIT

5. Core librraies
APPSTAND.fmb
APPCORE.pll
LOBE.pll
JE.pll
JA.pll
JL.pll
FNDSQF.pll
VERT.pll
APPDAYPK.pll
CUSTOm.pll

6.f60webmx is the core executable used in forms run time.Sometimes forms may not be opening.Relinking may help
adrelink.sh force=y ranlib=y “FND f60webmx”

7 Form listener mode is used in 11i.Serlvet mode is also avialable,,you will need to set various files to activate that.

8.The About Oracle Applications Window
The About Oracle Applications Window displays a large amount of useful information to assist with problem diagnosis. From the menu select Help -> About Oracle Applications. In Release 11i, the information provided has been greatly enhanced.

Oracle Applications
Copyright © 1986-1999 Oracle Corporation,
Redwood Shores, California.
All Rights Reserved.

Login
Site : XXXXX
Application : System Administration
Responsibility : System Administrator
Security Group : Standard
User Name : VISION

Database Server
RDBMS : 9.2.0.6
Oracle Applications : 11.5.10
Machine : aaaaa
User : APPS
Oracle SID : XXXXX
System Date : 09/05/2007 06:46:58
Database process : 19812
Session SID : 2133
SERIAL# : 1462
AUDSID : 94824382

Forms Server
Oracle Forms Version : 6.XXX
Application Object Library : 11.5.0
Machine : XXXXXXX

Forms Server Environment Variables
AU_TOP : /xx/xx/xx
FDBDMCHK : OFF
FDFGCXDBG : [Unset]
FDSQLCHK : [Unset]
FDUDEBUG : [Unset]
FNDNAM : apps
FND_INTERACTION_MODE : BLOCKING
FND_TOP : xx/xx/xx
FORMS60_APPSLIBS : FNDSQF APPCORE APPDAYPK APPFLDR ARXCOVER HR_GEN HR_SPEC
FORMS60_CATCHTERM : [Unset]
FORMS60_ERROR_DATETIME_FORMAT : [Unset]
FORMS60_ERROR_DATE_FORMAT : [Unset]
FORMS60_FORCE_MENU_MNEMONICS : [Unset]
FORMS60_MAPPING : http://XXXXXX/OA_TMP
FORMS60_MMAP : [Unset]
FORMS60_OUTPUT : /XXXX/common/XXXX11510/tmp
FORMS60_OUTPUT_DATETIME_FORMAT : [Unset]
FORMS60_OUTPUT_DATE_FORMAT : [Unset]
FORMS60_PATH :/XXXX/au/XXXX11510/resource:/XXXX/fnd/XXXX11510/resource:/XXXX/au/XXXX11510/forms/US:/XXXX/fnd/XXXX11510/forms/US
FORMS60_RESOURCE : /xxx/8.0.6/forms60/admin/resource/US
FORMS60_TIMEOUT : 5
FORMS60_USER_DATETIME_FORMAT : MM/DD/RRRR HH24:MI:SS
FORMS60_USER_DATE_FORMAT : MM/DD/RRRR
FORMS60_USE_CBO : [Unset]
GWYUID : applsyspub/pub
NLS_DATE_FORMAT : DD-MON-RR
NLS_DATE_LANGUAGE : [Unset]
NLS_LANG : American_America.UTF8
NLS_NUMERIC_CHARACTERS : [Unset]
ORACLE_HOME : /XXXX/8.0.6
ORACLE_PATH : [Unset]
ORA_NLS_CHARSET_CONVERSION : [Unset]
TNS_ADMIN : [Unset]
TWO_TASK : XXXX11510

Current Form

Form Application : Application Object Library
Form Name : FNDSCAUS
Form Path : /XXXX/fnd/XXXX11510/forms/US/FNDSCAUS.fmx
Form Version : 11.5.XX
Form Last Modified : $Date: 2001/07/05 07:01 $

Forms

APPSTAND : 11.5.22
FNDSCAUS : 11.5.21
FNDSCSGN : 11.5.872

Form Menus
FNDMENU : 11.5.322

Forms PL/SQL
APPCORE : 11.5.567
CUSTOM : 11.5.4
FNDSQF : 11.5.23
GHR : 11.5.25
GLOBE : 11.5.43
OPM : 11.5.0
PQH_GEN : 11.5.5
PSAC : 11.5.3
VERT : 11.5.6

Other useful features are the Examine window, which allows you to check the current block, item and value. From the menu, select Help -> Examine. The Examine window can also be used to view other items, such as the current value of profiles and environment variables.
The Display Error option can provide the SQL- and ORA- errors when a query on a base table block or LOV fails.


Leave a Reply