My Oracle Support Banner

Cannot Change Password for Atomic User as Account Keeps Locking (Doc ID 2394252.1)

Last updated on MAY 04, 2018

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.3.0.0 and later
Oracle Financial Services Asset Liability Management - Version 6.1.1 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), when attempting to change the atomic user password in System Configuration > Database Details, the atomic user account becomes locked before you can change the password.  The error below is output to the SMSService.log in $FIC_APP_HOME/common/FICServer/logs:

[UMMLOG] Apr 8,18 23:25:59 : [DACDATABASEGATEWAY][BIND VARIABLES DDL Query for debug] : [ select METADATA_KEY ,LOCALE_DESCRIPTION from REV_LOCALE_HIER where VERSION_NO = 0 and METADATA_KEY like 'HPFTRL:%:ND' and upper(METADATA_LOCALE) = 'EN_US'] On URL: jdbc:oracle:thin:<deleted> Driver: oracle.jdbc.driver.OracleDriver Metadata Required : false
[UMMLOG] Apr 8,18 23:25:59 : [CONNECTIONPOOL]No connections in free pool. Creating new connection.
[UMMLOG] Apr 8,18 23:25:59 : [DACCONNECTIONPROVIDER]Error getting connection from pooljava.sql.SQLException: ORA-01017: invalid username/password; logon denied


Followed by:

[UMMLOG] Apr 8,18 23:30:15 : [DACDATABASEGATEWAY][BIND VARIABLES DDL Query for debug] : [ select METADATA_KEY ,LOCALE_DESCRIPTION from REV_LOCALE_HIER where VERSION_NO = 0 and METADATA_KEY like 'HPFTRL:%:ND' and upper(METADATA_LOCALE) = 'EN_US'] On URL: jdbc:oracle:thin:<deleted> Driver: oracle.jdbc.driver.OracleDriver Metadata Required : false
[UMMLOG] Apr 8,18 23:30:15 : [CONNECTIONPOOL]No connections in free pool. Creating new connection.
[UMMLOG] Apr 8,18 23:30:15 : [DACCONNECTIONPROVIDER]Error getting connection from pooljava.sql.SQLException: ORA-28000: the account is locked


[UMMLOG] Apr 8,18 23:30:15 : [DACCONNECTIONPROVIDER]
java.sql.SQLException: ORA-28000: the account is locked

As a result of this issue, you cannot change the atomic password for OFSAA.

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.