Hi everyone, i wish to reset the user APPS in the Oracle Business Suite but i have looking for in the metalink of Oracle but between the steaps i got it:
sql> select oracle_username, encrypted_oracle_password
from fnd_oracle_userid
where oracle_id in (0,1,900)
3. Compare the results to the following encrypted passwords for Oracle
Applications Release 10.7 where APPS password = APPS, APPLSYS password = APPS
and APPLSYSPUB password = PUB :
ORACLE_USERNAME ENCRYPTED_ORACLE_PASSWORD
APPS
B9538850E83205FA537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA
APPLSYS
B9538850E83205FA537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA
APPLSYSPUB
A8569A03E83205FA537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA
4. If these encrypted values are not the same then backup FND_ORACLE_USERID and
FND_USER tables as follows:
sql> create table FND_ORACLE_USERID_BAK as
(select * from FND_ORACLE_USERID);
sql> create table FND_USER_BAK as (select * from FND_USER);
5. Reset the encrypted passwords using UPDATE in sqlplus:
sql> update FND_ORACLE_USERID set ENCRYPTED_ORACLE_PASSWORD =
'B9538850E83205FA537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA'
where ORACLE_USERNAME = 'APPS'
...
My question is: this value B9538850E83205FA537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA' is a value that i must put, a constante, or what value i must put.
Thank you very much if someone can answer me it.