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 04, 2025
Applies to:
Oracle Demantra Demand Management - Version 7.3.0 and laterInformation 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 |