Getting Error ORA-00942 While Running The EP_LOAD_SALES In The Accumulate Mode (Doc ID 2040780.1)

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.

Goal

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
  AS
  SELECT *
  FROM ACCUMULATE
  WHERE 1 = 2')
 

Solution

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