Wednesday, September 24, 2014

Enabling Direct Login to forms in E-Business Suite

Enabling Direct Login to forms in E-Business Suite 11i

The usual url for loggin in to Oracle Application is 
http://<server name>:<port>/
which most of the times gets directed to 
http://<server name>:<port>/OA_HTML/AppsLocalLogin.jsp

But for some reason or for troubleshooting purpose we may need to login directly to forms.
Below are the urls for directly connecting forms.

For 11i :-  
Socket mode:- http://<server name>:<port>/dev60cgi/f60cgi
Servlet mode:- http://<server name>:<port>/servlet/f60

For R12 :- 
Servlet mode:- http://<server name>:<port>/forms/frmservlet
Socket mode:- http://<server name>:<port>/OA_HTML/frmservlet

You can see the forms opening but after entering login details you may not be able to login and find the error as "APP-FND-01542: This application server is not authorized to access this database"

The reason for this is, direct forms login is disabled. To check and change that check the value for context variable "s_appserverid_authentication". You can make it ON or OFF to change the security level. SECURE doesn't allow you to login directly and gives the message as above

Enabling f60cgi direct login

It is possible to login however this method should only be used when debugging problems.

1. Backup and open $APPL_TOP/admin/<SID>_<hostname>.xml context file
2. Update the context variable:
    s_appserverid_authentication
    By default in 11.5.10, this is set to SECURE.
    In previous 11i versions, this was set to OFF. For debug purposes, you can use ON or OFF.
     Modes:
    - ON : Partial
    - SECURE : activates full server security (SECURE mode)
    - OFF : deactivates server security

3. Run Autoconfig to instantiate the change.
    You should now be able to access forms directly again using the f60cgi call.
4. After you have finished your Forms debugging, please reset
    s_appserverid_authentication to SECURE and re-run Autoconfig


Alternative option

Running Autoconfig is the preferred method of updating
s_appserverid_authentication.
If you are unable to run Autoconfig during troubleshooting, you can run the the following commands instead
from $FND_TOP/secure directory:

Disable:
java oracle.apps.fnd.security.AdminAppServer apps/apps \
AUTHENTICATION OFF DBC=host_visdemo1.dbc

Enable:
To activate basic server security, from the command line, enter:
jre oracle.apps.fnd.security.AdminAppServer apps/apps \
AUTHENTICATION ON DBC=<dbc file path>
To activate full server security (SECURE mode), from the command line, enter:
jre oracle.apps.fnd.security.AdminAppServer apps/apps \
AUTHENTICATION SECURE DBC=<dbc file path>

Check the status:
java oracle.apps.fnd.security.AdminAppServer apps/apps \
STATUS DBC=host_visdemo1.dbc


No comments:

Post a Comment