1.Navigate to the Form which is having the LOV Item

2.Open the Personalization form from the pull down menu Help => Diagnostics => Custom Code =>    Personalize.

3. Implement the following Personalization rule :

You can use FORMS_DDL Builtin Type of the action Builtin:

Seq: 10
Description: Update Database Column
      Trigger Event: <Select a appropriate trigger name>
      Trigger Object: <Select the name of the appropriate object >
       Condition: <condition when the database column will be updated>
       Processing Mode: Both
       Context:
       Level: Site
       Value: Null

Seq: 10
Type : Builtin
Builtin Type : FORMS_DDL
Argument :
     =’Declare
        Begin
       Insert Into <table_name>(<column_name>) values(‘||  (:<block_name><item_name_1> +
                   :<block_name><item_name_2>) ||’);
        Commit;
        End;’

4.Save the personalization rule.

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s