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 12.2.6.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6.1 version, Worksheet

ACTUAL BEHAVIOR
---------------
Time Level is not sorting properly in worksheet .

Time levels are wrongly sorted.

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



EXPECTED BEHAVIOR
-----------------------
Time Level should be sorted by the dates.

STEPS
-----------------------
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.


Cause

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