title: how do i unlock an EBS account? link: https://onemoretech.wordpress.com/2007/07/05/how-do-i-unlock-an-ebs-account/ author: lembobro description: post_id: 674 created: 2007/07/05 20:55:00 created_gmt: 2007/07/05 20:55:00 comment_status: open post_name: how-do-i-unlock-an-ebs-account status: publish post_type: post

how do i unlock an EBS account?

Make the value for END_DATE in FND_USER null, of course.

SQL>UPDATE FND_USER SQL>SET END_DATE = '' SQL>WHERE USER_NAME = '[Your User Name]'; ... SQL>COMMIT;

To do it in Perl just use the code I’ve got below (in mod_ebsdb) and substitute the above SQL for the value of $sql (you might want to change what you print to console in order to prevent confusion). Like this:

my $sql= "UPDATE FND_USER SET END_DATE = '' WHERE USER_NAME = '$user_name'";

The aforementioned code will commit the transaction, assuming it passes the simple “Does this USER_NAME exist?” test.

Copyright 2004-2019 Phil Lembo