Changing LOV using Forms Personalization on Oracle Apps R12

Posted by: Edi Yanto on: April 26, 2009

In: Oracle
Comment!

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:

Open the Define User Form on System Administrator Responsibility (Security > Users > Define)
Open the Personalization form using the navigation “Help > Diagnostics > Custom Code > Personalize”
Enter the sequence number as 10 and description “Change Value of Supplier LOV”
Select the Trigger Event as “WHEN-NEW-FORM-INSTANCE” and save the changes
On Actions tab, enter or select the following values
• Sequence = 10
• Type = Builtin
• Description = Create New Record Group
• Language = All
• Enabled = Yes
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
Click on the “Validate” button, then click on “Apply Now” button
On next Actions tab, enter or select the following values
• Sequence = 20
• Type = Property
• Description = Assign New Record Group
• Language = All
• Enabled = Yes
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
Validate All (Menu Tool > Validate All), Apply and Save the changes
Close the Define User form and open it again.