ERPstuff - Oracle EBS Community

Hi,

Could you please tell me location of job?

bye

Hi ,
Use below query to know about users logged in apps

select distinct d.user_name from apps.fnd_logins a,
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1);

bye

Hi every One

I assigned "web ADI" responsibility to sysadmin and when I access it and click on "Create Document" following error occurs
Web ADI is not a valid responsibility for the current user. Please contact your System Administrator.
Kindly help me.
latif.

Dear All,

I want users to access the E-bussiness 11i application tier through another site name and port not the one that is used by application tier site name and port bcz of security issues.I want to know is there any reliable solution for site and port mapping?
Kindly suggest me.
thanks in ...

Hi ,

The easiest way that I found to configure tnsnames for ADI (Application Desktop Integrator) is just copy or replace the tnsnames.ora file from appstier i-e $IAS_ORACLE_HOME/network/admin/dbname_hostname/tnsname.ora

into the ADI's /netwok/admin folder.

Hope so it'd help you to solve your ...

Hi all,
Can any one help me what is oracle workflow?and as a system/database administrator what are the responsibilities related to workflow?
are there any helful links for oracle workflow?
thanks in advance.

latif

Hi,

If your oracle application version is 11.5.10.2 then try to disable sqlnet access
or make an entry of client 9i computer IP address in sqlnet.ora file of database node(ORACLE_HOME/network/admin/DBNAME_HOSTNAME/sqlnet.ora) file
and restart listener.
bye
Latif

Hi All,

you can check ad_applied_patches in applsys schema,


bye

Hi Amir,

I am using Redhat Enterprise Linux AS release 4.Kindly guide me how i'll tune the OS.

bye

Hi Waqar,

If you have performed first two steps then just query

system administrator-->security--user-->monitor(ctrl+f11)

bye

Hi;
Hope it 'll help you.

-set the profile option (Sign-On:Audit Level) value to form. By default it is set to none.

-run the concurrent program (OAM Applications Dashboard Collection) this concurrent will fill some tables like fnd_oam_forms_rti with important data like IP address of the client ...

Hi all,

My system has 8GB of Ram in which contain oracle database tier and concurrent node of oracle 11i E Bussiness Suite.When I check for memory usage it shows only 25 to 35MB free and remaing is in use.I am worry why there is so much memory usage.Kindly help me.

Mohammed Latif