Change sort order of the Recent Timecards List in Oracle Time and Labour
By default the recent timecards functionality in Oracle Time and Labour sorts on Status and Submission Date. We had the requirement to change this sort into someting different. The requirement was that the latest timecards appeared first.
I changed the sorting option of the recent timecards list with a small personalization. We first sort on the Timecard Status (in our case we have the timecard status Working and Approved) and second on the Period Start Date of the timecards. This way the Working timecards will be listed first and after that the approved ones in a descending order.
To achieve this you need to implement the following steps.
First you have to enable some profile options and set it to the username who's going to do the change. Change the below profile options and set it for the specific username on value Y (for Yes).
Next open up a recent timecards list and click on the Personalize "Recent Timecards List" link.
Click on the Personalize pencil for the Advanced Table row.
Click on the Query icon for the level you want to implement the personalization.
Change the sorting settings and Apply your personalization.
After this the Recent Timecards list is sorted in a new way.
I changed the sorting option of the recent timecards list with a small personalization. We first sort on the Timecard Status (in our case we have the timecard status Working and Approved) and second on the Period Start Date of the timecards. This way the Working timecards will be listed first and after that the approved ones in a descending order.
To achieve this you need to implement the following steps.
First you have to enable some profile options and set it to the username who's going to do the change. Change the below profile options and set it for the specific username on value Y (for Yes).
- Create Seeded Personalizations
- FND: Personalization Region Link Enabled
- FND: Personalization Seeding Mode
- HR: Enable User Personalization
- Personalize Self-Service Defn
Next open up a recent timecards list and click on the Personalize "Recent Timecards List" link.
Click on the Personalize pencil for the Advanced Table row.
Click on the Query icon for the level you want to implement the personalization.
Change the sorting settings and Apply your personalization.
After this the Recent Timecards list is sorted in a new way.