Oracle Database Administration, Oracle Developer Suite, Oracle JDeveloper, Oracle BI Publisher, Oracle Forms/Reports,Oracle SQL Developer

How To Access Forms Directly In Oracle Applications R12

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 would pop out:
APP-FND-01542: This Applications Server is not authorized to access this database.


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 should only be used for diagnostic and troubleshooting purposes.

Solution:
1. Edit $CONTEXT_FILE which is located in $INST_TOP/appl/admin

2. Change

SECURE
to
OFF

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.

Reference: Doc ID 552301.1