My Oracle Support Banner

EP_LOAD_MAIN. EBS Full Download. Database Internal Error:ORA-20002: ORA-20003 (Doc ID 1394874.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Oracle Demantra Demand Management - Version 7.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Jan-2016***

Purpose

To solve this error found in many situations:
Database internal error:ORA-20002: -20003 ORA-20003: Error

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 ENHANCE EP LOGS
 DATABASE:
 RUN MANUALLY:
 EP_LOAD_ITEMS
 Rebuild Statistics:
 TABLESPACE
 ORA-1652: unable to extend temp segment by 128 in tablespace TEMP2
 ORA-01555:
 EBS FULL DOWNLOAD EP_LOAD SALES PATCH 14779614
 A. MDP_ADD - PurgeHistoryData
 B. Booking and Shipment History Collections
 D. EP_CHECK_ITEMS
 E. LoadHistory
 F. Hang Workflow
 Recompile invalid procedures:
 G. DM_SITE_CODE
 H. LEGACY Systems
 I. Zone Usage
 J. Mapping
 K. Maintenance
 a.) Gather Statistics
 b.) Update Synonyms:
 c.) Run Collections - Grants:
 d.) Reordering
 DUPLICATE CODE
 Cases:
 Patches:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.