- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-17-2025 11:23 PM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-17-2025 11:35 PM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2025 01:28 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2025 12:33 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2025 12:36 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2025 12:58 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader