By default the sorting in the Control Purchasing Periods page happens in the following order - Closed, Never Opened and then Open. This does not make any business sense and it should be sorted by the Period name like the latest period first, then the previous periods and so on. Right now to view the open periods it is necessary to move to the nth page (depending upon the number of years Oracle Apps is in use) to obtain the data.
Even-though currently there is no functionality to sort based on the Period status, through the following workaround we can achieve the above mentioned purpose.
Click on “Personalize Page”
Expand Advanced Table: Control Purchasing Period > Column: (NumberColumn) > Column Header > Sortable Header: Period Number.
Click Update button
At all the levels “Inherit” will be defaulting.
Against “Sort Allowed” change it to “Yes” at the desired level.
Log out of the application. Sign back on.
Open Control Purchasing Periods page, type a value into the “Fiscal year” field & Click Go
Now by clicking on the “Period Number” it should sort ascending and descending.
Note:
This is applicable only for versions 12.0.0 to 12.1
Customers have already raised an enhancement request to display Purchasing periods in chronological order like in all other modules. Hope Oracle will rectify this bug in 12.2 releases.
---X---
No comments:
“