Hello,
I have a requirement to perform full auditing on our data sensitive Forms modules recording the actual values for all transactions.
Essentially, the auditing authority wants all the fields on the screen for each transaction, from that they can discern the before and after values.
I am not sure how to get the actual values from the Forms query via the database.
There is no Select trigger in the database and it's my understanding the FGA provides the select statement only with the bind variables.
I need the actual values from the select.
On a post-query trigger, I can call a database procedure that writes to the audit table and does the commit. This gets around the FRM-40737 Illegal restricted procedure if it's done directly in the post-query trigger.
This will do what I want, but is this the best approach?
This way I have to modify all the forms impacted, I would rather put all logic in the database and have it handled in one area.
Our environment is:
Forms 11.1.1.6
DB 11.2.0.3.0
Appreciate all help
Regards,
Jim