SQL Predicate to Implement Data Security in Oracle Cloud Custom Object

Hello Experts,
Need a quick help!

We recently deployed a custom page in which we have to restrict the data based on user Business unit - We have followed below navigation in Security console to create a policy in Manage Database Resources.

1. Login to Instance

2. Navigate to Tools > Security Console

3. Administration > Manage database resources

4. Editing the custom database resource
5. Going to policy and added below SQL Predicate
 

AND YourCustomTableAlias.org_id IN (
   SELECT org_id
   FROM   fun_user_role_data_asgnmnts
   WHERE  user_guid = fnd_global.user_guid
   AND    datasec_context_type_code = 'BU'
   AND    active_flag = 'Y'
)

 

 

6. Once this is done we have saved the policy and added the policy in our role.