Order Management > Customers > Standard

To assign customer Location if error found "an Internal location is Already assigned to another Ship-to Address ", then need to clear existing data In R12

01. Select Location exist or not
SELECT * FROM po_Location_Associations_All p WHERE p.location_id in (select hrl.location_id from hr_locations_all hrl where hrl.location_code like '%@loc%');

If it returns any row, it means that, exist,
For deletion of internal location association, Please run following datafix:
a) Take a backup of table : FROM PO_LOCATION_ASSOCIATIONS_ALL
b) DELETE FROM PO_LOCATION_ASSOCIATIONS_ALL WHERE LOCATION_ID = &loc_id AND ORG_ID = @org_id;