EBS Application login Process in R12.1

EBS Application login Process in R12.1:
=============================================

 What happens when you login to Apps?
1 . Your login gets authenticated against a table named fnd_user for your username and password

 2. DB connection is established using APPLSYSPUB user. This user “APPLSYSPUB” is having access to 
fnd_user view and a small set of other public tables
 needed to establish the initial connection.

 3. Once DB connection is established FND_USER table is used to get ENCRYPTED_FOUNDATION_PASSWORD.
 Using GUEST/ORACLE password combination and ENCRYPTED_FOUNDATION_PASSWORD,
 we get Apps schema password

 4.  The Application user password compared to the application user password entered by user in 
login screen. If both passwords match then user is allowed to get into self-service

 5. A list of responsibilities assigned to that user is shown.  The user picks one of the 
responsibilities listed.

 6. Each responsibility has a data group and application defined for it.Together, 
the data group and application define the Oracle account the responsibility uses.

 ****************************************************************

 When a User first Enters his credentials in EBS application the request first goes to Web server 
and then the request is forwarded to the database with the help of Guest user and password in
 the dbc file after which it checks for the user authentication in the database through DBA_USERS
 & FND_USERS Once this is done the response is send to user through Form Server & Web Server

Comments

Post a Comment

Popular posts from this blog

Troubleshooting EBS login page issue in R12.2:

Troubleshooting EBS login page issue in R12.2: ------------------------------------------------------------------------------------------------------------------- 1. If the login page doesn't comes up then we have to focus on the varios logs present under $LOG_HOME directory. In case of EBS 12.2(as it is the latest release), 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 reas...
Read more

Oracle Apps EBS R12.2 Login Flow

Image
EBS R12.2 Login Flow When a HTTP request is made for EBS, the request is received by the Oracle HTTP Server (OHS). 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). WLS determines the J2EE application that should deal with the request, which is called "oacore". 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. 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 Redir...
Read more

Oracle apps dba Interview Q&A's

Oracle apps dba Interview Q&A's: =========================== What is the significance of utl_file_dir parameter in init.ora file? ===================================================================== Answer The value of this parameter is the group of directories to which u r database can write,  means u r database packages have permission to write to flat files in these directories. What is APPLPTMP environment variable? ======================================= Answer This is the temporary file location for the pl/sql temp files.  If this variable was not set then the concurrent programs may error-ed out. DIAG_PARAM ="Y" in adcmctl.sh. for CM issues oracle apps concurrent managers interview question and common information's Question:Error: ================ After submitting the concurrent program, i am getting the status as inactive and no manager and when i clicked on diagnostics button its showing a message like This request will not be pro...
Read more