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

Last updated on OCTOBER 31, 2013

Applies to:

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

Symptoms

Customer has upgraded from 7.3.1.4 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 7.3.1.4.

The following is the error received when executing the procedure:

ORA-01722: invalid number
ORA-06512: at "TPM_PFC.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.

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