Demantra 12 Upgrade Modified EP_LOAD_ITEMS Procedure, Procedure Now Errors
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.
Customer has upgraded from 22.214.171.124 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 126.96.36.199.
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.
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