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
Related Articles:
Browse Categories
Navigation
User login
Readers who viewed this page, also viewed:
- Database Performance Considerations - Where indexes can improve performance and where not (63.6%)
- Siebel Enterprise Integration Manager - EIM Most frequently asked Interview Questions – Part 3 (63.6%)
- Real time Siebel EIM (Enterprise Integration Manager) Interview Questions – Part 1 (63.6%)
- What should be done when Enterprise Integration Manager fails with message “This is a foreign key value in the base table and the values in the interface table did not resolve to existing values”? (63.6%)
- How to Resolve Siebel EIM Errors (63.6%)
- Siebel EIM Delete Process Parameter Reference (63.6%)
- Reference to Siebel EIM Import Parameters (63.6%)
- How to use Denormalized Columns (63.6%)
- Handling Performance issues during CheckIn / CheckOut Process (54.5%)
- How to Troubleshoot Database Errors Caused by Deleting Repositories using Siebel Tools (54.5%)
