Executed Rule Removal Request Completes Successfully But Mapping Rule Results Remain in FEM_BALANCES (Doc ID 1376690.1)

Last updated on NOVEMBER 20, 2011

Applies to:

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

Symptoms

In Oracle Profitability Manager (PFT) 11.5.10.2, after one Mapping Rule's Results Removal process ran for an unusually long amount of time, the results of the next Mapping Rule are not removed from the FEM_BALANCES table when the Executed Rule Request Removal program is run for it.  While the request completed without an error, rows associated with the Request ID of the Mapping Rule still exist in FEM_BALANCES.  Additionally, data in the View Log lists the Request ID of the first Mapping Rule removed and not the second. The second Mapping Rule removed is dependent on the results of the first Mapping Rule removed.

If you run the Executed Rule Request Removal program for the second Mapping Rule with FND: Debug set to "Yes", the following error appears in FND_LOG_MESSAGES:

STEP 2: Delete object execution from process lock tables (FEM_PL_xxxx).
ORA-01403: no data found

None of the FEM_PL_xxxxxx tables contain rows associated with the second Mapping Rule's Request ID.

The issue prevents you from removing rows associated with the second Mapping Rule's Request ID from the FEM_BALANCES table.

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