Friday, March 1, 2013

How to End-Date/Delete an Applications User ???



Applications users cannot be deleted since records belonging to users are kept for security and monitoring purposes. In addition, the user is recorded in Who columns, so deleting would cause foreign table data integrity problems. Instead, set "End Date" for that user.

Also same for the responsibility. We cannot delete a responsibility. We can only end-date a responsibility.

So Users and responsibilities cannot be deleted, instead you should end-date it.
For menus, functions, custom applications, it is to delete them -- Navigate to the form, query the record, and click on the delete button (or Edit > Delete).

There is no API or scripts to delete user accounts in FND_USER. Deletion of an an e-business suite user account is not possible and not supported. The supported methods to disable an Applications User are:
1. To end-date the user account 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 PIERRE:
fnd_user_pkg.updateuser(x_user_name=>'PIERRE',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
2. To use FND_USER_PKG.DISABLEUSER API:
  • Pass the username as parameter. This will disable the user.
Note : After disabling a user, you can enable it by using the package FND_USER_PKG.ENABLEUSER
 
 
 

4 comments:

  1. Hi,

    Is there an API to remove an employee attached to a user name? For example, my name would be attached to a user name through the Person field in the Users form. I need to delete my name from the Person field irrespective of whether the user account is active or inactive. My email is raga.g.k@gmail.com. Any help is appreciated.

    Thanks,
    Ragha.

    ReplyDelete
    Replies
    1. Hi Ragha,

      I don't know about API to remove an employee attached to a username but yes you can remove it (Single / Bulk) from backend through SQL Query. There is an employee_id column in FND_USER, you can make that employee_id to NULL against particular USER_NAME or any other condition in WHERE Clause, it will reflect to Person field in the Users Form.

      I hope this will help you.

      Thanks,
      Manish Nashikkar

      Delete
  2. Hi,

    Is there an API to remove an employee attached to a user name? For example, my name would be attached to a user name through the Person field in the Users form. I need to delete my name from the Person field irrespective of whether the user account is active or inactive. My email is raga.g.k@gmail.com. Any help is appreciated.

    Thanks,
    Ragha.

    ReplyDelete
  3. Hi,

    Is there an API to remove an employee attached to a user name? For example, my name would be attached to a user name through the Person field in the Users form. I need to delete my name from the Person field irrespective of whether the user account is active or inactive. My email is raga.g.k@gmail.com. Any help is appreciated.

    Thanks,
    Ragha.

    ReplyDelete