EIM - Delete SR and related records
Last updated on AUGUST 28, 2017
Applies to:Siebel Enterprise Integration Manager - Version 184.108.40.206  and later
Product Release: V7 (Enterprise)
Version: 220.127.116.11 
Database: Oracle 18.104.22.168
Application Server OS: HP-UX 11i
Database Server OS: HP-UX 11i
This document was previously published as Siebel SR 38-2799742510.
Bellow is the description of the issu:
Business Requirement: As part of a DB Maintenance Policy, We need to purge old data from the biggest tables on our environment. Based on criterias defined by the bussiness team, SR and the activity related records must be purged. Adittionally It's also requested to delete Audit records. The tool choosed to do that is EIM.
We must delete some records from S_SRV_REQ the linked records in S_EVT_ACT and S_AUDIT_ITEM linked to those S_EVT_ACT records.
We deleted records from S_SRV_REQ using EIM, but the linked records in S_EVT_ACT are not deleted by default, the cascade deleting doesn�t work in that case. To do that wer're using the folowing ifb "DeleteRequerimientos.IFB". It's attached to the SR.
Could you please tell us the standar way or the workaround to:
1. Delete Activities related to SR in a Cascade Mode
2. Delete Audit Records related to activities that were deleted on point 1
The bottom line is to execute in one step point 1 and 2 in order to guarantee data integrity and reduce time to execute the job.
Please let me know if you need any other info in particular.
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