Oracle VM Consulting
view counter

Auditing on FND_FLEX_VALUES: How to see Audit History

Thanks to Joanne Nash for this story
Oracle Virtualization and Cloud Consulting
view counter
To keep an audit trail be kept for mapping of segment values to external values (such as for extracts to other systems) and changes to it
1) Define DFF on FND_FLEX_VALUES to contain the mapping values
2) enabled auditing on FND_FLEX_VALUES,
3) if they wish to query the audit data start with this:
select *
from FND_FLEX_VALUES_AC1
where attribute1 is not null
FND_FLEX_VALUES_AC1 is a view of the audit table

Read the entire article at its source

view counter