What is the process to set SF_TOP in Oracle Applications 11i
3967
Summary
3967
If SF_TOP is not being set for the Oracle Forms Server for the MarkView Installer, then follow these steps:
- Log in to a UNIX shell as applmgr.
- Determine whether the Oracle Forms Server is running in servlet mode or in socket mode.
To do so,issue the following grep command :
$ grep s_forms_servlet_serverurl $APPL_TOP/admin/SID.xml
where SID is the SID or SID_hostname.
If Oracle Forms Server is running in servlet mode, the preceding grep command will return:
<server_url oa_var="s_forms_servlet_serverurl"> /forms/formservlet </server_url>
If Oracle Forms Server is running in socket mode, the grep command will return:
<server_url oa_var="s_forms_servlet_serverurl"/>
Now proceed to the "Servlet Mode" or "Socket Mode" section.
Servlet Mode
If Oracle Forms Server is running in servlet mode, follow these steps:
- Edit the following file:
$IAS_ORACLE_HOME/Apache/Jserv/etc/formservlet.ini
Add the following three lines to this file:
# Begin customizations
SF_TOP=appl_top/sf/11.5.0
# End customizations
where appl_topis the pathname of the top-level Oracle Applications directory. - Log out of Oracle Forms.
- Restart Apache.
- Log in again to Oracle Forms.
- Proceed to the "Testing" section, a little later in this Answer.
Socket Mode
If Oracle Forms Server is running in socket mode, follow these steps:
- Edit the following file:
$APPL_TOP/admin/adovars.env
Add the following lines to this file to the customizations section (somewhere between "# Begin customizations" and "# End customizations"
SF_TOP=$APPL_TOP/sf/11.5.0
export SF_TOP - Log out of the shell.
- Log in to a new shell as applmgr.
- Determine whether SF_TOP is set and exported by entering the following shell command:
$ print SQL*Flow_TOP
# The command should return the pathname you set in Step 1. - Restart the Oracle Forms server by running the following script: $OAD_TOP/admin/scripts/SID /adfrmctl.sh
- Proceed to the "Testing" section.
Testing
You should now check the value of SF_TOP within Oracle Forms. To do so, follow these steps:
- Log in to Oracle Forms.
- Select Help->Diagnostics->Examine
- When prompted, enter the apps password.
- In Block, press CTRL-L.
- In the resulting LOV, choose $ENVIRONMENT$.
- In Field, type SF_TOP and press the Tab key.?
Note: Do not press CTRL-L. If you do press CTRL-L, SF_TOP will not appear in the LOV.
Oracle Forms should now display the pathname of SF_TOP. If it does not, please recheck your steps.
Keywords: SF_TOP, servlet, socket, APPL_TOP, SFXINWKB