Is it Possible to Delete a User after Registering with Wrong Organization?

(Doc ID 465425.1)

Last updated on AUGUST 26, 2016

Applies to:

Oracle iSupport - Version 11.5.10 and later
Oracle iStore - Version 11.5.9 and later
Oracle Application Object Library - Version 11.5.9 and later
Information in this document applies to any platform.
***Checked for relevance on 06-Dec-2013***
FND_USER


Goal

When a Party registers with the Organization number (also Party number), in the Register page the user enters the First Name, Last name and Username.
Once all this information is entered a user is created with above information in FND_USER.

If the Party enters a wrong number (Organization) he is created as a User under a different Organization.
When trying to register again with the correct party number, he can not create his user name since it already exists in FND_USER with the wrong number entered earlier.

Is it possible to delete the old User in FND_USER with incorrect number, so the same user can be used with the correct Organization?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms