Request flow

Request flow in R12

========================

1. User makes a request from browser by typing URL like http://hostname:port

Port is the Web Listener Port

2. The request hits the WebServer and these requests are recorded in access_logs under $INSTANCE_TOP/logs/ora/10.1.3/Apapche

3. Webserver checks that with http header request there is no cookie attached (Cookie is message given by WebServer to Web Browser to identify client)

Webserver identifies that user is logging first time & it passes login page to User .

4. User types his Username Password in login window & clicks submit button.

5. Webserver checks that username and passwords need to authenticate against database FND_USER. This is done with the applsyspub user

6.Once user is authenticated its check against FND_XXXX (FND tables) for Authorization about users responsibilities & assigned responsibilities are presented back to user.

7. Now these responsibilities are of two type Self Services (served by oc4j) or Core Applications served by Forms Server .

If this is Core responsibility , Apache transfers request to Forms Listener and dedicated connection establish between client browser & form.

If User selected Self Service Responsibility like iProcurement, iRecruitement.., Apache forwards request to mod_oc4j($INST_TOP/ora/10.1.3/Apache/Apache/conf/mod_oc4j.conf) and request is fullfilled by

oc4j component

8. Whenever there is a need for the application users to connect to the database internally as apps user, GUEST user is used . It decryptes the APPS password to connect as APPS to database.

9. Users submits his requests for batch processing or somthing else ( Gather Stats done by Sysadmins or Apps DBA's) these kind of requests are fullfilled by Concurrent Manager.

10. When user want to see reports of all these things request is being forwarded to Reports Server .