MSDDEMDC: Download Calendars Fails With Error - ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 2173372.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

When running the Download Calendars concurrent request to collect calendars into Demantra you are getting the following error:

ERROR
MSDDEMDC: Download Calendars

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Collecting Calendar: TST:445Calendar
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
 

STEPS TO REPRODUCE
1. Open Demand Management responsibility.
2. Run Download Calendars concurrent request.


BUSINESS IMPACT
Due to this issue, you cannot collect calendars into Demantra

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