GeoCoding for locations attached to business units
This might not be the right forum but not sure where to post it.
We have a requirement where we would want to know the latitude and longitude information of locations assigned to Business Units.
In Fusion applications this can be done by enabling geocoding for the required countries and then running the process 'Populate location latitude and longitude information'. However, what we have noticed is, this populates the latitude and longitude data in the hz_locations table which mainly holds customer addresses. The location_id against the business_units in the hr_operating_units table are not present in the hz_locations table.