EIM Imported employees not shown in User Interface and S_CONTACT.BU_ID being set to 'No Match Row id'
Last updated on JUNE 04, 2017
Applies to:Siebel Enterprise Integration Manager - Version 22.214.171.124  and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 126.96.36.199 
Database: Oracle 188.8.131.52
Application Server OS: Sun Solaris 5.6
Database Server OS: Sun Solaris 5.6
We are loading employees into ERM.
We changed the default Organization to CISCO.
The first problem we have is that the organization fields in the employee administration view>employees does not show in the app. every thing else get loaded in the following sequence
2-Position with pr_emp_id(using miscsql)
3-employee with pr_held_postn_id, pr_resp_id(using miscsql)
everything get set properly except that particular field.
When we query the s_contact table it shows "No Match Row id' in the Bu_ID column. When we look at the eim_employee table con_bi get resolved properly '0-R9NH'(con_bu being set to CISCO.
The division is set to CISCO but the organization is empty.
This behavior is particularly strange because we use the same exact mapping than in the score project (7.5.1) and the Organization was not a problem.
In another hand
We want the Employees to show in the following views:
All Employees across Organizations
All Contacts across Organizations
The question is what flag/ tables should be populated for that to happen:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms