My Oracle Support Banner

Running MDP_ADD Procedure Errors With Multiple Errors After Patch 6375504 Any Are Possible ORA-20002 ORA-20003 ORA-06512 ORA-12801 ORA-00018 (Doc ID 458146.1)

Last updated on AUGUST 19, 2019

Applies to:

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


On 7.1.1 in Test with 11.5.10 EBS:
When attempting to run the MDP_ADD procedure after applying Demantra 7.1.1 CU1 ( patch
6375504, the following error occurs:

ORA-20002: ORA-20003:
Error in PROCEDURE MDP_ADD line 571
executing ACTIVE_PROC_DYN('dynamic_mdp_add')
ORA-06512: at "CRP2.SEND_ERR_MESSAGE", line 21
ORA-06512: at "CRP2.ACTIVE_PROC_DYN", line 13
ORA-06512: at "CRP2.MDP_ADD", line 571
ORA-06512: at line 1

To pinpoint where the error was, the user ran the dynamic_mdp_add procedure and the following
error occurred:

ORA-12801: error signaled in parallel query server P055
ORA-00018: maximum number of sessions exceeded
ORA-06512: at "CRP2.DYNAMIC_MDP_ADD", line 19
ORA-06512: at line 1

The issue can be reproduced at will with the following steps:
1. Apply Demantra 7.1.1 CU1 patch 6375504
2. Run the MDP_ADD procedure
3. Run the DYNAMIC_MDP_ADD Procedure


Applied Demantra 7.1.1 CU1 patch 6375504


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

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