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

@Arijit Saikia 

Thank you for marking my response as helpful.

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

Thanks @Ankur Bawiskar How do I check the linkage between the user record and cost center., i.e in my instance where do I check how user record is populated with the cost center from the cmn_cost_center table.

@Arijit Saikia 

sys_user table is not audited. you need to know how User records are created.

You can check if any LDAP is loading the user along with cost center

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