Page 1 of 1

How To Prevent the Profile Option MO: Operating Un

Posted: Wed Mar 21, 2007 2:50 am
by ahmadbilal
Setup steps
Login to the application as SYSADMIN
Responsibility : System Administrator
Profiles
System
Choose from the menu:
Help
Diagnostics
Custom Code
Personalize
Create a new Rule

Seq : 10
Description : MO: Operating Unit
Level : Function
Enabled : [checked]

Specify the following Condition:

Trigger Event : WHEN-VALIDATE-RECORD
Trigger Object : PROFILE_VALUES
Condition : :PROFILE_VALUES.PROFILE_OPTION_NAME = 'ORG_ID' AND :PROFILE_VALUES.SITE_VISIBLE_VALUE IS NULL
Processing Mode : Not in Enter-Query Mode





Assign the following Actions to the Rule:

Seq : 10
Type : Message
Description : MO: Operating Unit
Language : All
Enabled : [checked]
Message Type : Error
Message Text : You must specify a profile option value at Site level for the profile option 'MO: Operating Unit'.





Save the changes
Close the System Profile Values form

Result

An error message will appear if an end user or a System Administrator now tries to remove the profile option value. The application will no longer allow anyone to delete the value and this breaks the environment however it will still be possible to specify a different organization at Site level.



Source
Metalink.oracle.com

Posted: Wed Mar 21, 2007 3:24 am
by admin
The best way is to use Application Developer Responsibility > Profile and search the profile and update the profiles options as per your requirements. thanks