My Oracle Support Banner

Undo / Executed Rule Removal Does Not Remove Data from FEM_BALANCES (Doc ID 743416.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Profitability Manager - Version: 11.5.10 to
Oracle Enterprise Performance Foundation - Version: 11.5.10 to
This problem can occur on any platform.


After completing the Undo or Executed Rule Removal for a Mapping Rule, when querying on the results, it is found that not all the generated records were correctly deleted from FEM_BALANCES.  However, the Request ID is no longer available for Executed Request Rule Removal in the concurrent process or from the Executed Rules UI.

The number of records that should have been undone is less than 500,000 and therefore not related to  <> FEM.D.1: EXECUTED RULE REMOVAL CANNOT UNDO MAPPING RULE 500K RECORDS.

It is possible there were tablespace errors or database issues which caused the Undo to fail while processing.


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

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