My Oracle Support Banner

How to Find Information on the User Which Deleted Mapping Rules from a Rule Set and Undid Mapping Rules (Doc ID 981690.1)

Last updated on DECEMBER 23, 2009

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10 to - Release: 11.5 to 11.5
Oracle Profitability Manager - Version: 11.5.10 to - Release: 11.5 to 11.5
Information in this document applies to any platform.


When checking some results, it was realized that a user ran Executed Rule removal on a rule and also deleted a rule from a Rule Set.  Would like the answers to the following questions:

1. How to find the last person who updated a Rule Set?
2. How to find who ran Execute Rule Removal for a specific rule.
3. Is there any way to track who specifically deleted a mapping rule from a Rule Set?
4.  Is it possible to track row deletions and updates to the FEM_RULE_SET_MEMBERS table through Oracle Applications?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
     Answer 1 : The following query can be run to find the person who last updated a Rule Set:
     Answer 2 : The following query can be run to identify all Executed Rule Removal requests:
     Answer 3:  No, there is no way to track who removed a mapping rule from Rule Set. 
     Answer 4:  Yes. Oracle Applications does have this type of audit capability. 

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.