Form Personalization to restrict the seeded LOV and attach the custom LOV to the field in the form.

Whenever we are going to create an custom LOV and want to attach to an field in the form, then that field should be LOV one. Then only we can restrict the seeded LOV and attach the custom LOV which we have created.

1. Change the Preparer LOV in requistion form.


seq  -- 10
Description  -- Change Preparer LOV

Trigger Event -- WHEN-NEW-FORM-INSTANCE

2.  Click Action Tab

Seq  Type

10    Builtin

Builtin Type - Create Record Group from Query

Argument - SELECT DISTINCT he.full_name,

                                                      he.employee_num,

                                                      he.employee_id

                      FROM po_requisition_headers prh, hr_employees he

                   WHERE he.employee_id = prh.preparer_id           

                    Order By 1

Group Name - XX_PREPARER_LOV

3. 

Seq  Type
20    Property

Object Type -- LOV
Target Object -- PREPARER_NAME  (Field name in the form).
Property Name -- GROUP_NAME
Value --  XX_PREPARER_LOV