Example Analysis of other form Modification with EBS tool option off in Oracle

This article mainly introduces the Oracle EBS tool option to close other form modification example analysis, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian with you to understand.

Tools in Oracle EBS-close other forms if checked, when the user opens a Form, the user will close other Form to ensure that only one Form exists.

If you want to turn on this option, you can use the following two ways

1) each responsibility is set separately

Add menu exclusion: Menu Exclusions

Function: Fuction

Name: Navigator: Disable Multiform

And vice versa.

2) permanently open / close via sql

Provides a workaround for permanently modifying this option through scripting:

SELECT preference_value FROM applsys.fnd_user_preferences WHERE user_name = 'OPERATIONS' AND preference_name =' NEW_WINDOW_FLAG'

The value for the column PREFERENCE_VALUE can be either 'N'or 'Runner.

'N'-Flag defaults to 'notchecked', but can be changed.

N means unchecked, that is, you can open multiple

'r'- Flag defaults to 'checked',but can be changed.

R stands for check, that is, you cannot open more than one

So if you want to leave this option unchecked forever, you can set preference_value to N from the background, and vice versa to R

Thank you for reading this article carefully. I hope the article "sample Analysis of closing other form modifications of EBS tool options in Oracle" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and follow the industry information channel. More related knowledge is waiting for you to learn!