Siebel EIM

How are CREATED and CREATED_BY columns populated using EIM?

In standard Siebel applications, ‘CREATED’ and ‘CREATED_BY’ are system columns that will be automatically populated when importing data via EIM.

How can I tune my EIM batches to improve performance?

Here are some options that can be tried to improve Enterprise Integration Manager (EIM) performance:

Check to make sure all the standard indices are in existence for the tables involved.

Why are imported accounts not visible in Siebel 7 after the successful import using Enterprise Integration Manager

The account data need to be imported into S_PARTY, S_ORG_EXT, S_ACCNT_POSTN, and S_ORG_BU among other relevant tables. S_ORG_BU is a new table in Siebel 7 and must be populated for visibility in the "All Accounts" view.


How do I populate the PR_PROD_LN_ID column in the S_PROD_INT base table

Complete the following procedure:

 To populate the PR_PROD_LN_ID column in the S_PROD_INT base table

Populate the S_PROD_INT base table using the EIM_PROD_INT interface table.

EIM Data Loading : Oracle function - Bulk Collect

When loading data through EIM process, we normally use Pl/SQL procedures to fetch and process huge volume of records and  then load the data to EIM Interface tables.

EIM Tuning to improve performance

Through EIM process we load bulk amount of data from an external system to Siebel base tables. The performance of these EIM jobs has to be maintained at optimum levels in order to reduce the load on the Siebel application and database servers.

How to Populate User Keys and Required Columns using Siebel EIM

It is mandatory to load the required columns of the base tables. If one or more required fields are missed, then the EIM process will fail to load the base table and generate the REQUIRED_COLS error status.


Subscribe to Siebel EIM