EIM Misleading IF_ROW_STAT
Last updated on MAY 22, 2017
Applies to:Siebel Enterprise Integration Manager - Version 22.214.171.124  to 8.2.2 SIA [Release V7 to V8]
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: 126.96.36.199 
Database: Oracle 188.8.131.52
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.
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