iStore - EBS (MOSC)

MOSC Banner

Deactivate users in iStore

Hi ,


Can you please help me to find out a script to deactivate users in iStore. I used below script to find active users and now I need to deactivate.

select distinct fat.APPLICATION_NAME APPLICATION_NAME,

fu.USER_NAME USER_NAME

from fnd_user_resp_groups_direct furgd, fnd_application_tl fat, fnd_user fu, fnd_responsibility fr

where furgd.RESPONSIBILITY_APPLICATION_ID= fat.APPLICATION_ID

and furgd.USER_ID=fu.USER_ID

and furgd.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID

--AND UPPER(fu.user_name) = UPPER('VIVEGUPT')

and fat.LANGUAGE='US'

and furgd.end_date is null

and fu.END_DATE is null

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