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 22, 2024

Applies to:

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

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