EIM Delete Exact shows 'NO_SUCH_RECORD' error.
Last updated on APRIL 02, 2018
Applies to:Siebel CRM - Version 220.127.116.11.8 [IP2013] and later
Information in this document applies to any platform.
When Delete Exact is processed on EIM, target records may not be deleted.
1) Set the records to be deleted on EIM_ACCNT_CUT table.
2) Run EIM job (Delete Exact) to delete records from S_ORG_INDST table.
** This EIM job consists of multiple batch to target the same table with different record combination.
Corresponding records should be deleted from S_ORG_INDST table according to the ones in EIM_ACCNT_CUT table.
Depending on the combination of the records in the first batch, records from S_ORG_INDST table may not be deleted on the batches to follow. For these records, 'NO_SUCH_RECORD' is set to IF_ROW_STAT column.
When the same combination of records are processed in a single batch job, they are deleted successfully.
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