NOTE: THIS PROCESS IS INFORMATIONAL ONLY AND IS ABSOLUTELY NOT A RECOMMENDED PROCESS – YOU MUST NEVER DIRECTLY CHANGE A BASE TABLE USING SQL

By setting the users password_date in APPLSYS.FND_USER to null, don’t forget the table audit columns…. The next time the user connects they will be forced to reset their password.

UPDATE FND_USER
   SET password_date = null,
       last_update_date = sysdate,
       last_updated_by = 0, -- 0 is SYSADMIN
       last_update_login = 0 -- 0 is SYSADMIN
 WHERE user_id = [USER_ID];