In recent time I have come across many queries regarding updating the user key columns in the Siebel through EIM. Lets understand what is the importance of user key in siebel eim and discuss how to update User Key using EIM.
User Key — specifies one or more columns that must contain a unique set of values. Prevents users from entering duplicate records based on the user key.
Siebel EIM identifies the unique record with the help of the user key. Thus Siebel does provide some good practice to update the user key through EIM as the user key in the heart of the Siebel EIM on which it work and updating the same user key is some where we are contradicting with the very basics of the Siebel EIM architecture on which it has been developed.
Siebel provide following EIM table to update the user keys through EIM:
To update the user key for the S_ORG_EXT table you need to use EIM_ORG_EXT_UK.
The following columns will play the role :
1) The PARTY_TYPE_CD and PARTY_UID will contain the data for the existing user key.
2) The column ORG_NAME and ORG_LOC will contain the data for the new user key which you want to update.
I have practically worked on this requirement in past and it worked good for me.
The people have some doubts about the integration_id but this column is not used in this process.
Other than these you cannot update the user key through EIM but can use many other work around through scripting , business service, sql update queries etc.
In the similar fashion you can update user for S_PARTY , S_PROD , S_PROD_INT using the tables EIM_PARTY_UK , EIM_PROD_EXT_UK, EIM_PROD_INT_UK respectively.
We will discuss more about this, please leave your queries as a commnt below.