Executed Rules Screen Output Record Count Does Not Equal Actual Output Count
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.
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