SOA 12c Auto Purge is not deleting composite instances as expected (Doc ID 2094009.1)

Last updated on MAY 01, 2017

Applies to:

Oracle SOA Suite - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Goal

SOA 12c Auto Purge is not deleting composite instances as expected.

Scheduled the Auto Purge from Enterprise Manager with the following settings:

Auto Purge Job: delete_instances_auto_job1
Job Schedule: FREQ=DAILY; BYHOUR=00;
Purge Type: Single
Retain Data: 90 Days
Maximum flows to Purge: 1000000

Old instances are still there in the database with no error showing in the logs.

Solution

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