EBS Customizations (MOSC)

MOSC Banner

Audit Trail Column: AUDIT_TRUE_NULLS

edited Apr 15, 2015 6:05PM in EBS Customizations (MOSC) 2 commentsAnswered

Greetings,

I have just started a customization that requires the use of the Oracle Audit Trail Application.   I will be auditing the FND_FLEX_VALUES table for a specific value set.   I have created the audit, as per a couple of articles found on the web, and modified the created the procedures so that I am auditing a specific value set. All appears to be working well except the column AUDIT_TRUE_NULLS is null for most updates.   I was under the impression that this column contains a string of Y/N values, one for each column modified/updated.

I would like to understand why this column is null when an audited column is updated.  Is this normal behavior or a possible flaw in my audit setup?  The two rows below depict my confusion.  The row updated by Audit_User_NAME AAAAAAAAAA has the Audit_True_Nulls populated while the row updated by audit_user_name BBBBBBBBBB does not.  The data is from the _A table.

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