My Oracle Support Banner

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

Last updated on SEPTEMBER 27, 2018

Applies to:

Oracle SOA Suite - Version 11.1.1.4.0 to 11.1.1.9.0 [Release 11gR1 to 11g]
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

To view full details, 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 a vibrant support community of peers and Oracle experts.