My Oracle Support Banner

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

Last updated on JANUARY 13, 2020

Applies to:

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.