This chapter covers the following topics:
In Oracle applications, the following page elements may be end-user personalized:
Views panel of a Search page
LOV Choice List
Table (Classic and Advanced)
In OA Framework-based applications, tables are used to display results from a search. The region above the table generally contains the search panel where you specify the search criteria. You may see any one of these possible search panels above a table:
Simple Search - allows you to specify simple search criteria.
Simple Search or Advanced Search - buttons allow you to toggle between a simple search panel and an advanced search panel to specify search criteria.
If a table is user-personalizable, it will support user-personalizable searches that you can save as Saved Searches. The saved saved searches can be selected from the Saved Searches panel, which you access using the Saved Searches button on the main search page.
The first time you access a Saved Searches-enabled page (and you have no saved searches to run) the following occurs:
If the page only has a Saved Searches panel, the Saved Searches panel displays with an empty Saved Searches poplist. You need to select the Personalize button to create one or more saved searches.
If the page has a Saved Searches panel and a Simple Search panel, the Simple Search panel renders. You need to execute a query and select the Save Search button to access the personalized query in the Saved Searches panel.
If the page has a Saved Searches panel and an Advanced Search panel, the Advanced Search panel renders. You need to execute a query and select the Save Search button to access the personalized query in the Saved Searches panel.
Often times, if a table is end-user personalizable, seeded personalized Saved Searches for that table may already exist and be displayed in the Saved Search poplist.
Note: When the Saved Searches panel is displayed, the table in the Query region displays the personalized saved search that you previously marked as the default. If you did not specify a default personalized saved search, then any "admin-seeded user-level" saved search or "Oracle-seeded user-level" saved search that is set as a default is displayed, where the Admin-seeded saved search takes precedence over the Oracle-seeded saved search.
Tip: When you navigate to the Search or Advanced Search panel, the table in the Query region no longer reflects the user-defined personalizations, but rather, reflects the base saved search of the table with any admin-level personalizations that apply. If you have the appropriate privileges, you can create Admin-level personalizations for the table in the Simple and Advanced Search panels.
You can create a personalized saved search of a table in a Query page using one of two methods:
Method 1
Navigate to the application page that contains the personalizable table you wish to alter.
Use the search panel to query for specific results in the table.
Select Save Search to save the search criteria that queried for these results.
When you select Save Search, the Create Saved Search page appears, allowing you to save this search as a new personalized saved search of the table. You can also edit other attributes and properties of the table.
Once you apply your changes, the saved search becomes a personalized saved search that you can select from a panel that lists your personal saved searches.
Method 2
Navigate to the application page that contains the table you wish to personalize.
If the page does not already show the Saved Searches panel, select Saved Searches.
Additional Information: If the region does not have any predefined personalizations, the Saved Search panel does not appear. Instead the Search region appears and you can create a personalization by choosing the Save Search button after specifying and performing a search.
In the Saved Searches panel, you have two options:
Apply a specific personal saved search, if one exists, by selecting a saved search from the Saved Searches poplist and choosing Go.
Create a new saved search or update an existing saved search by choosing Personalize to display the Personalize Saved Searches page.
Method 3
Navigate to the application page that contains the table you wish to personalize.
Use your mouse to drag columns to new positions or resize columns in the table. The resulting personalization is automatically saved to a saved search.
OA Personalization does not retain the saved search selection for the current Query page when you move to another page. For example, suppose you display a personalized saved search of the Query page by selecting a saved search (such as Saved Search X) from the Saved Searches panel. Then you select the Personalize button to display the Personalize Saved Searches page, but choose Cancel without making any changes. When you return to the Query page, the base definition is displayed and not Saved Search X. As a developer, if you do not want this behavior and instead, want to retain the saved search, you need to modify the controller for the page to pass the user-selected saved search as a parameter and set that saved search as the current personalization when ever the user returns to the Query page.
The Personalize Saved Searches page displays a description of each saved search.
Select a saved search and choose Update, Duplicate or Delete.
In the Update Saved Search page, the fields are pre-populated with data from the saved search that you want to update.
The Duplicate Saved Search page is identical to the Update Saved Search page and is also pre-populated with data from the original saved search that you want to duplicate. The Saved Search Name field also shows a default value of "Copy of [SavedSearchName]".
If you want to delete an existing saved search, click the Delete icon in the same row. If you choose to delete a saved search, a warning message appears to confirm that you really want to delete the saved search.
Additional Information: If the saved search is an "admin-seeded user-level" saved search or an "Oracle-seeded user-level" saved search, you cannot update or delete the saved search as an end-user. If you wish to modify a seeded saved search, you must make a duplicate of the seeded saved search and modify the duplicate. This ensures that when Oracle ships a new release that contains changes to its seeded saved searches, your personalizations are not overwritten.
If you wish to create a new personalized saved search of the table, choose Create Saved Search.
Use the Display Saved Search poplist to control whether the saved search displays in the Saved Search poplist of the Saved Searches panel.
The Create Saved Search page is identical to the Update Saved Search and Duplicate Saved Search pages, except that the fields in the latter pages are pre-populated with settings from the selected saved search.
When you save a saved search of a query region that is a shared region (that is, the query region was actually defined in some other base region, and the current region shares or extends that base region), the saved search is saved on the current instance of the region you are using, and not on the base region. So if another page extends the same base region, you will not see your saved search on that other page.
In addition to the default behavior, developers can set a property on the query region that allows a saved search that you create to be stored directly on the shared region, rather than as a per instance saved search. This allows you to see the personalized saved search in all pages where the query region is shared.
Note: This option applies only to new query regions that are created with OA Framework Release 12. Your application documentation will indicate when this behavior has been enabled for a given Release 12 query region.
Important: Administrators should refrain from creating a per instance saved search on a shared query region that has this feature enabled. In other words, when you create a personalization, you should set the scope of the personalization context to the shared region and not to the page itself.
Administrators are able to seed user-level saved searches that apply to either the base region of a shared region, or to a specific instance of a shared region (per-instance saved search).
As a user, you can see the list of all Admin-seeded per-instance saved searches for a region in the Saved Searches poplist of the Saved Search panel, as well as all your own personalized saved searches. Although you cannot modify an Admin-seeded saved search, you can always create a duplicate of any Admin-seeded per-instance saved search and mark the duplicate as your default saved search.
To specify general properties
Enter a user-friendly Saved Search Name to identify your personalization.
Select the number of rows of data you wish to display in the table in your personalized saved search.
Check Set as Default if you wish to make this saved search your default saved search. There can only be one default saved search at any time. If you check Set as Default for the current saved search, than any saved search that you previously marked as the default becomes unmarked.
Additional Information: If you wish to mark a predefined seeded personalized saved search as your default, create a duplicate of the seeded saved search, and check Set as Default for the duplicate search.
Additional Information: If an "Oracle-seeded" end user saved search and an "Admin-seeded" end user saved search of the same region are both marked as defaults, the "Admin-seeded" end user saved search takes precedence and is displayed as the default. If, however, you also create your own personalized saved search of the same region and set it as the default, then your personalized saved search takes precedence over both levels of seeded saved searches and becomes your default. See Saved Searches for additional information.
Enter a description for this personalized saved search.
The columns of the table region appear in the Available Columns list. Edit the Column Properties to specify the columns you wish to display and the order in which to display them.
Select an item from the Available Columns or Columns Displayed list and use the buttons between these lists to shuttle the selected item between the two lists.
Note: Columns that are required fields in a page appear with an asterisk (*) and cannot be removed from the Columns Displayed list.
Example of an Advanced Table with Two Levels of Column Spans
Each of the columns in the top row (labeled "Group X" and "Group Y") spans two columns in the second row (labeled "Group A" and "Group B" in both cases). Each "Group A" column in turn spans "Column 1" and "Column 2" below it, while each "Group B" column spans "Column 3" and "Column 4."
If the region you are personalizing is an Advanced Table that displays column spans, as shown in the example, the columns listed in the Available Columns and Columns Displayed shuttle will have the entire hierarchy of column group names appended to each column name. This ensures that you hide/show the correct column, especially in the case where multiple columns of the same name may exist within different column groups. For the example, the columns shown in the Available Columns and Columns Displayed lists would be:
Group X: Group A: Column 1 Group X: Group A: Column 2 Group X: Group B: Column 3 Group X: Group B: Column 4 Group Y: Group A: Column 1 Group Y: Group A: Column 2 Group Y: Group B: Column 3 Group Y: Group B: Column 4
Once you are satisfied with the items to display, select an item from the Columns Displayed list and use the buttons to the right of the list to reorder the sequence in which the item appears.
Choose Rename Columns / Totaling to alter other settings for your columns.
You can specify up to three levels of sorting for your data. Select a column from the Column Name poplist for each level of sorting you wish to perform.
For each column to sort, you must specify whether to sort in ascending or descending order.
Additional Information: Only columns whose User Personalization property is set to True by the developer or administrator, appear in the Column Name poplist.
To filter data in the table
You can filter the data that is displayed in the table based on criteria that you specify.
Indicate how you want the filter to match your search conditions by selecting one of the following radio buttons:
Show table data when all conditions are met = Match All.
Show table data when any condition is met = Match Any.
The first four columns of the table are listed for you to specify search criteria. Using the poplist following the column name, choose a search condition and enter a value to search for in that column.
As of Release 12.2.4, in addition to the search conditions, "greater than", "is", "is not" or "less than", you can now specify "is not (include blanks)" to also return null values from a search.
Select a column from the Add column poplist and choose Add to add more search criteria to your filter.
Additional Information: Only columns whose Search Allowed property is set to True by the developer or administrator, appear in the Add Another poplist.
If you leave the search criteria blank for a column, the filter will not search on that column.
To save your personalized saved search
When you are done personalizing your saved search of the table, choose Apply or Apply and View Results. Choosing Apply saves the personalized saved search and returns you to the Personalize Saved Searches page. Choosing Apply and View Results saves the search you just created or updated, and returns you to the application page where the saved search you just created is set as the current personalized saved search.
If you choose Revert to revert to default settings, the following occurs depending on the page you are using:
Create Saved Search page - the page defaults to the pre-seeded display settings and no query options are set.
Update Saved Search or Duplicate Saved Search page - the page defaults to the display settings and query options of the saved existing saved search you are trying to update or duplicate.
Use this page to change the labels of the table columns.
Check Show Total to turn on totaling for a specific column, if it is applicable to the underlying data.
Tip: If you choose to display a column with totaling capabilities, make sure this column is displayed as the last column of the table.
Choose Apply to accept your changes and return to the Create Saved Search or Update Saved Search page.
An LOV Choice List is a hybrid between a poplist and a List of Values. If the LOV Choice List is implemented with a Personalize button, you can personalize the LOV Choice List by adding, removing, or reordering values in the list.
Select the Personalize button next to the LOV Choice List. (For a LOV Choice List within a table, the Personalize button is displayed in the table action area. If there are multiple LOV Choice List columns within a table, a separate Personalize button is rendered in the table action area for each of those columns.)
A Personalize (LOV Choice List) page appears, containing a shuttle region that displays an Available and a Selected list. To avoid performance problems in case the complete list of values is very large, the Available list is rendered empty when the page displays. Use the data filter above the Available list to search for a subset of values to display.
Use the shuttle controls to add or remove values from the LOV Choice List.
Use the reorder buttons next to the Selected list to reorder the values in the LOV Choice List.
Choose Apply to save your personalization.
If the profile FND: Enable Rich Table Interactions is Yes
and a table is user personalization-enabled, a user can reorder and/or resize its columns as follows:
Navigate to the page with the user personalization-enabled table.
Using the mouse to select a column separator, move the column separator to enlarge or reduce the width of the column.
Using the mouse to select a column header, drag the column header to move the column to a new location within the table.
Any changes you make to the width or order of the table columns are automatically saved for that page.
See a summary of key Personalization issues with suggested workarounds if available.