Story

How to use MISC SQL in Siebel to set the primary foreign keys in the EIM Step 11?

MISC SQL parameter is introduced in Siebel 7 to allow EIM to set the following Primary Child Foreign Keys:

S_CONTACT.PR_OU_ADDR_ID
S_CONTACT.PR_HELD_POSTN_ID
S_ORG_EXT.PR_BL_PER_ID
S_ORG_EXT.PR_SHIP_PER_ID
S_POSTN.PR_POSTN_ADDR_ID
S_POSTN.PR_EMP_ID

The SQL can be derived <Explicit/Implicit Primary>.<Table Name>.<Column Name>
Similarly for Siebel 7 Financial Applications <Explicit/Implicit Primary>.FINS.<Table Name>.<Column Name>

For example if to set primary in Siebel 7 Horizontal for S_CONTACT.PR_HELD_POSTN_ID:

For explicit primary the parameter included in the IFB is
MISC SQL = EXPR_S_CONTACT_PR_HELD_POSTN_ID

And for similarly for Implicit Primary the parameter is
MISC SQL = IMPR_S_CONTACT_PR_HELD_POSTN_ID

Similarly for Siebel 7 Financial Applications the SQL will be EXPR_FINS_S_CONTACT_PR_HELD_POSTN_ID and IMPR_FINS_S_CONTACT_PR_HELD_POSTN_ID.

Note: When using MISC SQL in Siebel 7 to set Primary Child Foreign Keys, EIM does NOT log any transactions for mobile users. Change Request 12-BGA6EK has been raised requesting providing this information in EIM documentation and also an "ALERT 453: When using MISC SQL in Siebel 7 to set Primary Child Foreign Keys, Enterprise Integration Manager (EIM) does NOT log any transactions for mobile users" has been published