My Oracle Support Banner

EIM - Delete SR and related records (Doc ID 505637.1)

Last updated on MARCH 01, 2019

Applies to:

Siebel Enterprise Integration Manager - Version [18353] and later
Product Release: V7 (Enterprise)
Version: [18353]
Database: Oracle
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.


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.