How to Perform Form personalization in Oracle Apps |Oracle E-Business Suite

Form personalization allows you to alter or change the behavior of forms which includes

• Changing the properties
• Executing Builtins,
• Displaying Messages,
• Adding Menu Entries,
• Executing a procedure and so on...

Each personalization includes an Event, an Condition, the Scope for which it applies, and one or more Actions to perform so before you start doing form personalization you must know the below things.

• Function Name: 
• Form Name:
• Level:
• Triggering Event:
• Trigger Object:
• Condition:
• Processing Mode:
• Actions can be:
• Setting a property
• Executing a builtin
• Displaying a message
• Enabling Special Menu

Let's check out how to perform form personalization.

In this scenario suppose we want to perform form personalization for triggering a procedure when the order is booked.

Navigate to

           Order Management Super User→ Orders, Returns→ Sales Order

Now open the form personalization form as shown below.

Help→ Diagnostics→ Custom Code→ Personalize.

If you get any errors while opening the above form then you need to enable this using some profile options.

Please click here to know how to enable form personalization

Now enter the details for your form personalization

I want to perform my form personalization when the order is booked and the order should belong
to a particular org id and the order, source id should be 6.

for this we need to select the Trigger event and condition as shown below

Condition Tab
Trigger Event: OM_POST_BOOK_EVENT
Condition:       :ORDER.ORG_ID = 100 AND :ORDER.ORDER_SOURCE_ID = 6

I want to execute a procedure when the order gets booked so I'm using the below action type.

Actions Tab
Seq: 10
Type: Builtin
 
Builtin Type: Execute a Procedure
Argument:

='declare begin <package.procedurename>('''||${item.order.header_id.value}||'''); end'

Click on Apply Now.

Save Work

That's it guys..