My Oracle Support Banner

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

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