Password Not Updated in ETLSOURCEDETAILS Table After Updating Atomic Password in Data Sources Screen (Doc ID 1632880.1)

Last updated on MARCH 04, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.3.0.0 to 7.3.3.2.0 [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) 7.3.3

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure version 7.3.3, you changed the atomic schema password and you are updating it as described in <Document 1246774.1> "How to Change the OFSAA Config and Atomic Schema User Passwords in OFSAA".  After you go to Unified Metadata Manager > Data Management Tools > Data Ingestion > Data Sources and enter a new atomic password for a Data Source, you get the following message:

[9635] Source saved successfully

However, after making this change, you are getting "ORA-01017: invalid username/password" errors in the log files when running T2T database extracts.

When you compare the encrypted password value in the ETLSOURCEDETAILS table to the same value for the atomic user in the DB_MASTER table, the values do not match.

select v_source_name, v_password from etlsourcedetails where v_source_type = 'RDBMS';
select dbuserid, dbpasswd from db_master where dbname <> 'CONFIG';

It appears the v_password value in ETLSOURCEDETAILS is not updated correctly even though you received a message stating the update was successful.

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