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

Last updated on JULY 20, 2016

Applies to:

Siebel Enterprise Integration Manager - Version 7.7.2.1 [18353] and later
HP-UXItanium
Product Release: V7 (Enterprise)
Version: 7.7.2.1 [18353]
Database: Oracle 9.2.0.2
Application Server OS: HP-UX 11i
Database Server OS: HP-UX 11i

This document was previously published as Siebel SR 38-2799742510.


Symptoms

Support,
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.

Problem
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.

Question
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.

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