Allow R12 to log on directly from Form

Applies:

Oracle Applications technology stack-version: 12.0 to 12.1
Information in this document applies to any platform.

Goal

By default in Oracle Applications R12, users are not able to access forms directly via the following URL:
Http://hostname.domain: Port/Forms/frmservlet
The following error wocould pop out:

APP-FND-01542: This applications server is not authorized to access this database.

The goal of this document is to allow users access to the Oracle Applications R12 directly via forms especially in cases where access to the following URL is not available:
Http://hostname.domain: Port/oa_html/appslogin

Note: accessing forms directly is not supported and shoshould only be used for diagnostic and troubleshooting purposes.

Solution

1. Edit $ context_file which is located in $ inst_top/appl/admin
2. Change
<Appserverid_authentication oa_var = "s_appserverid_authentication"> secure </appserverid_authentication>
To
<Appserverid_authentication oa_var = "s_appserverid_authentication"> off </appserverid_authentication>

Application Server Security Authentication can take one of the following values {On, off, secure }.
Off-server security is not checked. Any application server machine can access the database.
On-some level of trust is required to access the database. Either the application server is registered with the database or the module and version ID are known to be trusted.
Secure-full trust is required for access to the database. Only registered application server machines and trusted code modules may connect.

3. run $ inst_top/admin/scripts/adautocfg. Sh to instantiate the changes
4. Users are now able to access forms directly.

Note:
Remember to set the Application Server Security Authentication back to secure by setsetting the value of s_appserverid_authentication to secure and running AutoConfig.