I am auditing Oracle Financials (11.0.3 version) via Oracle aiditing rather than via the the Financials.
I need to know the os username of the person who is running the app rather than 'applprd' or some generic aplication id.
I set up auditing ' by session' but I get the generic userid and the action_name is 'session rec' when I select from dba_audit_trail.
I would like to see the osusername and the action , such as 'select, insert, update,delete'.
This is one row of the output:
27-oct-04 10:24:19 applprd APPS APPLSYS FND_USER SESSION REC
selecting from the aud$ table is not giving the desired result either.
I also tried audit .. by access but the action_name comes out as 'session_rec' as well.
Thanks for the help.
If this is easier to do via the APP then I nedd to know how.