Multiple Session in oracle Application

Open multiple forms in an Oracle apps session

A unique session id is created at each sign on - so upon signing into the application, it will create a session_id.  This session_id is passed in the header between screens.

If at times you see that the order line is not available to be updated, then you will encounter a locking situation which is an inherent RDBMS behavior.

Internally, we are able to pull up an order in 2 sessions, open several Sales Order Forms and query the same order... but if we update one instance - (not saved yet) and go to another instance of the form and try to update it, it will error.  

It becomes quite irritating when I open a new form and the previously opened form is closed automatically by Oracle. This can be fixed by unchecking the box “Close Other Forms” from the Tools menu. Once I have seen this option is checked and disabled. What do I do now?

The parameter FND_SINGLE_FORM_INSTANCE is set to 'Y' for the form.
So when the form is called, this parameter is read and hence only one instance 
of the form is allowed.

SOLUTION

(1) Responsibility : Application Developer 
(2) Navigate to Application --> Function
(3) Query for Function corresponding to the form
(4) Click on "Form" tab
(5) Find the parameter with the value FND_SINGLE_FORM_INSTANCE='Y'
(6) Remove this parameter and save

You can see that the check box “Close Other Forms” is disabled. Oracle allows opening multiple forms when this checkbox is unchecked. Since the checkbox is checked and disabled we have no option but open only 1 form at a time. We need to enable the checkbox so that we can open multiple forms simultaneously. How do we do it?

Go through the following steps:

Responsibility: System Administrator

Navigation: Security > Responsibility > Define

Query for the responsibility, UAE HRMS Manager.

On this form you need to exclude a function. Enter the details as given below,

Type: Function

Name: Navigator: Disable Multiform

Save the form

Now go back to UAE HRMS Manager responsibility.

You can now check or un-check the box to open multiple windows simultaneously.