Executed Rules Screen Output Record Count Does Not Equal Actual Output Count (Doc ID 405283.1)

Last updated on NOVEMBER 06, 2008

Applies to:

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

Symptoms

In Profitability Manager, in the "Executed Rules" screen, the "Output Record Count" value does not equal the number of records actually written to the output table by a Mapping Rule.

Get the "Output Record Count" by navigating to:

Get the number of records output by the Mapping Rule by running a query like the following:

select currency_code, currency_type_code, dataset_code, cal_period_id, ledger_id, last_updated_by_object_id, count(*)
from fem_balances
where last_updated_by_object_id = <insert Object ID of Mapping Rule>
group by currency_code, currency_type_code, dataset_code, cal_period_id, ledger_id,
last_updated_by_object_id;

The two values do not match.

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