SOA Purge Hangs on PDB 19c Of SOA (Doc ID 2854257.1)

Last updated on NOVEMBER 15, 2023

Applies to:

Goal

The Oracle SOA BPL product has some problems during the following delete statement execution:

**********************************************************************************************************
DELETE FROM MEDIATOR_PAYLOAD WHERE OWNER_ID NOT IN (SELECT UNIQUE DUMMY1 FROM MEDIATOR_DEFERRED_MESSAGE UNION SELECT UNIQUE ID FROM MEDIATOR_RESEQUENCER_MESSAGE);

SQL_ID PLAN_HASH_VALUE
------------- ---------------
8kmgw4h4bjvdx 207496391
**********************************************************************************************************

The statement is executed by SOA product purge procedure.

The error occurs on PDB 19c
 

Solution

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