VPD Profile with plan from location
We have a requirement to restrict user access based on Organization location which are fixed location.
We have achieved this using user associations.
However, we have an issue when the order release is created with a plan from location which is a supplier location that is not a fixed location,
and the user does not have access to that location
but does have access to the source location since it is an organization location.
In this case, during bulk plan order is failed to build a shipment because the user lacks access to the plan from location.
We are using the query below in the VPD profile on shipments to enforce the location-based access restrictions.