Hi - did you get any response to this query? I'm also interested in this solution!

Hi @ravikiran goda-Oracle thanks so much for the response. I actually resolved this by returning UPPER (email) and matching against USER and waited for a scheduled process to run and it's now restricting as expected. Really appreciate you coming back on this.

Hi @Rich Merkel thank you for your suggestion - we've run this however this hasn't solved the issue. Do you have any additional suggestions? Thank you!

Hi @Bhaskar Konar we have run this process, and it populated for a few more project numbers, but certainly not all of them. It's very perplexing!

This is exactly what we want this role to do @Nathan CCC but to be honest we're not getting it to work as you've outlined. Would it be possible for me to arrange a quick call with you to discuss (I'm sorry I'm new to this community so apologies if this isn't allowed)?

Thanks @Nathan CCC I really appreciate your response. We are trying to create a reporting only role for Projects (with no UI access), so were hoping to only include OTBI relevant transaction analysis duty roles potentially removing ones like these: Is it possible to get a solution with just assigning the transactional…

Hi @Nathan CCC - I'm trying to set up the exact same OTBI reporting only role (initially for Project Commitments Real Time, but will be expanding to other subject areas) and have attempted to follow these steps, however was unable to "remove all inherited roles except keep the transaction analysis duty roles that give…

Thank you for the response @Bhaskar Konar, it's appreciated. I'm using Projects - Performance reporting real time and Project Control - Budgets real time SAs. Please note I've included additional email and User columns.

Should note that I'm using Projects - Performance reporting real time and Project Control - Budgets real time SAs