Tuesday, February 11, 2014

R12 APPS Front End Login issue after the Clone.


R12 APPS  Front End Login issue after the clone.
I was able to see the front end screen but, was not able to go beyond login page after submitting login credentials and got with below error:
Error Page 
You have encountered an unexpected error. Please contact the System Administrator for assistance. 

Implementation 1 ----- not worked

Updating WorkFlow tables:
 
begin apps.wf_local_synch.BULKSYNCHRONIZATION(P_ORIG_SYSTEM=>'ALL',
P_PARALLEL_PROCESSES=>2,
P_LOGGING=>'LOGGING', P_RAISEERRORS=>TRUE,
P_TEMPTABLESPACE=>'APPLSYSX');
END;
/
http://oracleajidba.blogspot.com/2010/05/unable-to-login-after-clone-you-have.html ----- not working


Implementation 2 ----- not worked

SQL> SELECT profile_option_name  FROM fnd_profile_options_tl  WHERE lower(user_profile_option_name) like lower('App%log%agent');
PROFILE_OPTION_NAME
--------------------------------------------------------------------------------
APPS_LOGICAL_AGENT
APPS_LOGICAL_AGENT
APPS_LOGICAL_AGENT
APPS_LOGICAL_AGENT

SQL> select PROFILE_OPTION_NAME, PROFILE_OPTION_ID from fnd_profile_options where lower(PROFILE_OPTION_NAME) like lower('App%log%agent');
PROFILE_OPTION_NAME       PROFILE_OPTION_ID
------------------------- -----------------
APPS_LOGICAL_AGENT                     8492

SQL> select PROFILE_OPTION_VALUE from fnd_profile_option_values where PROFILE_OPTION_ID='8492';
no rows selected
SQL>

https://community.oracle.com/thread/1125331


Implementation 3 ----- not worked

Cleared Cache.
JSP Pages Hanging in R12 After Removing Cached Class Files in _pages (Doc ID 433386.1)
http://onlineappsdba.com/index.php/2009/06/02/compiling-jsps-at-runtime-in-oracle-apps-r12/

Got with below error after submitting username/password from front end.

<PRE>SQL_PLSQL_ERROR &#40;ERRNO=1000&#41; &#40;REASON=java.sql.SQLException: ORA-01000: maximum open cursors exceeded &#41; &#40;ROUTINE=decryptSessionCookie&#40;String&#41;&#41; ICX_SESSION_FAILED </PRE>
Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.


Implementation 4

Earlier both cursors were 50, now changed it to 500;
alter system set session_cached_cursors=500 scope=spfile;
alter system set open_cursors=600 scope=both;

Bounce DB


Implementation 5

adadmin ----------- failed with below error
Not Possible to spawn any processes on on the database. Database has reached it limit with respect to maximum processes

SQL> alter system set processes=500 scope=spfile;


Implementation 6

SQL> select SESSION_COOKIE_DOMAIN from ICX_PARAMETERS;
SESSION_COOKIE_DOMAIN
------------------------------

select fnd_web_sec.validate_login('SYSADMIN','welcome2014') from dual;
Again, this command should return 'Y' if it is working OK.

If not, you should reload the jar files to the database using adadmin.
(adadmin, upload jar, db) --------- This worked!!!!!! Now able to login

http://beginapps.blogspot.com/2008/09/troubleshooting-login-problems-in.html


No comments:

Post a Comment