Community,
Do you think IFS has the audit trail capability for below items:
1. Event actions – creation and enabling
2. Quick reports – creation
3. Online SQL executions
Thank you.
Community,
Do you think IFS has the audit trail capability for below items:
1. Event actions – creation and enabling
2. Quick reports – creation
3. Online SQL executions
Thank you.
If nothing else you could create an Event to create a log of the first 2 items, triggered when rows are added to the underlying tables. Not sure about #3
FndEventAction and QuickReport are both available to log through History Configuration.
Note however that you won’t be able to log anything to do with the actual CONTENTS of said Reports/Event Actions (i.e. PL/SQL Code being changed for instance), because those fields are saved as CLOB rather than VARCHAR2 (this is to overcome the 4000 characters limit of Varchar2), and History Configuration is not compatible with CLOB/BLOB fields :)
For number 3, you can log Event Action ERRORS, but I don’t believe you can log executions out of the box.
You’d need each event action to log itself executing (probably as a pragma autonomous_transaction if you want the log to persist even if the event ends up in a rollback, by writing to a custom table you’d have created to store that data) if you really need to trace event executions.
appreciate both inputs here.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.