Getting Error ORA-00942 While Running The EP_LOAD_SALES In The Accumulate Mode
Last updated on JUNE 23, 2017
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')
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