My Oracle Support Banner

EIM Misleading IF_ROW_STAT (Doc ID 479964.1)

Last updated on NOVEMBER 27, 2019

Applies to:

Siebel Enterprise Integration Manager - Version [15252] to 8.2.2 SIA[22320] [Release V7 to V8]
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: [15252]
Database: Oracle
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.