Unable to Create Accounting due Global Roles Assigned
I got the following error message by the time I ran the create accounting.
The Create Accounting process ended in an error because you have global permissions for the Subledger Source Transaction data resource. Details: You must update the data security policies and try again.
Hence I ran the following SQL in order to identify the roles, and I removed but I still got the same error message, hence I was wondering if you can share with me another SQL.
select distinct role_name from fusion.fnd_session_role_sets where role_guid
in (select grantee_key from fnd_grants where object_id in ( select object_id