Payables and Cash Management - EBS (MOSC)

MOSC Banner

Audit Trail setup question on AUDIT_TRANSACTION_TYPE

edited Nov 17, 2015 10:01AM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered

We are using Oracle Audit Trail to audit multiple Oracle ERP tables (i.e. ap_invoice_lines_all_a). We have a question on the AUDIT_TRANSACTION_TYPEs.

Is it possible to NOT capture the "I" Insert audit transactions in the audit table, and only capture the "U" Update and "D" Delete transaction types?

There is concern of the audit table's size, and limiting data captured to only "U" and "D" would significatly decrease the number of rows captured.

Reference:

Pasted from <https://docs.oracle.com/cd/E18727_01/doc.121/e12843/T156458T156462.htm>

• AUDIT_TRANSACTION_TYPE (I for Insert, U for Update, D for Delete, L for Last, and C for Current).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center