Monday, November 18, 2019

How To Access Forms Directly In Oracle Applications R12 (Doc ID 552301.1)

APPLIES TO:

Oracle E-Business Suite Technology Stack - Version 12.0 to 12.1.3 [Release 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 would 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 should 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.

No comments:

Post a Comment

Database Options/Management Packs Usage Reporting for Oracle Databases 11.2 and later (Doc ID 1317265.1)

  Database Options/Management Packs Usage Report You can determine whether an option is currently in use in a database by running options_pa...