How to End-Date/Delete an Applications User

How to End-Date/Delete an Applications User

Goal

How to end-date an applications user.

Solution
- There is no API or scripts to delete user accounts in FND_USER.

- Delete an e-business suite user account is not possible and not supported.

- The only way  is to disable the user accounts by end-dated the user accounts from the Define Users forms or using the following API :

• FND_USER_PKG.UPDATEUSER you may pass an end date to the parameter X_END_DATE of the procedure FND_USER_PKG.UPDATEUSER.
  This will disable the user account.

The example below shows how to end-date custom user JANE:
fnd_user_pkg.updateuser(x_user_name=>'JANE',x_owner=>'CUST',x_end_date=>SYSDATE);

x_owner can be either SEED or CUST:

• To end date seeded users (i.e. sysadmin) x_owner= SEED
• To end date custom users x_owner = CUST

or use the API :

• FND_USER_PKG.DISABLEUSER and pass the username as parameter .
  This will disable the user too.

Note : After disabling a user, you can enable it by using the package FND_USER_PKG.EnableUser