Shipment & Collections Not Populating Data In Demantra Tables - ORA-00913: too many values Error in PROCEDURE EP_LOAD_SALES.EP_LOAD_SALES line 641

(Doc ID 2030025.1)

Last updated on FEBRUARY 07, 2017

Applies to:

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

Symptoms

On : 7.3.1.5 version, LoadData

When attempting to run EBS Full Download workflow,
the following error occurs.

ERROR
-----------------------
2015/07/03 09:58:25,EP_LOAD_SALES,-913 ORA-00913: too many values Error in PROCEDURE EP_LOAD_SALES.EP_LOAD_SALES line 641

       dynamic_ddl( 'INSERT INTO T_SRC_SALES_TMPL_TMP (
               SELECT /*+ PARALLEL(T_SRC_SALES_TMPL DEFAULT) FULL(T_SRC_SALES_TMPL)*/ T_SRC_SALES_TMPL.*,6 ,'07-03-2015 09:58:21', 'ITEM IN SALES source does NOT exist IN ITEMS', ROWID
               FROM   T_SRC_SALES_TMPL
            MINUS
               SELECT /*+ PARALLEL(T_SRC_SALES_TMPL DEFAULT) FULL(T_SRC_SALES_TMPL)*/ T_SRC_SALES_TMPL.*,6 ,'07-03-2015 09:58:21', 'ITEM IN SALES source does NOT exist IN ITEMS', T_SRC_SALES_TMPL.ROWID


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Workflow Manager.
2. Run EBS Full Download workflow.
3. Check the log tables.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load data from EBS to Demantra.This is happening in an environment where a fresh implementation has been done. This is not happening in previous environment where this issue was never faced.

Cause

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