EBS Full Download Workflow Failed (LoadHistory) When Changed Time Bucket From Week To Day. (Doc ID 2287401.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

EBS full download workflow failed (LoadHistory) when changed time bucket from Week to Day.

Error Message : select * from DB_EXCEPTION_LOG order by err_Date;
"*-20002*ORA-20002: -20003 ORA-20003: Error in PROCEDURE PROPORT line 1220
  executing dynamic_proc('DYN_PROPORT_SALES_1(' WHERE 1 = 1')')"

ORA-20002: -20003 ORA-20003: Error in PACKAGE BODY DATA_LOAD line 4645
  executing ACTIVE_PROC_DYN('EP_LOAD_MDP_LEVEL')
ORA-06512: at "DEMANTRA.DATA_LOAD", line 4693
ORA-06512: at line 1
ORA-06512: at "DEMANTRA.DL_RUN_PROC", line 23
ORA-06512: at line 1

java.sql.SQLException: ORA-20002: -20003 ORA-20003: Error in PACKAGE BODY DATA_LOAD line 4645
  executing ACTIVE_PROC_DYN('EP_LOAD_MDP_LEVEL')
ORA-06512: at "DEMANTRA.DATA_LOAD", line 4693
ORA-06512: at line 1
ORA-06512: at "DEMANTRA.DL_RUN_PROC", line 23
ORA-06512: at line 1
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. changed time bucket into daily from week to day
2.Run EBS full download workflow
3. workflow failed (LoadHistory)


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