My Oracle Support Banner

Sales Load Process Failed with error ORA-20002 after upgrade of Demantra (Doc ID 2156748.1)

Last updated on MARCH 01, 2021

Applies to:

Oracle Demantra Demand Management - Version 7.3.1.4 and later
Information in this document applies to any platform.

Symptoms

On : Demantra LoadData

Sales Load Process failed with error ORA-20002 after upgrade


ERROR
---------


 DYMANIC_DDL "-20002 ORA-20002: -913 ORA-00913: too many values Error in PROCEDURE EP_LOAD_SALES.EP_LOAD_SALES line 651

  dynamic_ddl( 'INSERT INTO T_SRC_SALES_TMPL_TMP (
  SELECT /*+ parallel(T_SRC_SALES_TMPL 4) full(T_SRC_SALES_TMPL)*/ T_SRC_SALES_TMPL.*,6 ,'05-17-2016 06:17:11', 'ITEM IN SALES source does NOT exist IN ITEMS', ROWID
  FROM T_SRC_SALES_TMPL
  MINUS
  SELECT /*+ parallel(T_SRC_SALES_TMPL 4) full(T_SRC_SALES_TMPL)*/ T_SRC_SALES_TMPL.*,6 ,'05-17-2 BEGIN <SCHEMA_NAME>.ep_load_sales; END;"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Log into the workflow manager in Demantra and run the workflow "EBS FULL DOWNLOAD"

OR

Run Collect Shipping and Booking History Collections from VCP

OR 

Run procedure EP_LOAD_MAIN

 

 



Cause

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
Symptoms
Cause
Solution
References


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