Hi All
I have a requirement in an oracle based application which has a Forms and Reports 11g front end and oracle 12c database.
oracle database is ...
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
PL/SQL Release 12.1.0.1.0 - Production
The requirement being to set up some kind of audit log option within the database so that any user who makes changes via the front end forms is captured with data such as who made the change and time and in which form etc.
The user's details (name) and Form information are captured when the user logs into the system and kept in global variables so that information would be readily available.
There are about 270 oracle tables with the most having data with 390k rows and just over half have any data within them with the rest having 0 rows.
So when a user goes into a particular form he may amend data within a form which may update data in a number of tables for example whilst other forms may change just one table.
Ultimately when the data is captured in the back end tables somehow, they would want to see the information via oracle reports such as who made changes and at what time and in which forms etc.
So as this is an oracle based application with front end forms/reports the solution would be captured via the back end database
What would be the best way to capture the information that I need for this scenario?
I have asked in the pl/sql forum which pointed towards a database trigger solution but wanted to ensure there werent any alternatives on the forms side that I could do ?
Regards