EIM ORDER EXPORT FILTER: MATCHES with a Siebel extension table of any target base table
Last updated on MARCH 13, 2018
Applies to:Siebel Enterprise Integration Manager - Version 126.96.36.199 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (MidMarket)
Version: 188.8.131.52  MME
Database: Oracle 184.108.40.206
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.
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')
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