Unable to restrict Grant/ Award data access to user with specific condition — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to restrict Grant/ Award data access to user with specific condition

edited May 14, 2025 5:19PM in Project Management 3 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!