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.

 

If using Siebel Industry Solutions version 7.0.x (SIS) or Siebel Industry Applications version 7.5.x (SIA), there is no mapping in the EIM_ACCNT_CUT interface table to the S_ORG_BU table. However EIM_ACCOUNT and EIM_ORG_BU interface tables are mapped to S_ORG_BU. EIM_ACCOUNT or EIM_ORG_BU can be used to populate S_ORG_BU.

 

In SIS and SIA, MASTER_OU_ID in S_ORG_EXT must be populated for visibility in any of the Accounts view. If S_ORG_EXT.MASTER_OU_ID were not populated, the imported accounts would only be visible in Site Map > Data Administration >Accounts/Orgs view.

 

The imported accounts will not be visible in
Site Map > Data Administration >Accounts view or any other view including 'My Accounts', 'All Accounts', and 'All Accounts Across Organizations'. The column S_ORG_EXT.MASTER_OU_ID is not marked as a required column in SIS or SIA Interface Tables Reference (version 7). Change Request 12-B82K5U has been logged to enhance the documentation to reflect that MASTER_OU_ID is a required column in S_ORG_EXT for visibility in SIS and SIA.

Tags