Updates to Base Override For Current Month(max_sales_date) Not Getting Imported To Demantra Worksheet

(Doc ID 2392210.1)

Last updated on APRIL 27, 2018

Applies to:

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

Symptoms

On : 12.2.4.1 version, DM-Gen

The base override has an edit lock expression
Consensus Forecast Approved = 1

When users export data to excel, make updates to the excel Base overrides and import the excel, the data gets imported except for the current month(max_sales_date)
There are no errors reported but the data for the current month does not get imported
Customer removed the edit lock expression from the base override series
Bounced
Then created a worksheet with just base override
Exported the data to excel
Made an update to the Base override series
Imported it back into the worksheet
All the data gets imported except for current month
This is max_sales_date and the cell is not greyed out. It is editable for that date but the data does not get imported
There is no error message either

12.2.4 2 12240174 06-MAY-17 11:07:10
12.2.4 36 12230033 06-MAY-17 10:50:29
12.2.4 3 7302173 18-APR-18 15:56:23
12.2.4 117 0 09-MAR-16 16:36:23
12.2.4 1 12240066 09-MAR-16 16:52:19
12.2.4 117 0 29-OCT-14 21:59:11
12.2.4 1 UPGRADED FROM 29-OCT-14 23:10:53
12.2.4 33 12230033 05-AUG-16 13:21:54
12.2.4 1 12240165 27-JUL-16 17:26:36
12.2.4 29 12230033 08-APR-16 15:46:42
12.2.4 33 12230033 07-SEP-16 16:42:28

ERROR
-----------------------
No Error message popped up




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a worksheet with just base override
2. Export the data to excel
3. Made an update to the Base override series for the dates April 2018 and onwards
4. Import it back into the worksheet

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot make an override to the series

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