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

Last updated on OCTOBER 28, 2009

Applies to:

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

Symptoms

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  <<BUG 5365387>> 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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms