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

Hello Erman,

I reviewed the document 1943995.1, and i am checking the profile value.

However, I saw something, which might be the cause of my issue, here is the data, please provide your input


--------

In the current environment, where the login screen does not show up, D1, here is some relevant information

SQL> select * from dba_editions;

EDITION_NAME PARENT_EDITION_NAME USA
------------------------------ ------------------------------ ---
ORA$BASE YES


--------------

Ran this query and got no row at all

As applsys

select APPLICATION_ID,PROFILE_OPTION_ID from FND_PROFILE_OPTIONS where PROFILE_OPTION_NAME='APPS_LOGIN_FUNCTION';

APPLICATION_ID PROFILE_OPTION_ID
-------------- -----------------
0 9869
--------------

SQL> select LEVEL_VALUE,LAST_UPDATE_DATE,PROFILE_OPTION_VALUE,ZD_EDITION_NAME from fnd_profile_option_values where APPLICATION_ID=0 and PROFILE_OPTION_ID=9869
2 /

no rows selected

--------------------In another environment, where things are working fine etc, VCPD2

SQL> select * from dba_editions;

EDITION_NAME PARENT_EDITION_NAME USA
------------------------------ ------------------------------ ---
ORA$BASE YES
V_20161007_1449 ORA$BASE YES
V_20170117_1225 V_20161007_1449 YES
V_20170628_0911 V_20170117_1225 YES
-----------------------

SQL> select APPLICATION_ID,PROFILE_OPTION_ID from FND_PROFILE_OPTIONS where PROFILE_OPTION_NAME='APPS_LOGIN_FUNCTION';

APPLICATION_ID PROFILE_OPTION_ID
-------------- -----------------
0 9869

---------------------

SQL> select LEVEL_VALUE,LAST_UPDATE_DATE,PROFILE_OPTION_VALUE,ZD_EDITION_NAME from fnd_profile_option_values where APPLICATION_ID=0 and PROFILE_OPTION_ID=9869;

LEVEL_VALUE LAST_UPDATE_DATE PROFILE_OPTION_VALUE ZD_EDITION_NAME
----------- ------------------ ---------------------------------------- ------------------------------
0 19-JUL-06 APPS_LOGIN_DEFAULT V_20170628_0911


----------------

As I mentioned, initially I was trying to apply a patch to the D1 environment,

adop phase=prepare had an error, running autoconfig on the run file system.

I did an adop phase=abort

Then successfully ran the autoconfig on all the DB nodes and App tier , then the issue of login screen now showing started.

Thanks