Errors: Internal location is Already assigned to another Ship-to Address

 If it returns any row, it means that, indeed, an Internal location is Already assigned to another Ship-to Address 

SELECT * FROM PO_LOCATION_ASSOCIATIONS_ALL WHERE LOCATION_ID = &location_id AND ORG_ID = &enter org_id;

 

For deletion of internal location association

Please run following datafix:

Take a backup of table :- FROM PO_LOCATION_ASSOCIATIONS_ALL

 DELETE FROM PO_LOCATION_ASSOCIATIONS_ALL  WHERE LOCATION_ID = &location_id AND ORG_ID = &enter org_id;