Technology Stack - EBS (MOSC)

MOSC Banner

How to identify EBS users with assigned responsibilities that they have never used?

edited Jun 29, 2023 5:09PM in Technology Stack - EBS (MOSC) 2 commentsAnswered

Oracle EBS 12.1.3.

I'm trying to clean up assigned, obsolete Oracle access. I can identify active users with active responsibility that haven't been accessed within a certain number of days using the below tables to get the last time they connected to said responsibility, but I can't seem to figure out how to actually identify active users with active responsibility where they haven't ever accessed the assigned responsibility. I would really like to identify where a responsibility has been assigned X number or more days ago and never used, but at this point, I take whatever help I can get.

apps.icx_sessions

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center