Getting Error ORA-00942 While Running The EP_LOAD_SALES In The Accumulate Mode
(Doc ID 2040780.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Demantra Demand Management - Version 12.2.4 and later
Information in this document applies to any platform.
Customer has a weekly load and everyday load of the shipment history data. They are planning to run the EP_LOAD_SALES weekly and EP_LOAD_SALES('ACCUMULATE') which is run everyday.
For the everyday accumulate load, they are calling the EP_LOAD_SALES ('ACCUMULATE'); procedure in the PL/SQL which is called by the workflow.
However getting the below error while running the EP_LOAD_SALES in the accumulate mode.
-942 ORA-00942: table or view does not exist Error in PROCEDURE line 208
dynamic_ddl( 'CREATE TABLE ACCUMULATE_err
WHERE 1 = 2')
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