Monday 31 August 2015

Update Base Currency Code by using SQL in Maximo

Sometimes requirements changes and Base currency changes to other one, or vise-versa

Suppose at the time of installation, Base currency1 was USD, and 2nd Base Currency was EUR.
and you want to change both to EUR and USD respectively base 1 and 2.
Lets update by using a sql statement.

1. Logout all users
2. Stop WebSphere Application server
3. update ORGANIZATION SET basecurrency1 = basecurrency2 , basecurrency2 = basecurrency1; 

4. Commit
5. Start Websphere Application server
5. Done

No comments:

Post a Comment