My Oracle Support Banner

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 JULY 07, 2018

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

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


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