My Oracle Support Banner

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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.