2. Open the Personalization form from the pull down menu:
Help => Diagnostics => Custom Code=>Personalize.
3. Implement the following personalization rule :
Seq: 10
Description: Increase the width of the LOV
Condition:
Trigger Event: WHEN-NEW-ITEM-INSTANCE
Trigger Object: <Name of the text item having the LOV in the Block_Name.Item_Name
format>
Condition: Null
Processing Mode: Both
Context:
Level: Site
Value: Null
Action:
Seq: 10
Type: Builtin
Description: Create Record Group
Language: All
Builtin Type: Create Record Group From Query
Argument: <Custom SQL query to populate the data in the LOV>
[Please note that the number of collumns must be the same
as the seeded record group so that LOV column mapping do
not violate]
Group Name: <Enter some record group name>
Seq: 20
Type: Property
Description: Attach the Record Group to the LOV
Language: All
Object Type: LOV
Target Object: <Name of the LOV>
Property Name: GROUP_NAME
Value: <Name of the Record Group created in the previous action>
-------------------------
Example: Customize the Application Name LOV to populate the Application Name starting with "C" in
the Application Developer > Application > Forms
-------------------------
Seq: 10
Description: Increase the width of the LOV
Condition:
Trigger Event: WHEN-NEW-ITEM-INSTANCE
Trigger Object: FND_FORM.APPLICATION_NAME
Condition: Null
Processing Mode: Both
Context:
Level: Site
Value: Null
Action:
Seq: 10
Type: Builtin
Description: Create Record Group
Language: All
Builtin Type: Create Record Group From Query
Argument: select APPLICATION_NAME, APPLICATION_ID
from FND_APPLICATION_VL
where APPLICATION_NAME like 'C%'
order by APPLICATION_NAME
Group Name: RG_APPLICATION
Seq: 20
Type: Property
Description: Attach the Record Group to the LOV
Language: All
Object Type: LOV
Target Object: APPLICATION_LOV
Property Name: GROUP_NAME
Value: RG_APPLICATION
4.Save the personalization rule.