SOA 11g: Records are removed outside of the purging period of time

(Doc ID 2117734.1)

Last updated on OCTOBER 17, 2017

Applies to:

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


When running the purge script, some records that belong to the same ECID are removed outside of the defined purging time period.

For example, the following parameters should purge instances from 1/04/2015 to 23/01/2016


        min_creation_date => TO_DATE('1/04/2015','DD/MM/YYYY'),
        max_creation_date => TO_DATE('14:07:00 23/01/2016','HH24:MI:SS DD/MM/YYYY') ,
        batch_size => 30000,
        max_runtime => 80,
        retention_period => TO_DATE('14:07:00 23/01/2016','HH24:MI:SS DD/MM/YYYY'),
        purge_partitioned_component => false,
        composite_name => NULL,
        composite_revision => NULL,
        soa_partition_name => NULL,
        ignore_state => TRUE);

However, one instance from 27/OCT/15 is removed


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