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

Last updated on JUNE 01, 2023

Applies to:

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

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