Subledger Journals - OTBI Subject Area
In Subledger Journals OTBI subject area, Accounting period column does NOT show in ascending/descending order in prompts.
Using the below SQL in the prompts solves the issue but it takes a while to show the value when the dropdown is clicked.
SELECT "Time"."Fiscal Period" FROM "Subledger Accounting - Supporting References Real Time" ORDER BY "Time"."Fiscal Period Start Date" DESC FETCH FIRST 65001 ROWS ONLY
Are there better ways to show the accounting period in descending order in prompts dropdown?