HI

Is it possible if we can run audit reports on JSP page in oracle
LIke on Supplier form if someone changes the bank details then i want to know when it was change and who changed it

You can run Suppliers Report, that will give you following information for each Site:

* Creation Date
* Created By
* Update Date
* Updated By

Also you can pull this information from the database:

select creation_date, created_by, last_update_date, last_updated_by from apps.ap_suppliers
where vendor_id = XXX

You can also use "Record History" feature on web based screens to view the audit trail, if you are using version 12.1.1 +.
This feature is not available on web based screens for older releases like 12.0.6.

Hi Hasan

YOu mentioned that You can also use "Record History" feature on web based screens to view the audit trail, if you are using version 12.1.1 +.

can you please provide the steps to view the record history like suppose on Supplier form

i was able to find the info .. it tells Last Update By - 3877
i don't understand what this 3877 is -- is it some ID from some table


Record History

Last Updated Date 2011-04-14 16:07:22.0
Last Updated By 3877
Creation Date 2006-12-04 20:43:48.0
Created By 1112
Last Update Login

For some reason the application is displaying you the user ids.
You can get the user names using the following query:

select user_name from fnd_user where user_id = 3877