Siebel Unleashed

That was nice Shalini and not only that every interface table can have more than one base table assigned to it or should I say supports group of base table, an interface table is an extended table for the base table where any changes should be made, siebel(ORACLE) would be very reluctant to allow any changes to be made to its properitery tables(base tables) hence the interface tables.
Every interface table has a primary table assigned to it apart from other base tables.
Two of the important functional enhancements of EIM, explicit primary mappings
and full multiple-organization visibility support, were introduced with this version and are
available only by way of these interface tables. The EIM_ tables are the only interface tables that
new customers should use. Customers who are upgrading from prior versions should transition to
this new family of interface tables as soon as possible.

EIM is fun and exposes you to lot of table mapping between the Interface and base tables. In my 5 yrs of Siebel exp, I still am learining EIM.

Goodluck to you all.

cheers

dpfromcanberra

That is intresting piece of information even for me but as I have not worked on EIM so everything is new related to that.

Do you mind if I put your comment as a post with your credentials ofcourse.

Hi Neel,yeh you can, no worries, its knowledge and it has to be shared so go ahead and publish it,I will try to contribute as much as possible.
cheers
dpfromcanberra

[...] Siebel EIM [...]

Hi Neel
I am impressed by ur site, hardly can find only few site dedicated to siebel. CHEERS!!!!
I need contact email of any expert you know of EIM as i am new to it and want to know about it.

It will be easy for me contacting him/her rather than endlessly reading the documentation.

Awaiting your reply.

Harish.

Hi Harish,

Can you share your queries, we will try to respond soon.

Thanks
Shalini Chauhan

How long would you expect to take to load 8 million contacts with 1 to 3 addresses (average 1.2 per contact) one position, organization. Siebel 8.0, Oracle. Exact hardware is unknown so far
How would you organize(split) IFB tasks to be most efficient. Should I consider creating of some temporary indexes? Thank you for your opinions. Jirka

I am curious, is EIM included in Siebel Public Base?

Can we load products onto S_PROD_INT via EIM,without following a process of locking the product ? & along with that are we even suppose to mention the S_VOD table.As S_VOD to holds the ref to S_PROD_INT.
PL clarify!!

This is my understanding of the process and my experience: I used the business service (ISS Authoring Import Export Service) to release products once they are loaded into s_prod_int from eim table(eim_prod_int). Once the Business service is run records are created in s_vod ,s_vod_ver and s_iss_obj_def by the method Post_Eim_Upgrade. I dont understand the locking mechanism is it mandatory?

Harish if i understood u clearly…u meant that via EIM load u loaded the prods in S_Prod_int table …& later on via the BS mentioned by you,it helped to release the products…n with the release it got its instnace captured in S-vod,S_vod_ver & S_iss_obj_def too…correct me if not…

if suppose consider the same case n without using the BS,if i take up the lastversion of the product i.e’999999999′..& do a direct load via EIM…would the prods still become available ??

Hi Shalini/Neel

I’m new to EIM. I have 1 Query with EIM Import Process. while i’m loading Contacts, the import is failing at s_contact_bu.

I have also checked the T_ columns in EIM_Contact table, except T_contact_bu_sta, every thing is fine.

Could you please suggest how we can proceed our investigation.

Thanks
Vivek Varma

hi Vivek,
can u please post the exact error u r geeting by looking into the log file.
that will be helpful in resolving ur issue.

Thanks.

Hi Manish,

The Issue is due to multiple records with different conflict id’s in s_contact_bu table.
I have tried with one record after detleting the record with row_id=Conflict_id in s_contact_bu table. it worked fine.

But siebel support recommended to delete such records using vb script.

Thanks
Vivek

Hi Vivek,

I would like to throw some light on your problem. If there are more than one row in the base table that have same user key but different conflictIDs, EIM cannot distinguish such rows. To overcome it First you have to remove all duplicate rows from Base table, only then the EIM process can succeed.

Please let us know if you further face any problem. :-)

Thanks
Shells

hI,

Is there any way to run EIM job from external system(java)? or can we run EIM using Business Service?

Hi Jimit,

Case 1: Yes we can run any EIM job except Application interface. For that, you must have server access credentials and then using dos prompt/command prompt, you can give command which can run the EIM job. You can also pass the several parameters(ifb file name, log file directory, flag values, etc.) in that command which we used to provide while doing through Application.

Case 2: I have never tried running any EIM job through Business Service. But I think we can create a record for that BC and invoke the ‘Start’/'Submit Job’ button method. Which can possibly do the task.

Note: the IFB file must be properly placed on to server directory before any of the above operations.

hey do let me know your findings too :-)

Thanks
Shells

I am interested to work on EIM. I am New to EIM process. Can any one tell me the detail steps with data mapping sheet and sample data,
” How to load the Legacy Account data
into the Siebel Base table.”

Thanks in Advance, For speding ur valuable time. My mail id is tmr.net[at]gmail.com.

Bye,
Mohan.

Dear Friends,

I am pavani Sripada, working as a talent manager in TMI network, Hyderabad. I am currently looking for people in Siebel pracitce. I have requirement for EIM,EI, Siebel analytics with Oracle and Siebel Configuration. Please refer your friends, Colleagues who are looking for better opportunities. This is with world class MNC and the locations are for Mumbai & Hyd

Thanking you in advance.

Regards
Pavani Sripada
Talent Manager
TMI Network,
Hyderabad
Phone: 66385903

We specialize in key IT talent practice areas - Telecom , Infra services, BFS , Travel and Retail, Hitech, Manufacturing and Embedded technologies.
We focus on Niche and strategic hire.visit us at www[dot]tminetwork[dot]com
“Relationships beyond careers”.