How to insert or update a database column based on some calculation using Forms Personalization


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.

One thought on “How to insert or update a database column based on some calculation using Forms Personalization

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s