Triggers in form personalization in oracle apps

Triggers in form personalization in oracle apps

In this post , We will be discuss about triggers in form personalization in oracle apps. Triggers helps to execute the form personalization in oracle application. We do write the form personalization action code in triggers. Oracle apps has provided the 4 triggers in form personalization , we do write our programmatic logic's in these triggers in form personalization. Here below is the complete detail about Triggers in form personalization in oracle apps.

4 Important Triggers in form personalization in oracle apps

1.WHEN-NEW-FORM-INSTANCE

2.WHEN-NEW-BLOCK-INSTANCE

3.WHEN-NEW-RECORD-INSTANCE

4.WHEN-NEW-ITEM-INSTANCE

5.WHEN-VALIDATE-RECORD

WHEN-NEW-FORM-INSTANCE :- 

When we want to perform action immediately when ever , we will open that Oracle form , then we do the form personalization under WHEN-NEW-FORM-INSTANCE trigger.

.WHEN-NEW-BLOCK-INSTANCE :- 

When we want to perform some action whenever , we will go to Form Block , then we do the form personalization under WHEN-NEW-BLOCK-INSTANCE trigger.

WHEN-NEW-RECORD-INSTANCE:- 

When we want to perform some action whenever , we will go to the new Row in the Form Block , then we do the form personalization under WHEN-NEW-RECORD-INSTANCE trigger.

WHEN-NEW-ITEM-INSTANCE :- 

When we want to perform some action whenever , we will go to some specific Form Field , then we do the form personalization under WHEN-NEW-ITEM-INSTANCE trigger.

WHEN-VALIDATE-RECORD:- 

We do use this trigger when we want to perform some action while saving the record. This Trigger executes most of the time , when we do save the records in oracle forms.

Example Using Triggers in form personalization in oracle apps

Step1:- We are creating this Personalization  , to stop entering the Receipt Date less then the Actual PO Creation date.

Step2:- In this step , we are creating One Variable , to store the Creation Date of Purchase Order.

=SELECT TO_CHAR (TRUNC(CREATION_DATE),'DD-MON-RR') FROM PO_HEADERS_ALL WHERE SEGMENT1=:OVERFLOW_REGION.ORDER_NUM

Step3:-

Step 4:-

Step5:-