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:
- Profitability Manager
- Process Management → Executed Rules
- Search for the Mapping Rule
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(*)
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!