Step 1. Go to APEX_050100 User
Step 2. Go to WWV_FLOW_FND_USER table then >> Set Password On WEB_PASSWORD Column Of Respective User.
After Setting Password On WEB_PASSWORD Column Password May Hide/Invisible.
Step 3. If Account Has Been Locked Then Change ACCOUNT_LOCKED Column Y Flag To N Flag For Unlock The Respective User.
Thank You