Purge Scripts Do Not Delete Entries From <Env>_soainfra.Audit_counter Table (Doc ID 1310452.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle SOA Platform - Version: 11.1.1.3.0 and later   [Release: 11gR1 and later ]
Information in this document applies to any platform.

Symptoms

You have implemented a regular purging strategy in your environment, but you observe that the purge scripts do not delete entries from the <env>_SOAINFRA.AUDIT_COUNTER table.  You also observe that the min(CIKEY) colums is 1, which means that not all data is purged, and you may find that there is data retained since the SOA server was initially installed.

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