EIM ORDER EXPORT FILTER: MATCHES with a Siebel extension table of any target base table (Doc ID 511992.1)

Last updated on OCTOBER 12, 2016

Applies to:

Siebel Enterprise Integration Manager - Version 7.5.2.103 SIA [15257] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (MidMarket)
Version: 7.5.2.211 [16061] MME
Database: Oracle 9.2.0.2
Application Server OS: Microsoft Windows 2000 Advanced Server
Database Server OS: Microsoft Windows 2000 Advanced Server

This document was previously published as Siebel SR 38-1186130641.
***Checked for relevance on ***23-Feb-2015***


Symptoms

We are trying to export via EIM only those orders details which have a certain value for the ATTRIB_07.
We use the EXPORT ALL ROWS = FALSE and EXPORT MATCHES statements to indicate these constraints, but the EIM process seems to ignore them.

Attached you will find the .ifb file and an XLS file with the exported EIM_ORDER_ITEM table. Can you please tell us where are we making mistakes?

[EXPORT Order Headers EXTENSIONS]

      TYPE = EXPORT
      BATCH = 1000
      TABLE = EIM_ORDER_DTL
      ONLY BASE TABLES = S_ORDER, S_ORDER_X
      EXPORT ALL ROWS = FALSE
      EXPORT MATCHES = S_ORDER_X, (ATTRIB_07 = 'New Product' OR ATTRIB_07 = 'RAT')

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