EP_LOAD_SALES "-913 ORA-00913: too many values Error in PROCEDURE EP_LOAD_SALES line 335" when running "EBS full load" Workflow (Doc ID 1315700.1)

Last updated on APRIL 21, 2016

Applies to:

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

Symptoms

When attempting to run the “EBS full load” workflow the following error occurs on Collaborator Workbench

ERROR
-----------------------

Process ID: 4036
Schema ID: 2580
Schema name: ’’EBS Full Download’’
Step ID: ’’LoadHistory’’
Step name: ’’LoadHistory’’


Error description ’’Database internal error:ORA-20002: -20003 ORA-20003: Error in PACKAGE BODY DATA_LOAD line 4050’’

From db_exception_log

EP_LOAD_SALES "-913 ORA-00913: too many values Error in PROCEDURE EP_LOAD_SALES line 335

dynamic_ddl( 'INSERT INTO ep_T_SRC_SALES_TMPL_ld
SELECT /*+ parallel(T_SRC_SALES_TMPL 4)*/ T_SRC_SALES_TMPL.*,TRUNC(NEXT_DAY(t_src_sales_tmpl.sales_date,'monday') - 7) aggre_sd
FROM T_SRC_SALES_TMPL')"
DATA_LOAD "-20003 ORA-20003: Error in PACKAGE BODY DATA_LOAD line 4050
executing ACTIVE_PROC_DYN('EP_LOAD_SALES')"




STEPS
1. run the “EBS full load” workflow

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