EBS Full Download Not populating Data into Demantra Base tables. FATAL workflow.general: ORA-20002: -20003 ORA-20003: Error in PACKAGE BODY DATA_LOAD (Doc ID 2180980.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

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

Symptoms


EBS Full Download Not populating Data into Demantra Base tables.
Error in PACKAGE BODY DATA_LOAD


ERROR
-----------------------
2016-09-02 17:55:42,546 CVT [WFProcess_5] FATAL workflow.general: ORA-20002: -20003 ORA-20003: Error in PACKAGE BODY DATA_LOAD line 4441 executing ACTIVE_PROC_DYN('EP_LOAD_ITEMS') ORA-06512: at "DEMANTRA.DATA_LOAD", line 4457 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 4441 executing ACTIVE_PROC_DYN('EP_LOAD_ITEMS') ORA-06512: at "DEMANTRA.DATA_LOAD", line 4457 ORA-06512: at line 1 ORA-06512: at "DEMANTRA.DL_RUN_PROC", line 23 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at

From db_exception_log
EP_LOAD_ITEMS "-24344 ORA-24344: success with compilation error Error in PROCEDURE line 429

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Collect Shipment and Booking History with Download as N
2.Run EBS Full Download
3. Verify the Work Flow



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