Unable to restrict Grant/ Award data access to user with specific condition
Summary:
We are trying to restrict Grant/ Award data access to user based on certain specific condition on Database Resource "Award for Table GMS_AWARD_HEADERS_B" but is not working as expected primarily because the database resource Action are predefined to use Business Unit or Organization Hierarchy Conditions.
We are using below query to create Database resource conditions:
&TABLE_ALIAS.ID IN (
SELECT DISTINCT GAH.ID
FROM PER_USERS PU,
PER_ALL_ASSIGNMENTS_M PAAM,
HR_ALL_ORGANIZATION_UNITS HOU,
GMS_AWARD_HEADERS_B GAH
WHERE 1=1
AND PU.USER_GUID = FND_GLOBAL.USER_GUID
AND PAAM.PERSON_ID = PU.PERSON_ID