My Oracle Support Banner

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.


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,

The two values do not match.


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.