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 DECEMBER 04, 2019
Applies to:Oracle Demantra Demand Management - Version 184.108.40.206 to 220.127.116.11 [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***
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:
On 18.104.22.168 in Production:
When attempting to run the Demantra data load profile, an error occurs during the ep_check_location procedure
Error in PACKAGE BODY DATA_LOAD line 2070
The issue can be reproduced at will with the following steps:
1.Run the Demantra Collections profile from EBS
The issue has the following business impact:
Due to this issue, users can not load new and changed locations to the Demantra schema.
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