Oracle users are usually required to change their Oracle password every X number of days, sometimes with a Y number of days grace period. This method causes their account to be locked if they do not change their password after the grace period.
Profile with the following SQL code:
PASSWORD_GRACE_TIME 30 PASSWORD_LIFE_TIME 90
Rewrite the code to expire the password after the grace period instead of locking it so that Oracle automatically generates a dialogue box prompting the user to change his password.