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

Last updated on FEBRUARY 28, 2023

Applies to:

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

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