EIM Delete Exact shows 'NO_SUCH_RECORD' error.

(Doc ID 2038556.1)

Last updated on AUGUST 10, 2015

Applies to:

Siebel CRM - Version [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.

<Expected behavior>
Corresponding records should be deleted from S_ORG_INDST table according to the ones in EIM_ACCNT_CUT table.

<Actual behavior>
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