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 8.1.1.11.8 [IP2013] and later
Information in this document applies to any platform.

Symptoms

<Issue>
When Delete Exact is processed on EIM, target records may not be deleted.

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

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.