Locations table (cmn_locations) updated from Users (sys_user)

sgmartin
Kilo Guru

About a year and a half ago we started using LDAP to provision and update all of our users from Active Directory.  We have the Locations table (cmn_locations) where all of our Datacenters and field offices are store.  What we recently discovered was that when LDAP provisioned a new user, their location was added to the cmn_locations table.  So, if someone fat-fingered the city, a new record would be inserted with that invalid city name.  We don't really want the location information from the sys_user table to update the cmn_locations table, but we do want the location information for that user.  Anyone know where or how that could be getting updated from?  I have looked at all the LDAP Import scripts, Scheduled Jobs, Business Rules, etc and don't see anything that is doing that, yet the invalid record that is inserted into cmn_locations was created by the account used to run the LDAP Imports.

Rogers Cadenhe1
Giga Guru

Check the field map for the city field in the transform map that sets the user's city in sys_user. Is the choice action set to ignore or create?

If it is create, the city will be created in cmn_location when a user is imported to sys_user.

If it is ignore, the city will be left blank in sys_user and the city won't be created in cmn_location.

View solution in original post

sgmartin
Kilo Guru

Now this is making total sense.  Never really took that close of a look into that, but with the Location field in sys_user is a reference to the cmn_locations table.  I will mark this as the correct answer.  Thanks for the quick response.