My Oracle Support Banner

EIM Delete Exact shows 'NO_SUCH_RECORD' error. (Doc ID 2038556.1)

Last updated on JULY 03, 2023

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.


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.