How To Use MISC SQL In Siebel To Set The Primary Foreign Keys In The EIM Step 11?

9 February 2025

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 .

.

Similarly for Siebel 7 Financial Applications .FINS.
.

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

Tags