Relationship between HR_Locations and HZ_Locations tables
Hello,
We are currently undertaking a customer address data cleansing solution to cleanse and standardise customer addresses in HZ_Locations table. We noticed that some addresses in HZ_Locations come from HR_Locations_All as in Special Spare Parts Delivery Address created in Field Service module (Field Service Dispatcher: Spares Management -> Spares Logistics -> Parts Requirement) which creates the same address in both HR_Locations_All and HZ_Locations (Under the Person type Party record of the Field Service Technician associated with the Service Request for which the spare part is being requested).
We would like to know what is the relationship between HR_Locations_All and HZ_Locations so we can identify the impact of cleansing an address in HZ_Locations while leaving the corresponding address in HR_Locations_All without cleansing. What is the relatioship between the Location_ID in HR_Locations for an address and the Location_ID in HZ_Locations where the same address is created.
We are currently undertaking a customer address data cleansing solution to cleanse and standardise customer addresses in HZ_Locations table. We noticed that some addresses in HZ_Locations come from HR_Locations_All as in Special Spare Parts Delivery Address created in Field Service module (Field Service Dispatcher: Spares Management -> Spares Logistics -> Parts Requirement) which creates the same address in both HR_Locations_All and HZ_Locations (Under the Person type Party record of the Field Service Technician associated with the Service Request for which the spare part is being requested).
We would like to know what is the relationship between HR_Locations_All and HZ_Locations so we can identify the impact of cleansing an address in HZ_Locations while leaving the corresponding address in HR_Locations_All without cleansing. What is the relatioship between the Location_ID in HR_Locations for an address and the Location_ID in HZ_Locations where the same address is created.
3