ODI : Reset SUPERVISOR Password

After the Creation of the Master Repository and import of the repository zip from the different ODI Repositroy, the password of the SUPERVISOR gets set to the one of the ZIP file.
So it will pop up the below error while trying to login after the import :


oracle.odi.core.security.BadCredentialsException: Incorrect ODI username or password
at oracle.odi.core.security.SecurityManager.doODIInternalAuthentication(SecurityManager.java:392)
at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:260)
at oracle.odi.ui.docking.panes.OdiCnxFactory$1.run(OdiCnxFactory.java:214)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)
at java.lang.Thread.run(Thread.java:662)

To reset the password of the SUPERVISOR follow the below steps,

• Login to the MREP schema in the Database.
• Select the SNP_USER table to verify the username.
• Using the encode.sh ,create a encrypted password.
• Update the SNP_USER Table with the Password generated using the encode.sh for the SUPERVISOR user.
• Now, login to the ODI GUI .