ERPstuff - Oracle EBS Community

Thanks for replay.

Profile Name:Signon Password Case
Site lebel
Value: Sensitive

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

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 ...