SOA 11g: Records are removed outside of the purging period of time (Doc ID 2117734.1)

Last updated on MARCH 17, 2016

Applies to:

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

Symptoms

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

 

  soa.delete_instances(
        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

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