Error during Demantra Collections/Troubleshooting Ep_check_xxx and Ep_load_xxx procedures ORA-01858 ORA-20002 ORA-06512

(Doc ID 605446.1)

Last updated on MARCH 28, 2016

Applies to:

Oracle Demantra Demand Management - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Oracle Demantra Demand Management - Version 5.3.6 and later
Information in this document applies to any platform.
***Checked for relevance on 20-Feb-2012***


Symptoms

Note that while this error occured during the ep_check_location procedure, this note can also be used as a roadmap for troubleshooting the following procedures:

ep_check_items

ep_load_items

ep_check_location

ep_load_location

ep_load_sales

mdp_add

On 11.5.10.2 in Production:
When attempting to run the Demantra data load profile, an error occurs during the ep_check_location procedure

ERROR
Error in PACKAGE BODY DATA_LOAD line 2070
executing ACTIVE_PROC_DYN('EP_CHECK_LOCATION('A')')

STEPS
The issue can be reproduced at will with the following steps:
1.Run the Demantra Collections profile from EBS


BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users can not load new and changed locations to the Demantra schema.

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