Records with Attachment not Always Purged/Archived
Last updated on NOVEMBER 19, 2016
Applies to:Oracle SOA Suite - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.0 version, B2B Engine
When attempting to purge data with an attachment, in one case the record is successfully purged, but in another case the record is not purged. Furthermore, if an archive is done for the purge, the successfully purged record is not archived like records without an attachment.
The purge operation should successfully delete records with or without an attachment. Also, if an archive is performed, it should be done for records with an attachment as well.
The issue can be reproduced at will with the following steps:
1) Run purge/archive that covers a time period that includes records with an attachment.
2) If you discover some records with an attachment were not deleted, this is the primary issue.
3) Import the archived data into another database. If you do not find all records with an attachment that indeed were successfully purged, this is the secondary issue.
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