Hi @chiranjeevi thi,

I am happy to help out. I haven't done this setup with Oracle specifically, but this should point you in the right direction.

1. Create JDBC Connection & Credential Alias for the Oracle database using a mid server.

2. Build a flow that triggers on the catalog request or after any approvals

3. Lookup the catalog variables and grab the user id and any other information you need.

4. Use the JDBC step in flow designer to call a stored procedure or execute an SQL statement to revoke access. You will need an integration hub subscription for this step.

5. If successful, add validation to confirm the users access was revoked.

6. If failure, create a task to a specific team for investigation or manual adjustment.

7. Update ritm based on outcome.

If you don't have integration hub, let me know and I can try and come up with an alternative method.

I hope this helps!