Download Calendars into Demantra Error (Doc ID 1274481.1)

Last updated on DECEMBER 03, 2015

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 7.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Dec-2015***

Symptoms


When running the Download Calendars process the following error was observed

+---------------------------------------------------------------------------+
Demand Planning: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

MSDDEMDC module: Download Calendars
+---------------------------------------------------------------------------+

Current system time is 15-DEC-2010 14:05:09

+---------------------------------------------------------------------------+

**Starts**15-DEC-2010 14:05:09
**Ends**15-DEC-2010 14:05:19
ORA-20002: -20003 ORA-20003: Error in PROCEDURE INTEGRATION_1_LOAD_CALENDARS line 519
executing ACTIVE_PROC_DYN('dyn_load_calendars ('Month','APPS
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Collecting Calendar: EBS:DEMFISC
Collecting Calendar: EBS:DBU_BEL
Collecting Calendar: EBS:DBU_CMC
Collecting Calendar: EBS:DBU_NLD
Collecting Calendar: EBS:DBU_NOR
Collecting Calendar: EBS:DBU_SWE
ORA-20002: -20003 ORA-20003: Error in PROCEDURE INTEGRATION_1_LOAD_CALENDARS line 519
executing ACTIVE_PROC_DYN('dyn_load_calendars ('Month','APPS
+---------------------------------------------------------------------------+
End of log messages from FND_FILE

It was observed in the db_exception_log table in the Demantra schema the following errors:

ERR_DATE PROC_NAME ERR_MSG
12/15/2010 10:46 INTEGRATION_1_LOAD_CALENDARS "-20003 ORA-20003: Error in PROCEDURE INTEGRATION_1_LOAD_CALENDARS line 519
executing ACTIVE_PROC_DYN('dyn_load_calendars ('Month','APPS.MSD_DEM_TIME')')"
12/15/2010 10:46 DYN_LOAD_CALENDARS "-1 ORA-00001: unique constraint (XXDEM.T_EP_FISCAL_MONTH_PK) violated Error in PROCEDURE DYN_LOAD_CALENDARS line 291

dynamic_ddl( 'INSERT INTO T_EP_FISCAL_Month (T_EP_FISCAL_Month_ID, T_EP_FISCAL_Month_CODE
,T_EP_FISCAL_Month_DESC, LAST_UPDATE_DATE, IS_FICTIVE)
SELECT MAX(T_EP_FISCAL_Month_ID)+1,'2009/05/04','MAY-2009-09', SYSDATE,0
FROM INPUTS ')"

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