My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

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


On : 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
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 grey 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

No Error message popped up

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 on wards
4. Import it back into the worksheet


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

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