Set Up Service Request Visibility for the users business unit only
we want to do the set up of the SR based on the user Business unit, at the moment oracle have this guide https://docs.oracle.com/en/cloud/saas/sales-and-b2b-service/19d/faiec/users-and-security.html#FAIEC3645286 to the configuration but, the rules provides for BU give access for the users own BU and the default BU.
in the "manage database resources" from the security console we find the policie "Service Request Header" and this SQL statement that do the visibility based on Business Units:
the question is, how can we modified this SQL to only show the SR related to the users own BU and exclude the others BU?