Export child records matching specific criteria by using EIM
Hello!
We are running Siebel 21.4. We have a task to export records matching the specific criteria from the intersection table S_CASE_BU. This intersection table is used to make M:M relationship between S_CASE (Case) and S_BU (Organization).
We have create the .ifb and specified following info there:
[Siebel Interface Manager]
PROCESS = ORG_EXP
[ORG_EXP]
TYPE = EXPORT
BATCH = 100
TABLE = EIM_CASE
ONLY BASE TABLES = S_CASE, S_CASE_BU
EXPORT ALL ROWS = FALSE
EXPORT MATCHES = S_CASE_BU, (CASE_ID = 'Case2')
EXPORT MATCHES = S_CASE, (ROW_ID = 'Case1')
By running the EIM the result is 2 records in the EIM_CASE table, however we expect that there would be only one, which was exported from the S_CASE, because the criteria for S_CASE_BU doesn't match.
We are running Siebel 21.4. We have a task to export records matching the specific criteria from the intersection table S_CASE_BU. This intersection table is used to make M:M relationship between S_CASE (Case) and S_BU (Organization).
We have create the .ifb and specified following info there:
[Siebel Interface Manager]
PROCESS = ORG_EXP
[ORG_EXP]
TYPE = EXPORT
BATCH = 100
TABLE = EIM_CASE
ONLY BASE TABLES = S_CASE, S_CASE_BU
EXPORT ALL ROWS = FALSE
EXPORT MATCHES = S_CASE_BU, (CASE_ID = 'Case2')
EXPORT MATCHES = S_CASE, (ROW_ID = 'Case1')
By running the EIM the result is 2 records in the EIM_CASE table, however we expect that there would be only one, which was exported from the S_CASE, because the criteria for S_CASE_BU doesn't match.
Tagged:
0