Form Personalization : Restrict LOV in People and Maintain

Form Personalization : Restrict LOV in People and Maintain

Form Personalizations:

Restrict Lov Value through Form Personalization.

The below steps are changing the LOV in “Title” field in the “People and maintain” form using Form Personalization (just want to list the Title  in ‘Mr.’,’Doctor’ on Oracle Apps R12:

1. Open the Define User Form on Human Resourse Vision Operations (People and Maintain  
2. Open the Personalization form using the navigation “Help > Diagnostics > Custom Code > Personalize”
3. Enter the sequence number as 10 and description “Change Value of  Title LOV”
4. Select the Trigger Event as “WHEN-NEW-FORM-INSTANCE” and save the changes
5. On Actions tab, enter or select the following values
   • Sequence = 10
   • Type = Builtin
   • Description = Create New Record Group
   • Language = All
   • Enabled = Yes
6. On the right side of Actions tab, enter or select the following values
   • Builtin Type = Create Record Group from Query
   • Arguments =     SELECT lookup_code,meaning FROM HR_LOOKUPS
7.   WHERE LOOKUP_TYPE='TITLE'
8.   and lookup_code in ('DR.','MR.')Group Name = XX_TITLE__GROUP
9. Click on the “Validate” button, then click on “Apply Now” button
10. On next Actions tab, enter or select the following values
    • Sequence = 20
    • Type = Property
    • Description = Assign New Record Group
    • Language = All
    • Enabled = Yes
11. On the right side of Actions tab, enter or select the following values
    • Object Type = LOV
    • Target Object = TITLE_LOV
    • Property Name = GROUP_NAME
    • Value = XX_TITLE__GROUP
12. Validate All (Menu Tool > Validate All), Apply and Save the changes

13.  Close the Define User form and open it again.