+26 Oracle Apps Password Reset Script

Easy Expired Password Resets in Oracle SQL Developer
Easy Expired Password Resets in Oracle SQL Developer from www.thatjeffsmith.com


Understanding the importance of security in today's digital world, Oracle has implemented various measures to safeguard the data and access controls of its applications. One such security feature is the password reset script in Oracle Apps. In this article, we will explore what the password reset script is, how it works, and how to use it effectively.

What is the Oracle Apps Password Reset Script?

The Oracle Apps Password Reset Script is a utility provided by Oracle that allows users to reset their passwords in the Oracle Applications environment. This script is designed to enhance security by ensuring that users have control over their own passwords and can reset them as needed.

Why is the Password Reset Script Important?

The password reset script is important for several reasons:

  • Enhanced Security: By allowing users to reset their passwords, the script reduces the risk of unauthorized access to Oracle Applications.
  • User Convenience: Users no longer need to rely on administrators to reset their passwords, saving time and effort.
  • Auditing and Compliance: The password reset script provides a secure and auditable method for users to manage their passwords, ensuring compliance with security policies.

How does the Password Reset Script Work?


Before using the password reset script, make sure you have the following:

  • Access to the Oracle Applications environment.
  • Valid user credentials to log in to the Oracle Applications system.
  • Knowledge of the specific Oracle Applications version and setup.

Step-by-Step Guide to Using the Password Reset Script

Step 1: Connect to the Oracle Applications System

To use the password reset script, you need to establish a connection to the Oracle Applications system using a client tool such as SQL*Plus or SQL Developer.

Step 2: Locate the Password Reset Script

Once connected, navigate to the directory where the password reset script is located. The script is typically named "fndcpass.sql" and can be found in the $FND_TOP/patch/115/sql directory.

Step 3: Run the Password Reset Script

Execute the password reset script by entering the following command:


This will prompt you to enter the username for which you want to reset the password.

Step 4: Enter the User Details

Enter the username for which you want to reset the password when prompted. Make sure to enter the username in uppercase letters.

Step 5: Confirm the Password Change

The password reset script will generate a new password for the user and display it on the screen. Confirm the password change by entering 'Y' when prompted.

Step 6: Test the New Password

Log out of the Oracle Applications system and log back in using the new password to ensure that it works correctly.

Tips for Using the Password Reset Script

Tip 1: Change the Default Password Reset Script Name

To enhance security, consider renaming the password reset script from its default name "fndcpass.sql". This will make it harder for potential attackers to locate and exploit the script.

Tip 2: Limit Access to the Password Reset Script

Restrict access to the password reset script to authorized personnel only. By limiting access, you reduce the risk of unauthorized password resets and potential misuse of the script.

Tip 3: Implement Two-Factor Authentication

Consider implementing two-factor authentication for accessing the password reset script. This adds an extra layer of security by requiring users to provide additional credentials or verification codes before resetting their passwords.

Tip 4: Regularly Update the Password Reset Script

Stay up to date with Oracle's security patches and updates. Regularly check for new versions of the password reset script and apply them to ensure that you have the latest security enhancements.


The Oracle Apps Password Reset Script is a powerful tool that allows users to take control of their passwords in the Oracle Applications environment. By following the step-by-step guide and implementing the provided tips, you can enhance the security of your Oracle Applications system and ensure that password resets are done securely and efficiently.