My Oracle Support Banner

ODI SUPERVISOR Password Set to Expire when Changed via "Change ODI User Password" Menu Option (Doc ID 2253830.1)

Last updated on FEBRUARY 22, 2024

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 to 12.2.1.2.8 [Release 12c]
Information in this document applies to any platform.

Symptoms

Changing the supervisor password via the ODI menu option 'Change ODI User Password' results in an expiration date of 180 days in the future. This does not happen if you select the 'Change Password' button in the user object. It is expected that the EXPIRACY_DATE value would remain NULL, meaning that the supervisor user password would never expire.

To reproduce:

  1. Log into ODI Studio as SUPERVISOR.
  2. Go to Security navigator.
  3. Go to Users section and double click on a SUPERVISOR.
  4. Click on change password, enter new password and save the changes.
  5. Login to DB as repository user (for example, DEV_ODI_REPO) and execute the following SQL:

    Note that the expiration date of the password is now set.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.