Skip to main content
Kofax

What is the process to set SF_TOP in Oracle Applications 11i

Summary

3967

If SF_TOP is not being set for the Oracle Forms Server for the MarkView Installer, then follow these steps:

  1. Log in to a UNIX shell as applmgr.
  2. 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:

  1. 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.
  2. Log out of Oracle Forms.
  3. Restart Apache.
  4. Log in again to Oracle Forms.
  5. 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:

  1. 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
  2. Log out of the shell.
  3. Log in to a new shell as applmgr.
  4. 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.
  5. Restart the Oracle Forms server by running the following script: $OAD_TOP/admin/scripts/SID /adfrmctl.sh
  6. Proceed to the "Testing" section.

Testing

You should now check the value of SF_TOP within Oracle Forms. To do so, follow these steps:

  1. Log in to Oracle Forms.
  2. Select Help->Diagnostics->Examine
  3. When prompted, enter the apps password.
  4. In Block, press CTRL-L.
  5. In the resulting LOV, choose $ENVIRONMENT$.
  6. 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

  • Was this article helpful?