Changing LOV using Forms Personalization on Oracle Apps R12

Posted by: Edi Yanto on: April 26, 2009

• In: Oracle
• 16 Comments

The below steps are change the LOV in “Supplier” field in the “Define User” form using Form Personalization (just want to list the suppliers who have the location in” NY (New York)”) on Oracle Apps R12:

1. Open the Define User Form on System Administrator Responsibility (Security > Users > Define)
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 Supplier 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 full_name, supplier_name, supplier_location, supplier_contact_id from icx_supplier_contact_lov where supplier_location like ‘%NY%’ order by full_name, supplier_name, supplier_location
   • Group Name = EY_SUPPLIER_GROUP
7. Click on the “Validate” button, then click on “Apply Now” button
8. On next Actions tab, enter or select the following values
   • Sequence = 20
   • Type = Property
   • Description = Assign New Record Group
   • Language = All
   • Enabled = Yes
9. On the right side of Actions tab, enter or select the following values
   • Object Type = LOV
   • Target Object = SUPPLIER_LOV
   • Property Name = GROUP_NAME
   • Value = EY_SUPPLIER_GROUP
10. Validate All (Menu Tool > Validate All), Apply and Save the changes
11. Close the Define User form and open it again.

This slideshow requires JavaScript.

Tags: ebiz, forms personalization