For more information, please refer to this announcement explaining best practices for getting answers to questions.
How to mass revoke data access assignments in Oracle cloud
Content
Hello,
Just to give you a little background, my company (X) is in process splitting into two separate companies (X1 and X2) and as part of the split a good chunk (~500) of people are going to the new company (X2). As of the split date we need to remove all roles and data access assigned to these 500 users from the parent company (which will become X1).
Removing the roles was pretty straight forward. Once we put in a termination date and process the termination, all roles have been removed. However about 350 employees have data access assignments. even though these employees are termed and all roles have been removed, the data access screen still shows the data access assignments. When I ran a report to see who all have data access assignments, the reports comes up blank. I am guessing the actual database tables have been updated but the UI is somehow still showing the data. I am wondering if there is a way to do