Time Level Is Not Sorting Properly In Worksheet

(Doc ID 2313557.1)

Last updated on OCTOBER 03, 2017

Applies to:

Oracle Demantra Demand Management - Version and later
Information in this document applies to any platform.


On : version, Worksheet

Time Level is not sorting properly in worksheet .

Time levels are wrongly sorted.

Fiscal Year :
   Fiscal Month
   OCT 2017
   NOV 2017
   DEC 2017
   SEP 2017

Time Level should be sorted by the dates.

The issue can be reproduced at will with the following steps:
1. Populated the t_ep_fiscal_% level tables and mapped the t_ep_fiscal_%_ID column in inputs table.
2. Log into Collaborator Workbench.
3. Modify an worksheet to add Fiscal Year & Fiscal Month time levels.
4. Run the worksheet.
The time levels are not sorted as per dates.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms