Guest User Enable

[Lora]

For Enable Guest user I did following thing .........

1. Reset GUEST password:

SQL> exec fnd_vault.del('FND');
SQL> commit;
SQL> select FND_WEB_SEC.CHANGE_GUEST_PASSWORD ('ORACLE','Lora123') from dual;
SQL> commit;

2. Test if Profile Updated or not?

DECLARE
stat boolean;
BEGIN
dbms_output.disable;
dbms_output.enable(100000);
stat := FND_PROFILE.SAVE('GUEST_USER_PWD','GUEST/Lora123','SITE');
IF stat THEN
dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
end;


3. Bounce Instance .

But I can not log on my Instance . I am in Prod Server Please help me ASAP. when I try to log on it gives me Http 500 server error. There are around 4000 user waiting for me. So please ............

Can i revert fnd_vault.del('FND') command.I mean if I go to my previous status that also ok.

[admin]

1- You should not try directly on PROD.
2- Your apps version is not mentioned?
3- Your users are different in your steps first it is Oracle and then Guest?
4-Try the following query and if user and password validated then it should return Y.

select fnd_web_sec.validate_login('GUEST','<Your Password Here>') from dual;

5- Have you run autoconfig or not?

Update us with results. tks

[Lora]

1. Yes you are correct. I should not try in Prod server.
2. R12.1.3
3. You are correct.
4. select fnd_web_sec.validate_login('GUEST','<Your Password Here>') from dual;

Output : N

5. I run autoconfig both in db and apps

[admin]

Pl check profile value "Password Case Option"?

[Lora]

Thanks for replay.

Profile Name:Signon Password Case
Site lebel
Value: Sensitive