Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Audit log via forms

Shambo2904Mar 10 2020 — edited Mar 11 2020

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

Comments
Post Details
Added on Mar 10 2020
8 comments
744 views