I have an application in Oracle Forms using Oracle Database.Requirement is as a part of audit tracking of some of the screens we need to capture the following.
Need to be able to audit by user name;
this will need to be a historical record thereby tracking all users.
When a specific user is requested provide the information in an excel document.
TABLE: client, Paypackage, dept, employee
Need to be able to go back and forward regardless of date asked: i.e. Audit asked for on 2014-10-31 but Parameter for report is 2010-10-31 - 2014-09-25.
So I created a parameter screen for search creteria.
1. Can select Client Id or Username
2. Select specific date frame: from - to
3) generate report.
But the problem is I used Audit trail table but was not capturing data correctly as if it is search with client ID i can capture the client ID,
but if it is search by wild character of all clients then the result is not capturing the client ID.
sameis the case with Update and delete as the forms are storing rowid for update/delete transactions.
so overall the data captured in Audit trail is not accurate.
Can you please advise what else solution is recommended to get accurate audit information of all sorts search creteria and update and delete transactions,
Search creteria can be as follows.
1) search by individual client ID
2) search by wild card character to return matching clients
3) searach can be based on birthdate of that employee
4) search can be on gender
5) search can be on nationality etc.
update and delete always doing using the Rowid.
Thanks in advance.