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

Last updated on APRIL 24, 2017

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
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

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 hundreds of Community platforms