EP_LOAD_LOCATIONS Failing In Demantra 12.2.1.4 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.

Symptoms

Customer is on 12.2.4.1 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
  executing ACTIVE_PROC_DYN('EP_LOAD_LOCATIONS')
-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

SQL> exec ACTIVE_PROC_DYN('EP_LOAD_LOCATIONS');
BEGIN ACTIVE_PROC_DYN('EP_LOAD_LOCATIONS'); END;

*
ERROR at line 1:
ORA-20002: -20003 ORA-20003: Error in ANONYMOUS BLOCK line 1
executing ACTIVE_PROC_DYN('EP_LOAD_LOCATIONS')
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

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