Anil's Blog is Best Viewed on GOOGLE CHROME

Sunday, June 26, 2011

Restricted Access - Oracle Apps

Restricted Access means to provide application access to certain business user during downtime. We have achieved this functionality by customizing the AppsLocalLogin.jsp (Login page).

How it works 

After the restricted access is enabled then specific user will get a different or changed URL to login into application. However other users are not aware of this URL and when they will try to login into application then they will get a downtime message like:  

System is down for patching activity and will not be available this weekend.


Here is the list of steps which we need to perform for enabling restricted access on Production environment.

1. Prepare a DownTime.html file, with necessary down time messages. This html page is to be displayed to the end user during down time. Put this file under $OA_HTML top.

2. Take backup of $OA_HTML/AppsLocalLogin.jsp file.

3. Edit the AppsLocalLogin.jsp and add the below code:
String checkMode = request.getParameter("ReleaseCode");
                 String theURL = "/OA_HTML/DownTime.html";

Above code is checking for parameter ReleaseCode that is passed through URL and if it is null then it will redirect to DownTime.html page.

4. For restricted access, we need to login with below URL to have production access:

5. To restrict the form server access i.e http://host.domain:port/dev60cgi/f60cgi we need to perform below steps:

   1. Edit the XML system context file which, after setting your environment, will be referenced by the environment variable $CONTEXT_FILE
   2. Find the context variable called s_appserverid_authentication
   3. This will currently be set to "OFF". Change the value to " SECURE " and save the file changes.
   4. Run AutoConfig. The AutoConfig script is run as follows:
      11i: $COMMON_TOP/admin/scripts/[context name]

6. Bounce Apache.

To re enable normal access to application (Both forms and SSWA).

1. Restore the original AppsLocalLogin file.
2. Edit the XML system context file again and change the context variable “s_appserverid_authentication” to “OFF”
3. Run AutoConfig.
4. Bounce Apache.

There is one more way to achieve this functionality. Please refer to MOS Doc Id: 605538.1. Subject 11i - R12 - How to Lock Users Out Of E-Business Suite and Allow Specific Users

Also If you desire this functionality please ask oracle to add your request to Enhancement Request Bug 7356865. 


Thursday, June 16, 2011

Error: JSP files must reside in the server root directory or a subdirectory beneath it

We got this error when we we put the jsp in wrong directory. Ideally it should be under the path which is set in  HTML Root Directory under project properties in Jdeveloper.

For Jdeveloper 9i the path where we set the Html Root Directory is as follow:

Open project properties à  Common à Input Paths

For Jdev11G it is :  Open project properties Project à  Source Paths à Web Application. I have not check for Jdev10G but I think the path would be same.


Bypassing Oracle Home Page

A new feature is introduced after ATG RUP7 patch. Although it's a small thing however sometimes it really help us hence thought of sharing to all of us.

The Preferences Page includes the ability to set a default start page other than the E-Business Suite Home Page, based on responsibility, and the ability to set separate session and default language.

Hence when a specific user will login into Oracle Applications then the page will redirect to that specific page which was selected through Preferences Link.