EBS LOGIN PAGE ISSUE:
Step to troubleshoot:
step 1. Check firewall status and disabled it (Otherwise add Ports to allow in the firewall exception list).
steps 2. Check your ebs login port is open or not through telnet.
step 3. Check oacore logs file.
In my case step 3 works in oacore logs I have found the below issue:
Log File: /apps/R12.2/fs1/FMW_Home/user_projects/domains/EBS_domain_PROD/servers/oacore_server1/logs/oacore_server1.log
Observation and Findings:
I have checked in DB the expired users list and found that APPLSYSPUB user is showing expired Status.
Note:- APPLSYSPUB/PUB - is the default public username and password that grants access to oracle E-business suite initial sign-on form. In EBS Application at the time of login, oracle application connect to public schema - APPLSYSPUB. It has the sufficient privilege to perform the authentication of FND user (Application users) which includes the PL/SQL packages to verify the username/password and the privilege to record the success or failure of a login attempt.
SQL> select username,account_status from dba_users where USERNAME='APPLSYSPUB';
USERNAME ACCOUNT_STATUS
-------------------- --------------------------------
APPLSYSPUB EXPIRED
Solution:
[applmgr]$ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYSPUB PUB
Now, Oracle E-business Suite Login page is working fine..!!
