EP_LOAD_LOCATIONS Failing In Demantra ORA-12839

(Doc ID 2034713.1)

Last updated on MARCH 08, 2017

Applies to:

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


Customer is on and mentions that the EP_LOAD_LOCATIONS procedure in EBS Full Download is failing with the following error

Customer mentioned that this working earlier and the only changes between when working and now not working is they applied the following 2 patches

Patch 18139794 (12230033)

Patch 19945449 (12240066)


After that it fails with

-20003 ORA-20003: Error in PACKAGE BODY DATA_LOAD line 4533
-12839 ORA-12839: cannot modify an object in parallel after modifying it BEGIN EP_LOAD_LOCATIONS; END;

When they run the procedure standalone from backend it gives the following error

ERROR at line 1:
ORA-12839: cannot modify an object in parallel after modifying it
ORA-06512: at "DEMANTRA.EP_LOAD_LOCATIONS", line 757
ORA-06512: at line 1

When they execute the command from sqlplus they get


ERROR at line 1:
ORA-20002: -20003 ORA-20003: Error in ANONYMOUS BLOCK line 1
ORA-06512: at "DEMANTRA.SEND_ERR_MESSAGE", line 21
ORA-06512: at "DEMANTRA.ACTIVE_PROC_DYN", line 13
ORA-06512: at line 1

They do not have any invalids related to to the data load and they even ran Gather stats but the issue persists


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