The Siebel EIM group is a forum where peers share technical expertise, solve problems, and discuss issues related to Siebel Enterprise Incentive Management (EIM), also referred to as Incentive Compensation Management.

This kind data i am having. After importing accounts using EIM, all of
these accounts are not imported. Instead only the first one is imported
and for the other 2 records IF_ROW_STAT column showing
"DUP_RECORD_IN_EIM_TBL".
=46rom the above data it is very clear that the accont name is same but
they are in different locations. We are treating these accounts as
different records considering unique key on (NAME,CITY,STATE). What I
want is to import all such kind of accounts which are having the same
name but in different location.

First of all I want to know is it possible to import these kind of
accounts? If it is, then how?. As per my knowledge it should allow the
import of all the UNIQUE records with respect to NAME and
LOC(City,state).

Can anyone give their valuable suggestions on this.

Also I have to import categories(Attributes) for each account. Can
anybody suggest how to do this?

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.

have to import categories(Attributes) for each account. Can anybody suggest how

to do this?</SPAN><br />
<br />
</DIV>
This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
</BODY></HTML>

Can you show us the values in the EIM table?
=0D
As a general advise, the IF_ROW_STAT only gives very high level insight
into what exactly is going on=2E Please use the trace and error flags and
read the log for a more verbose error message=2E
=0D
As for categories, what is the base table that you want to populate?
That is where it all starts=2E
=0D
Ji Yong

Hi,
it shouldn't a problem to load accounts with multiple addresses. Please check the user key fields for the records and make sure those values are not same for all the records. Please publish rest of the sample data like values ur inputting for con_bu, row_id, etc.

The above data shows me that the IF_ROW_STAT=3DIMPORTED. where as it is
imported but i could not find the seperate record on its name in the
database. What it was doing is it is importing only address part of that
record and attaching it to the account which is already there. For
example in the above data we have got 4 records 2 of each with same
account name but in different LOC. when I import these account only the
first reacord of the above two pairs is imported and the second record's
address is attached to the first record . So when I c through the GUI it
is showing me account name with only one "SITE" and with 2 different
addresses. where as my intension was to c the both records as

Am I doing any wrong OR it is not possible to import the accounts with
same name with different location& address.

Coming to my second question: I am using the EIM_ACCOUNT1 table for
the import of Account Categories.
here is the description
TABLE =3D EIM_ACCOUNT1
INSERT ROWS =3D S_PARTY, FALSE
ONLY BASE TABLES =3D S_PARTY, S_ACCNT_CHRCTR.
But I really dont have idea how to do it furher.

I think your problems comes from PARTY_UID=2E
=0D
I still suggest you run your tasks with trace and error flags and read
the log=2E
=0D
It might also help to use the UPDATE ROWS and INSERT ROWS switches in
the IFB to further pin down your problem=2E
=0D
Your problem with Account Categories should be visible in the log too=2E
=0D
Ji Yong

My experience in importing accounts with the same name but different locations is that you need to do the following:

1=2E If the account/loc combinations do not have their own unique account codes, create a unique account code by concatenating the account name and loc=2E For example: if you have three accounts named Citibank, one each in New York, London, and Tokyo, you would create the following three unique account codes: Citibank New York, Citibank London, Citibank Tokyo=2E If the data you are importing already has separate and unique account codes for Citibank New York vs=2E Citibank London vs=2E Citibank Tokyo, then you can use those account codes instead=2E

2=2E Populate the unique account codes into both the PARTY_UID field and the OU_NUM field in EIM_ACCOUNT

3=2E Populate the company name into the NAME field and populate the Loc in to the LOC field=2E