EBS on Oracle Cloud Infrastructure (MOSC)

MOSC Banner

Active EBS users

Hi team, i need a list with labeled active and inactive EBS users. In select there is necessary data which i need to extract, and i do need to satisfy these conditions also in where only to return responsibilities that do not contain this text in the name

  • Notifications
  • iExpenses (but include anything with iExpenses Setup and Admin)
  • Inquiry
  • Self-Service
  • Self Service
  • (Read Only)
  • Internet Expenses Auditor (but include anything with Internet Expenses Setup and Admin)
  • Internet Expenses Help Desk
  • Employee Opportunities

My query is like this:


SELECT

  fu.user_name       "User name",

  frt.responsibility_name "Responsibility Name" ,

  CASE

  WHEN furg.end_date IS NULL OR furg.end_date > sysdate

Tagged:

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