[email protected]
http://Learnoracleapps.com
Create Custom Profile Option
I used the custom profile options more than once,
One time it was requested to create custom profile option to Enable/Disable the Delete button on a specific
form, Another time to enable/Disable the payroll forms per user level not per responsibility.
In the following example I will create a profile option that will restricts specific forms per user, this way you will
not be worry who have access to the form as it will not open unless the access granted by the custom profile.
Create the Custom Profile option
1. Go to : Application Developer >> Profile
2. Create New record as per the following data:
a. NAME: XX_PAYROLL_USER
b. Application: Human Resources
c. User Profile Name: XX Enable Payroll Forms
d. Hierarchy type: Security
e. Access Level (User Only)
f. SQL Validation:
SQL="SELECT MEANING \"Payroll Forms Enabled\", LOOKUP_CODE
into :visible_option_value,
:profile_option_value
from fnd_lookups
where lookup_type = 'YES_NO'"
COLUMN="\"Payroll Forms Enabled\"(30)"
[email protected]
http://Learnoracleapps.com
Create the personalization at the required form
1. Go to: Payroll Entries Form
2. Open the personalization form:
a. In Condition Tab:
i. Trigger Event: WHEN-NEW-FORM-INSTANCE
ii. Condition :
FND_PROFILE.VALUE('XX_PAYROLL_USER')<>'Y'
or
FND_PROFILE.VALUE('XX_PAYROLL_USER') is null
b. In Actions Tab
i. Seq: 10
Type: Message
Message Type: Show
Message Text: You are not authorized to open this form
ii. Seq : 20
Type: Builtin
Builtin Type: DO_KEY
Argument:EXIT_FORM
[email protected]
http://Learnoracleapps.com
Update the profile value on the user level
Go to : System Administrator >> Profile>> System
And update the value for the profile option XX Enable Payroll Forms at the level to Yes or No to enable or disable
his access to the form