Skip to Content

Resetting a forgotten SAP Sourcing / CLM system password

In the event the system user password has been lost there is a database level procedure to restore the password to the initial default, “manager”.  This procedure requires your DBA’s assistance. This procedure is compatible with versions  5.X, 7.X and 9.X.  There is an alternate procedure which is self contained in version 9.0. This is outlined within standard documentation.

Start SQLPLUS or other applicable DB admin tool and login as a user with admin access to the sourcing schema.

SQL> UPDATE <%SCHEMA%>.FCI_SYS_CONTEXT SET ADMIN_USER = ‘bhFmMkXpUn5W2’ WHERE OBJECTID = 0″;

SQL> commit;

<%SCHEMA%> needs to be replaced with the proper schema name used to create the sourcing schema.  If you or your DBA are not familiar with this it can be found in several ways:

     1)From within the application:  in the System Information –> Database tab. Any user with System Administrator

       rights can see this information.

In the connection string you will see the full JDBC string followed by the user/schema names.

2) in the FCISYSTEM.PROPERTIES file.  In FCI_HOME/config

# ==================================================================

#

# S Y S T E M    P R O P E R T I E S

#

# ==================================================================

# ==================================================================

# Database Settings

# ==================================================================

     popdb.database=oracle

     popdb.driverClass=oracle.jdbc.driver.OracleDriver

     popdb.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl

     popdb.user=sour70test2

          popdb.password===ACrGl1J+0qZbgB2kA

     popdb.displayName=System Database

   à popdb.owner=sour70test2

     popdb.tablespace=

          popdb.indexspace=

Note:  You may need to restart the application for this to take full effect..

You can now login to the sourcing system as the system user with password “manager”. This password should immediately be set to something other than the default as this is a well known password.

As the system user,

a)  Navigate to the Enterprise Contexts link.

b)  Select and open for edit the System Context.

c)  Update the system password. Click Save/Done.

d)  Store the new system password in a safe location for future reference

1 Comment
You must be Logged on to comment or reply to a post.
  • I tried resetting the pw of enterprise user (login as system user - enterprise context - context name - edit - sys admin password) , but cannot login using this new enterprise password. Can you please let know if something else needs to be done. I couldn't find any SAP document that has more details on how to reset the pw). Please help. Thanks.

    Gabriel