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.
Guest User Enable
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
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
Who is online
Users browsing this forum: No registered users and 1 guest