My Oracle Support Banner

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.


To view full details, 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 a vibrant support community of peers and Oracle experts.