My Oracle Support Banner

EIM unable to update records in S_OPTY as PR_DEPT_OU_ID is set to 'No Match Row Id' (Doc ID 1326147.1)

Last updated on AUGUST 17, 2018

Applies to:

Siebel Enterprise Integration Manager - Version 8.1.1.1 SIA [21211] and later
Information in this document applies to any platform.
***Checked for relevance on 10-Nov-2014***

Symptoms

Navigate to Contact Screen -> Opportunity view -> Create a new Opportunity -> without an Account associated to it, then the S_OPTY.PR_DEPT_OU_ID is populated with "No Match Row Id".

When EIM is run to update the existing record, a new record is being inserted instead of updating the existing record.

Following is the SQL Statement from detailed EIM log that is used to match the userkey:

EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 * [ImportOpty] batch 100, step 5, pass 139: locate by user key
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 * (started at 11/23/10 1:32)
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 */

EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 UPDATE dbo.EIM_OPTY_DTL
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 SET T_OPTY__RID =
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 (SELECT MIN(BT.ROW_ID)
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 FROM dbo.S_OPTY BT
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 WHERE (BT.NAME = IT.OPTY_NAME AND
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 BT.BU_ID = IT.T_OPTY_BU_ID AND
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 (BT.PR_DEPT_OU_ID = IT.T_OPTY_PRDEPT OR
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 (BT.PR_DEPT_OU_ID IS NULL AND IT.T_OPTY_PRDEPT IS NULL))))
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 FROM dbo.EIM_OPTY_DTL IT
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 WHERE (OPTY_NAME IS NOT NULL AND
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 T_OPTY_BU_ID IS NOT NULL AND
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 IF_ROW_BATCH_NUM = ? AND
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 IF_ROW_STAT_NUM = 0 AND
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 T_OPTY__STA = 0)

EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 ?1: 100
EIMSQL EIMSQLSubEvent 4 000000084ce31444:0 2010-11-23 01:32:17 go

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.