nice post keep up the good work

Check similar at Advanced Apps DBA

Atul,

I followed all your atricles in ” For Apps DBA beginner’s ” they are very good.
I can definetly refer your site as a good steping stone for Starter APPS DBA’s.

Once again my heartfully thanks to you for doing this kind of job for future APPS DBA’s. So, pl. keep posting.

Regard
Sashidhar

Atul great wrk - as part of these - can you shed some lite on the different and important FND tables that dba’s need to be aware of

Thanks,
Vidya

Vidya,
Thanks a lot for your compilments. I have listed few important Apps tables at my site .
To view HTTP://TEACHMEORACLE.COM/IMPTABLES.HTML> Click Here for Imp Tables in Apps

one late qustion autl, is there any way on earth that i can know the ip address of the clinet who are currently using my froms.

fadi

Hi Atul,

Can you please clarrify my doubt?

(GUEST/ORACLE have you ever noticed why this user is there , Hope you know it now it Uses Guest User to autenticate your user in database )

My DBC file contains

GUEST_USER_PWD=GUEST/ORACLE

But I could not connect to the database using this user

SQL> connect GUEST/ORACLE
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

Even I could not connect using this username and pwd in the appication.

Please let me know is this database user or application user? If it is application user then using which user it is connecting to database to verify the application user and pwd?

Seelan

Hi Atul,
I think while logging in from the initial page(single sign on),oracle use APPLSYSPUB user,otherwise w/o logging into the database how FND_USERS can be verified for username.

please ,clarify in thorough details,

regards,
Vishal

Hi Everyone,

This is my understanding about the request flow in oracle apps and i would like to share with you

1. Webserver receives the user request for the particular port number. Web server Binds the request with the port number
2.Based on the cookie webserver serves the request by sending login page
3. The application user name and password is entered by the user(operations/welcome)
4. The application user login session is validated by connecting to Applsyspub/pub. Applsyspub contains application user session ,invalid logins,security related tables. The user & security is validated here
5. The responsibility page is displayed. User selects a particular responsibility
6. The responsibility and application name is validated by connecting to Applsys schema(fnd_Responsibility, fnd_application…….)
Note: Here we should remember the difference between applsys and apps schema. Applsys schema contains ad,fnd objects whereas apps schema is a global schema contains all application objects.
7. Once the application is validated , Connecting to apps schema to get access application tables. This is the reason why we should have apps and applsys passwords should be same
8. Once a particular form is selected the .dbc file is accessed to get the information about the GUEST username/pwd

But i am not sure when the webdbsvr.app file is getting used. My assumption is between step 3 and 4 the webdbsvr.app should get accessed to obtain the apps password.

Atul and everyone, Please correct me if i am wrong in my understanding.

reg
malar

Hi Atul ,

For beginners like me you are an angel in disguise.

Thanks you very much ,
Aarif

good inspiration for apps dba’s

Atul/Malar,

I didnt understand when .dbc file is going to use, either when accessing a particular form or while giving application username/pwd.

Thanks,
Sai

Hi Atul,

I think you should have added that the Forms Server process spawns a forms client process ( f60sebmx) which actually talks to the client. The above statement remains correct when forms listener servlet is not used.

Chandra

I had a typo in my previous comment is f60webmx

hi Atul…

Thanks for the information….
and please specify the extensions (url’s) as much s possible..

thanks
raghu

Krish for any issues or problems raise them in forum at http://teachMeOracle.com/forum

Pramod,
9iAS is webserver listening for HTTP requests

nice article

I think all needs to check out the things again that, APPLSYSPUB does the validation or its GUEST user does the work.
Do a simple test:-
==================
1)
Open a Putty/Fsecure session and connect as apps user.

2)
Do not execute this query but just make it ready on the screen so that you just need to press ENTER in order to execute this query.

set linesize 100
set pagesize 100
col HOW_MANY_USER_SESSIONS for a60

select ‘Number of sessions opened by user’ ||’ ‘|| fu.user_name || ‘ is ‘ || count(distinct session_id) How_many_user_sessions
from icx_sessions icx,fnd_user fu where disabled_flag != ‘Y’ and PSEUDO_FLAG = ‘N’
and (last_connect + decode(FND_PROFILE.VALUE(’ICX_SESSION_TIMEOUT’), NULL,limit_time, 0,limit_time,FND_PROFILE.VALUE(’ICX_SESSION_TIMEOUT’)/60)/24) > sysdate
and icx.user_id=fu.user_id group by icx.user_id,fu.user_name;

3)
Open iExplore and put your oracle Application URL

4)
Login as SYSADMIN
Immediately press ENTER on your PUTTY/FSecure session and again press “/” and again press “/” and again press “/” and again press “/” . do this until you see output as SYSADMIN.

Important:-
===========
Before SYSADMIN comes on to your screen, query output will show you GUEST as this is the one logs into in order to authenticate uesr SYSADMIN.

Check this out and do let me know if i have showed something wrong.
neerajblr@rediffmail.com

Thanks
Neeraj Kataria