Re: EBS 12.2 login page not showing ,after running autoconfig on DB + App tier
Posted by ashish_oracleguy on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/EBS-12-2-login-page-not-showing-after-running-autoconfig-on-DB-App-tier-tp2977p3035.html
Hello Erman,
You pointed in the right direction -
"The local login page is defined by the profile 'Applications Login Fuction' and by default this should be set to 'APPS_LOGIN_DEFAULT'." "
---------------
I had made a backup of the table FND_PROFILE_OPTION_VALUES in APPLSYS schema and deleted some rows that had , ZD_EDITION_NAME value to an old DB editions which was not there, which caused my login screen missing issue.
Once I restored those rows from the backup table to FND_PROFILE_OPTION_VALUES , the login screen appeared and I was able to login into my system. -- Things are fine now.
----------------------------------------------------------
However the fundamental issue with my system is still there and i can't apply any patch right now on it.
Basically, here is how I would pra-phase my issue
I have my AD_ZD tech stack out of sync with the DB editions.
Here is why I say this
Basically , the out come of these 2 queries tell me that ,my AD_ZD tech stack is out of sync with DB editions:
SQL> select distinct zd_edition_name from fnd_profile_option_values;
ZD_EDITION_NAME
------------------------------
V_20160624_1030
SQL> select * from dba_editions;
EDITION_NAME PARENT_EDITION_NAME USA
------------------------------ ------------------------------ ---
ORA$BASE YES
---
Any suggestions on how to fix it.
Thanks,
Ashish