EIM Misleading IF_ROW_STAT
(Doc ID 479964.1)
Last updated on NOVEMBER 27, 2019
Applies to:Siebel Enterprise Integration Manager - Version 188.8.131.52  to 8.2.2 SIA [Release V7 to V8]
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: 184.108.40.206 
Database: Oracle 220.127.116.11
Application Server OS: IBM AIX 5L 5.1
Database Server OS: IBM AIX 5L 5.1
This document was previously published as Siebel SR 38-1141621501.
””Checked for Relevance on 21-DEC-2015””
The scenario that i'm facing currently is that i'm trying to import records into S_ASSET_X. I have 89 records to be imported in which 31 records doesn't exist in S_ASSET. The remaining 58 records are valid records which must be imported into S_ASSET_X. The end result is that i'm getting the IF_ROW_STAT as ROLLBACK for all the 89 records. I'm seeking a method to identify via the EIM table which records are genuiely Rollback and which are actually Imported. I believe we can construct an SQL using some of T-columns to uniquely identify ROLLBACK reocrds, IMPORTED records and DUPLICATE records, etc.
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