XML_DOCUMENT_REF Table is not Purged when the Looped or Parallel Purge Script is Run in an Upgraded 11.1.1.5 or 11.1.1.4.0 Oracle SOA Suite Environment (Doc ID 1342207.1)

Last updated on AUGUST 21, 2013

Applies to:

Oracle SOA Platform - Version 11.1.1.4.0 to 11.1.1.5.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

When you run the looped or parallel purge script in an Oracle SOA Suite 11.1.1.5.0 or 11.1.1.4.0 environment that was upgraded from 11.1.1.3.0, the XML_DOCUMENT_REF table is not purged.
For example, assume you perform the following steps:

  1. Upgrade an 11.1.1.3.0 Oracle SOA Suite environment with initiated instances to version 11.1.1.5.0 and create additional instances of all SOA composite applications.
  2. Run the following scripts in your 11.1.1.5.0 environment:
    soa_purge_scripts.sql
    common/debug_on.sql
  3. Check the records in the XML_DOCUMENT_REF table.
  4. Run the looped or parallel purge script and recheck the XML_DOCUMENT_REF table.
    Note that the XML_DOCUMENT_REF table has not been purged.

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