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 MARCH 02, 2017

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

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