How to display the GL Periods in order (like Jan,Feb,Mar…..)

Oracle Apps Interview Questions › Category: GL › How to display the GL Periods in order (like Jan,Feb,Mar…..)

Anonymous asked 9 years ago

I Want to show the period names in the list of values for a report.
For this i have taken period_name column from gl_period_statuses table.
but the periods are displayed in the alphabetical order.But i need in order like
(Jan-13,Feb-13,Mar-13……….Jan-14,Feb-14,Mar-14………….).

Question Tags: Feb, Mar.....), Period Name By Order (like Jan