My Oracle Support Banner

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

Last updated on JANUARY 25, 2020

Applies to:

Siebel Enterprise Integration Manager - Version 7.5.2.103 SIA [15257] and later
z*OBSOLETE: Microsoft Windows 2000

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

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
Symptoms
Cause
Solution
References

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