Hi,
I'm interesting in your project.
I have much experience with Oracle and PL/SQL.
I have a generic audit trigger for all tables (for Oracle 11g).
I don't imagine other solution.
If not, we must change each transactions for get info.
I'm available for any question.
regards