My Oracle Support Banner

Upgrade Driver 12.2.0 ERROR: The "GUEST_USER_PWD" in vault is not set correctly (Doc ID 2760094.1)

Last updated on SEPTEMBER 01, 2024

Applies to:

Oracle Applications DBA - Version 12.2 and later
Information 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

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.