Upgrade Driver 12.2.0 ERROR: The "GUEST_USER_PWD" in vault is not set correctly
(Doc ID 2760094.1)
Last updated on JUNE 02, 2023
Applies to:
Oracle Applications DBA - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
The merged 12.2.0 upgrade driver patch is failing with the following error found in adwork001.log:
ERROR: The "GUEST_USER_PWD" in vault is not set correctly, the current
value is "GUEST/ORACLE" and failed FND user validation.
Oracle Applications requires a "GUEST" user account for special restricted
access functions. The "/" is stored in vault
with "GUEST_USER_PWD" preference name for Applications program use. In this
instance the value is not set, or does not represent a valid
User_name/Password combination.
CORRECTIVE ACTION: The GUEST_USER_PWD in vault needs to be set to a valid User_
name/Password
combination, preferably the combination for the seeded user account "GUEST".
Please run Autoconfig to synchronize the GUEST credentials at all locations
Alternatively you can run AdminAppServer to generate a new DBC file
Syntax for AdminAppServer :
java oracle.apps.fnd.security.AdminAppServer apps/@<two_task> UPDATE/RE
FRESH DBC=
Also you can use SQL*Plus and the Applications API - FND_VAULT.PUT() to define a
value for
GUEST_USER_PWD in Vault. You can use the file that generated this message
(FND_TOP/patch/115/sql/afgstusr.sql) as an example of how to code this function
Set the value to a known good User_name/Password combination.
DECLARE
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 15
value is "GUEST/ORACLE" and failed FND user validation.
Oracle Applications requires a "GUEST" user account for special restricted
access functions. The "/" is stored in vault
with "GUEST_USER_PWD" preference name for Applications program use. In this
instance the value is not set, or does not represent a valid
User_name/Password combination.
CORRECTIVE ACTION: The GUEST_USER_PWD in vault needs to be set to a valid User_
name/Password
combination, preferably the combination for the seeded user account "GUEST".
Please run Autoconfig to synchronize the GUEST credentials at all locations
Alternatively you can run AdminAppServer to generate a new DBC file
Syntax for AdminAppServer :
java oracle.apps.fnd.security.AdminAppServer apps/@<two_task> UPDATE/RE
FRESH DBC=
Also you can use SQL*Plus and the Applications API - FND_VAULT.PUT() to define a
value for
GUEST_USER_PWD in Vault. You can use the file that generated this message
(FND_TOP/patch/115/sql/afgstusr.sql) as an example of how to code this function
Set the value to a known good User_name/Password combination.
DECLARE
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 15
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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |