Saturday 23 August 2014

Direct Login to forms in eBusiness Suite


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.

Below are possible modes.
ON     :- Partial
SECURE :- activates full server security (SECURE mode)
OFF    :- deactivates server security



à COMMAND LINE OFF AUTHENTICATION EXECUTE

1.      java oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION OFF DBC=PROD.dbc


3.     ./adautocfg.sh

4.     Enter Form User and Password in My Case :- SYSADMIN.    NOTE:- Not getting error as "APP-FND-01542: This application server is not authorized to access this database" And Open the form

5.     java oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION ON DBC=PROD.dbc



For more details and alternative options refer metalink doc:- 293609.1