EIM Contact does not update PR_OU_ADDR_ID error SBL-EIM-00425
Last updated on MARCH 30, 2017
Applies to:Siebel Enterprise Integration Manager - Version 184.108.40.206  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 220.127.116.11 
Database: Oracle 18.104.22.168
Application Server OS: Microsoft Windows 2000 Server SP 3
Database Server OS: Sun Solaris 5.6
This document was previously published as Siebel SR 38-1202064501.
***Checked for relevance on 14-May-2014***
""CHECKED FOR RELEVANCE ON 26-OCT-2015""
I’m trying to resolve pr_ou_addr_id for our contact records. I have attached my import and export ifb files. I have no problem exporting the records, but when I try to import them back I get the following error:
Process [Contacts] had all rows fail
EIM_CONTACT2 for batch 1976:
Import processing failed for all rows. (severity 3)
All rows specified for importing in this process failed. Either no rows were specified or all rows could not be imported into the base tables.
All rows failed to be processed for this interface table. Either the data in the rows is invalid for import or row specifications did not match any existing base table rows for export, delete or merge.
(compmain.cpp 16(1554) err=100425 sys=0) EIM-00425: All rows in interface table failed.
(smisched.cpp 17(820) err=100425 sys=0) EIM-00425: All rows in interface table failed.
I have been using the following sql to resolve bu id’s
update EIM_CONTACT2 set
CHRC_CALL_LST_BI = (select min(OI.ROW_ID) from S_BU OI where OI.NAME = CHRC_CALL_LST_BU)
,CONPRD_ACCNT_BI = (select min(OI.ROW_ID) from S_BU OI where OI.NAME = CONPRD_ACCNT_BU)
,CON_BI = (select min(OI.ROW_ID) from S_BU OI where OI.NAME = CON_BU)
,CON_CAMP_SRC_BI = (select min(OI.ROW_ID) from S_BU OI where OI.NAME = CON_CAMP_SRC_BU)
,CON_LSTCMPWVSRC_BI = (select min(OI.ROW_ID) from S_BU OI where OI.NAME = CON_LSTCMPWVSRC_BU) ...
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms