Updating User Key Through EIM

12 November 2009 6,766 views 7 Comments

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:

EIM_ORG_EXT_UK
EIM_PARTY_UK
EIM_PROD_EXT_UK
EIM_PROD_INT_UK

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.

Readers who viewed this page, also viewed:

(2 votes, average: 2.00 out of 5)

Loading ...

7 Comments »

Kirill said:

Well, more complicated case: how to create a User Key for a custom table? How to create a new EIM table to load only that custom table? What about case-insensitive fields and EIM?
Those are good questions, aren’t thay?

# 6 December 2009 at 4:29 pm

Siebel EIM said:

In case of updating S_ORG_EXT.NAME, we can populate PARTY_TYPE_CD and PARTY_UID with existing value and others with new value.

Mandeep, How do you suggest to populate EIM_PROD_INT_UK to update the S_PROD_INT.NAME. Appreciate your early response.

# 22 April 2010 at 5:46 pm

Rishi said:

I can try now updating the user keys of Org_EXT records. What about the Product table S_PROD_INT which columns are used to update the use key of this table ?

# 2 August 2010 at 5:11 pm

ayush Panwar said:

What is the user key for an EIM table? Its urgent.Please reply soon.

# 25 August 2010 at 3:36 pm

Muralidhar said:

Hi,
In order to update User Key for S_PROD_INT, i guess we need to populate the Integration Id. EIM will take the Integration Id as reference and then update the user keys. For S_PROD_INT, Name, BU_ID and VENDOR_OU_ID are the user keys. Hence it will identify the record based on Integration Id.
Please correct me if i'm wrong in this. I'm yet to verify on the correctness. I'm trying it out in the dev environment today. Will update if i was able to succeed.
Note: If you do not have Integration Id populated with any value(as in our case) I guess you can populate it with the row_id of the record and then process!
Murali

# 8 September 2010 at 12:14 pm

mahesh said:

hi can u tell clearly how to update and remaining table userkeys how to update pls tell
thank you

# 23 March 2011 at 11:54 pm

Michle said:

Hi
Can you tell me what should I do to update BU_ID column in S_SRV_REQ table. What user key I should I select.

# 8 October 2011 at 12:18 pm

Leave your response!

Most Commented

Most Viewed

Siebel High Interactivity Framework - 82,802 views
Siebel Pricing – Component Based Pricing - 74,343 views
Siebel Interview Questions - 45,628 views
Siebel Standard Interactivity & High Interactivity - 39,945 views
Business Component User Properties - 23,020 views