EIM Misleading IF_ROW_STAT (Doc ID 479964.1)

Last updated on MAY 22, 2017

Applies to:

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

Symptoms

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.

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