• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Ebuisness Suite » Login flow in R12.2 and basic troubleshooting

Login flow in R12.2 and basic troubleshooting

December 16, 2021 by techgoeasy 3 Comments

R12.2 is the latest Release of Oracle E-business Suite Products. Here we would be discussing the Login flow in R12.2

Table of Contents

    • Login flow in R12.2
  • Here is the processing in terms of URL(Login HTTP headers)
    • Basic Troubleshooting for Login in R12.2
    • (1)  OHS (apache) failure
    • (2)  OACore JVM process not available
    • (3) OACore J2EE application not available
    • (4) Datasource failure

Login flow in R12.2

  1.  When a HTTP request is made for EBS, the request is received by the Oracle HTTP Server (OHS).
  2. When the configuration of OHS is for a resource that needs to be processed by Java, such as logging into EBS, the OHS configuration will redirect the request to the Web Logic Server (WLS) Java process (OACore in this case).
  3. WLS determines the J2EE application that should deal with the request, which is called “oacore”.
  4. This J2EE application needs to be deployed and available for processing requests in order for the request to succeed.   The J2EE application needs to access a database and does this via a datasource which is configured within WLS.

Here is the processing in terms of URL(Login HTTP headers)

When the EBS login works OK, the browser will be redirected to various different URLs in order for the login page to be displayed.  The page flow below shows the URLs that will be called to display the login page:

/OA_HTML/AppsLogin
EBS Login URL
/OA_HTML/AppsLocalLogin.jsp
Redirects to local login page
/OA_HTML/RF.jsp?function_id=1032925&resp_id=-1&resp_appl_id=-1&security_group_id=0&lang_code=US&oas=3TQG_dtTW1oYy7P5_6r9ag..&params=5LEnOA6Dde-bxji7iwlQUg
Renders the login page
The URLs after the user enters username and password, then clicks the “login” button are shown below/OA_HTML/OA.jsp?page=/oracle/apps/fnd/sso/login/webui/MainLoginPG&_ri=0&_ti=640290175&language_code=US&requestUrl=&oapc=2&oas=4hoZpUbqVSrv9IE0iJdY1g..
/OA_HTML/OA.jsp?OAFunc=OANEWHOMEPAGE
/OA_HTML/RF.jsp?function_id=MAINMENUREST&security_group_id=0
Renders user home page
Once the users home page is displayed, the logout flow also redirects to several different URLs before returning to the login page:
/OA_HTML/OALogout.jsp?menu=Y
Logout icon has been clicked
/OA_HTML/AppsLogout
/OA_HTML/AppsLocalLogin.jsp?langCode=US&_logoutRedirect=y
Redirects to the login page
/OA_HTML/RF.jsp?function_id=1032925&resp_id=-1&resp_appl_id=-1&security_group_id=0&lang_code=US&oas=r6JPtR7-a4n5U2H3–ytEg..&params=1JU-PCsoyAO7NMAeJQ.9N6auZoBnO8UYYXjUgSPLHdpzU3015KGHA668whNgEIQ4
Renders login page again

Basic Troubleshooting for Login in R12.2

(1)  OHS (apache) failure


If OHS is not running or not responding, one would see a message as below. If OHS is not running then there will not be any messages in any EBS log file for this request.

Firefox: “The connection was reset”

Steps to take
Check OHS has started OK

adapcctl.sh status
adapcctl.sh stop
adapcctl.sh start

(2)  OACore JVM process not available

If the OACore JVM is not running or not reachable, then one will likely see the following message in the browser:

Failure of server APACHE bridge:
No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent.

There could be two reason
Steps to take
(a)Make sure the OACore JVM has started correctly

admanagedsrvctl.sh start oacore


(b) Check mod_wl_ohs.conf file is configured correctly

(3) OACore J2EE application not available

There may be cases where the OACore JVM is running and reachable but the oacore application is not available.

The browser will report the error:

Error 404–Not Found
From RFC 2068 Hypertext Transfer Protocol — HTTP/1.1:
10.4.5 404 Not Found
The server has not found anything matching the Request-URI. No indication is given of whether the condition is temporary or permanent.

Access_log will show 404 error:

GET /OA_HTML/AppsLogin HTTP/1.1″ 404

Steps to take

In the FMW Console check the “deployments” to confirm the “oacore” application is at status “Active” and Health is “OK”.

If the status is Ok but you are still getting error, then compiling JSP can be tried

cd $FND_TOP/patch/115/bin
cd $FND_TOP/patch/115/bin
./ojspCompile.pl --compile --flush -p 2
logfile set: ojspc_error.log
starting…(compiling all)
using 10i internal ojsp ver: 10
synchronizing dependency file:
enumerating jsps…8000
parsing jsp…8000
writing deplist…8000
initializing compilation:
eliminating children…5912 (-2088)
translating and compiling:
translating jsps…5912/5912 in 1m40s
compiling jsps…5912/5912 in 4m19s
Finished!

(4) Datasource failure

The oacore logs will show this type of error

<Error> <ServletContext-/OA_HTML> <BEA-000000> <Logging call failed exception::
java.lang.NullPointerException
at oracle.apps.fnd.sso.AppsLoginRedirect.logSafe(AppsLoginRedirect.java:639)
at oracle.apps.fnd.sso.AppsLoginRedirect.doGet(AppsLoginRedirect.java:1314)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)

The explorer will show

The system has encountered an error while processing your request. Please contact your system administrator

Steps to Take

  1. Review the EBS Datasource and make sure it is targeted to the oacore_cluster1 managed server.   Also use the “Test Datasource” option to confirm database connection can be made
  2. If one makes any changes, one will need to restart the managed server, despite FMW Console saying no restart is necessary

Articles you must read on R12.2

  • Important Changes in Autoconfig R12.2
  • Service Group changes in R12.2
  • adopmon and adopreports utility R12.2.5
  • How to re-attach 12.2 E-Business Oracle Homes to the central inventory
  • Isolating post-upgrade concurrent programs to a separate manager queue in R12.2

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: Login flow and basic troubleshooting for R12.2

Reader Interactions

Comments

  1. Venkatesh R.K. says

    December 14, 2016 at 3:23 am

    Good Document.
    Do you have any information regarding trace of opmn, oacore, oafm and weblogic?
    Thanks & Regards
    Venkatesh RK

    Reply
  2. techgoeasy says

    December 14, 2016 at 6:20 pm

    you can enable AF logging by below steps

    Source the run file system environment file

    2/ Backup file:

    $INST_TOP/appl/admin/oacore_wls.properties

    3/ Edit $INST_TOP/appl/admin/oacore_wls.properties and add the following lines. (adjust the variables accordingly)

    AFLOG_ENABLED=true
    AFLOG_LEVEL=statement
    AFLOG_MODULE=%
    AFLOG_FILENAME=/tmp/aflog.txt

    4/ Re-start Middle tier services

    5/ Reproduce the issue

    6/ Collect the log file

    7/ Disable logging by removing the lines which were addded to oacore_wls.properties and re-start service

    Reply
  3. techgoeasy says

    December 14, 2016 at 6:24 pm

    Also I feel the below metalink note should help you in diagnozing the issues
    “Using Oracle Fusion Middleware Diagnostic Framework With Oracle E-Business Suite Release 12.2 (Doc ID 1428056.1)”

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to check Stale statistics
  • Java web start(JWS) in R12
  • How to delete the archive logs in Oracle
  • How to generate sql monitor report in Oracle
  • How to find the long running (longops session) in Oracle

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us