My Oracle Support Banner

EBS Full Download Fatal workflow.general ORA-20002 ORA-20003 PACKAGE BODY DATA_LOAD ACTIVE_PROC_DYN('EP_LOAD_SALES') ORA-1652: Unable to Extend Temp Segment (Doc ID 969580.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms


When attempting to run the Full EBS Download (to load data into Demantra) the following error was observed in the Collaborator.log

ERROR
-----------------------
120 [WFProcess_0] FATAL workflow.general: appserver.workflow.general
java.sql.SQLException: ORA-20002: ORA-20003:
Error in PACKAGE BODY DATA_LOAD line 3948
executing ACTIVE_PROC_DYN('EP_LOAD_SALES')
ORA-06512: at "DEMANTRA.DATA_LOAD", line 3985
ORA-06512: at line 1
ORA-06512: at "DEMANTRA.DL_RUN_PROC", line 20
ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute EBS Full Download workflow

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load data (although it is noted that a subsequent run completed successfully)

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.