My Oracle Support Banner

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 AUGUST 17, 2022

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

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.