Demantra Has Dates Till 2030, Need Dates Beyond That (Doc ID 2282937.1)

Last updated on JULY 03, 2017

Applies to:

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

Symptoms

On : 7.3.1 version, MICC Transfer to TSC

Importing the data into Demantra from upstream application
The dates being imported are for year 2031 e.g. 5/26/2031
However the Demantra inputs table has dates till only 2030

Customer has data for dates beyond 2030 and need dates loaded for future dates.

ERROR
-----------------------
ODPM-00074 Invalid Date




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an Import profile
2. Load data in the staging tables for dates beyond 2030
3. Run the import integration interface to load the data into demantra tables

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, data cannot be loaded into demantra for dates beyond 2031

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