EIM DOCUMENTS

FILE MAKER--->TMP TABLES --->WRITE SP’S--->EIM --->BASE TABLES

GROUPS:

Purpose: To displaying ‘DEPENDENTS’ in the User Interface.

Source:  We are getting source data from FILE MAKER database and extracted with tab format.

Import the tab format data into ‘tmp_tables’ by using DTS process.

Siebel EIM: By using ‘stored procedures’ imported the data into interface tables.

Base Tables: By using EIM component imported   into the following base tables

S_PARTY

S_PARTY_PER

S_ORG_GROUP

S_GROUP_BU

S_GRUOP_CONTACT

S_ORGGRP_POSTN

While importing the data into base tables we faced following problems.

1. Data is not visible in the User Interface.
2. Data is not loaded into the  S_GROUP_CONTACT(EIM status partially imported)
3. LOV’s type not matched.

Solutions:

1. We need to import the data into position base table (S_ORGGRP_POSTN) and then data is available in the UI.
2. Initially we need load the ‘Group Contact  ’ batches

(S_PARTY

S_PARTY_PER

S_ORG_GROUP

S_GROUP_BU

S_GRUOP_CONTACT

S_ORGGRP_POSTN),

Next we need load Contact Dependents data into

(S_PARTY

 S_CONTACT

 S_POSTN_CON)

And finally the Group dependents load into

(S_PARTY

S_PARTY_PER

S_ORG_GROUP

S_GROUP_BU

S_GRUOP_CONTACT

S_ORGGRP_POSTN).

We need to change the .IFB parameters for reloading into S_GROUP_CONTACT = true and rest of the base tables INSERT/UPDATE =false

    3. Siebel LOV’s are not matched with customer’s LOV values, and changed LOV’s in the stored procedures.

CONTACTS:

Purpose: To display the ‘CONTACTS’ in the User Interface.

Source:  We are getting source data from FILE MAKER database extracted with tab format.

Import the tab format data into ‘tmp_tables’ by using DTS process.

Siebel EIM: By using ‘stored procedures’ imported the data into interface tables.

Base Tables: By using EIM component imported   into the following base tables

S_PARTY

S_CONTACT

S_CONTACT_BU

S_POSTN_CON

S_ADDR_PER

While importing the data into base tables we faced following problems.

1. Data is not visible in the User Interface.
2. We have loaded the data into base tables using ‘PC_POSTN_LOC’ it is a foreign key column for S_CONTACT as ‘internal. EIM status field is displayed as ‘Partialy_Imported’
3. Contacts are displayed without address. (Because of we have loaded the address into base table using separate EIM component.)

Solutions:

1. We need to import the data into position base table (S_POSTN_CON) and then data is available in the UI.
2. Next we have loaded the data into base tables using ‘PC_POSTN_LOC’ as ‘INTERNAL’.
3. To display Contact address we have executed only single EIM component.

ORDER:

Purpose: To display the ‘ORDER’ in the User Interface.

Source:  We are getting source data from FILE MAKER database extracted with tab format.

Import the tab format data into ‘tmp_tables’ by using DTS process.

Siebel EIM: By using ‘stored procedures’ imported the data into interface tables.

Base Tables: By using EIM component imported   into the following base tables

S_ORDER

S_ORDER_BU

S_ORDER_POSTN

While importing the data into base tables we faced following problems.

1. Data is not visible in the User Interface.
2. We have loaded the data into base tables (S_ORDER), EIM status field is displayed as ‘Partialy_Imported’
3. EIM status field is displayed as ‘Required Cols’ missing (We forget the APPROVED_FLG column value).

Solutions:

1. We need to import the data into position base table (S_POSTN_CON) and then data is available in the UI.
2. We have loaded data into base tables but we forget to load the required columns data into S_ORDER_POSTN base table (PAY_ELIGIBLE_FLG=’Y’, QUOTA_ALLOC_PCT=100, START_DT=getdate()).
3. While loading the data into S_ORDER base table we need to populate the data for APPROVED_FLG= ‘Y’.

ORDER ITEMS:

Purpose: To display the ‘ORDER ITEMS’ in the User Interface.

Source:  We are getting source data from FILE MAKER database extracted with tab format.

Import the tab format data into ‘tmp_tables’ by using DTS process.

Siebel EIM: By using ‘stored procedures’ imported the data into interface tables.

Base Tables: By using EIM component imported   into the following base table

S_ORDER_ITEM