My Oracle Support Banner

Demantra 12 Upgrade Modified EP_LOAD_ITEMS Procedure, Procedure Now Errors (Doc ID 1587294.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.1 and later
Information in this document applies to any platform.


Customer has upgraded from to 12.2.1
They mention that now when they run the data load SQL procedure EP_LOAD_ITEMS it errors out after Demantra 12.2.1 Upgrade from Demantra

The following is the error received when executing the procedure:

ORA-01722: invalid number
ORA-06512: at "EP_LOAD_ITEMS", line 1863
ORA-06512: at line 1

They run the said procedure from the command line. There are no errors in the db_exception_log table

As a temporary workaround , they have been able get the procedure to work by commenting out lines 1567 to 1861 where it appears the sql is duplicate of the the lines above.




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.