Using EIM to delete all Accounts
(Doc ID 502542.1)
Last updated on JUNE 12, 2024
Applies to:
Siebel Enterprise Integration Manager - Version 7.0.4 SIS [14068] and laterz*OBSOLETE: Microsoft Windows 2000
Version: 7.0.3 [14010]
Database: Microsoft SQL Server 2000 SP 2
Application Server OS: Microsoft Windows 2000 Server SP 2
Database Server OS: Microsoft Windows 2000 Server SP 2
Symptoms
We are using the following EIM to delete all the accounts in Test. I do not want to delete the S_PARTY table in the process. We came up with this tag:
[Delete Account Data]
TYPE = DELETE
BATCH = 1 - 15
TABLE = EIM_ACCOUNT
ONLY BASE TABLES = S_PARTY, S_ORG_EXT, S_ACCNT_POSTN, S_ADDR_ORG
DELETE ROWS = S_PARTY, FALSE
DELETE MATCHES = S_ORG_EXT, (LAST_UPD < '2002-03-20 23:59:09.000')
The problem we are having is that all the records in the S_POSTN get deleted even though we do not specify that table in the EIM tag. This is causing a lot of problems because we have to restore the database every time we decide to delete all the account records. Can you tell us why is this happening?
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |