How To Disable Oracle Apps (EBS 11i )
Users Using API
Oracle API we can Disable Oracle Apps user Using the below
API,
SQL > conn
apps/apps_Password;
SQL>execfnd_user_pkg.updateuser(x_user_name=>'USER_NAME',x_owner=>'CUST',x_end_date=>SYSDATE-1);
SQL>commit;
How To Enable Oracle Apps (EBS 11i )
Users Using API
SQL > conn
apps/apps_Password;
SQL> begin
fnd_user_pkg.enableuser('USER_NAME',
sysdate, sysdate+30);
end;
SQL>commit;
Note : where user USER_NAME is which user name you needed to Disable or Enable.
