Sys User record shows blank cost center value

Arijit Saikia
Tera Contributor

In the user record, the Cost Center field is blank. When I check the XML record, it has a Cost Center Display value (not sys id), but when I check the cmn_cost_center table the value (in the code field) the Cost Center is not present. 

 

Any suggestions, please.

2 ACCEPTED SOLUTIONS

Ankur Bawiskar
Tera Patron
Tera Patron

@Arijit Saikia 

it's a data setup issue.

Seems that cost center got deleted but it didn't reflect on sys_user record

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

Hello @Arijit Saikia 

See for all client instance user record data population happens in different style it can happen through LDAP/AD/Workday/Sailpoint integration.

Now I am not sure how it's happening on your instance so first identify same then check when user records are created how cost center data is populated is it while creation or is there any other business logic kept in which populate this data. Once you have this information then try to check when this cost center data is created what all details come in then try to create missing record information manually or if possible try to get data from thirdparty if any integration is in place. Now once this data is available then you identify which records are affected and try to update them all before doing an update try to do on 3-4 records once you are confident proceed with bulk affected records.

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

 

Thanks & Regards
Viraj Hudlikar.

View solution in original post

7 REPLIES 7

Viraj Hudlikar
Tera Sage

Hello @Arijit Saikia 

You need to check whether any update for cost center record was done? Try to check in lower instance and try to retrieve the cost center record and see if showcase on user record. Is this happening for one cost center record or for all? It seems mostly data integrity issue so you need to check as this is instance specific.

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

 

Thanks & Regards
Viraj Hudlikar.

Thanks Viraj, it is happening to multiple user records. How do I check the linkage between the user record and cost center. Thanks

Hello @Arijit Saikia 

See for all client instance user record data population happens in different style it can happen through LDAP/AD/Workday/Sailpoint integration.

Now I am not sure how it's happening on your instance so first identify same then check when user records are created how cost center data is populated is it while creation or is there any other business logic kept in which populate this data. Once you have this information then try to check when this cost center data is created what all details come in then try to create missing record information manually or if possible try to get data from thirdparty if any integration is in place. Now once this data is available then you identify which records are affected and try to update them all before doing an update try to do on 3-4 records once you are confident proceed with bulk affected records.

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

 

Thanks & Regards
Viraj Hudlikar.

Ankur Bawiskar
Tera Patron
Tera Patron

@Arijit Saikia 

it's a data setup issue.

Seems that cost center got deleted but it didn't reflect on sys_user record

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader