My Oracle Support Banner

When Fiscal Year Is Added As A Level In The Worksheet, Some Of The Months Are Missing In Worksheet (Doc ID 2460294.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

On : 12.2.3 version, DM-Gen

ACTUAL BEHAVIOR
---------------

When Fiscal Year is Added as a Level in the Worksheet, some of the Months are 

Missing   

 

If the Fiscal Year is added to the worksheet, not all months are being 

displayed in the worksheet. When the Fiscal Year is removed as an Aggregation 

in the Worksheet Designer, all the months are being displayed on the 

worksheet. I also found out that these months are missing in sales_data 

table.   

 

 

This is also happening in the upgraded 12.2.6 version of Demantra. 

 

When they have Fiscal year in the worksheet the dates 

 

The Time shows 

01/01/18 

02/01/18 

03/01/18 

07/01/18 

 

When the Fiscal Year is removed then it shows all the months 

01/01/18 

02/01/18 

03/01/18 

04/01/18 

05/01/18 

06/01/18 

07/01/18 

08/01/18 

09/01/18 

10/01/18 

11/01/18 

12/01/18 



EXPECTED BEHAVIOR
-----------------------
Expect all the moths to be displayed

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add fiscal year to the worksheet
2. Run worksheet
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users do not get the correct data

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.