Fusion Blog

EBS Blog


Contact Us

Functional Documents
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 1 / 5

Star ActiveStar InactiveStar InactiveStar InactiveStar Inactive

Form Personalization – DEFAULT_WHERE

This document is to demonstrate the usage of DEFAULT_WHERE in form personalization. The functionality is very useful in case we want to default or filter transaction in standard Oracle form. The functionality is achieved by using form personalization.


Lets understand this function with the use of example. Suppose the requirement is that the user only interested in Sales Orders created within last 2 days. So that if user queries sales orders in Sales Order Form it only displays those orders which are created in last 2 days. 


In the example I will create a menu and when user clicks on menu the orders should be filtered with the above mention condition. So it requires two form personalization. First to create menu and second to attach DEFAULT_WHERE to the menu.


Step 1: Create Menu

FP 01


Step 2: Create Action for Menu

Step 3: Create DEFAULT_WHERE condition on menu created above

Step 4: Create Action for DEFAULT_WHERE 


I have used below value to filter sales order:

='header_id IN ('|| 'SELECT header_id FROM OE_ORDER_HEADERS_ALL WHERE LAST_UPDATE_DATE > SYSDATE-2 and org_id = 94'||')'


That's it !!!!


Rahul Birkett

Add comment

Security code

About the Author

Rahul Birkett

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  2  3  4  5  6  7  8

Enquire For Training

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner