APP-FEM-416952: No Records to Process Running Statistic Mapping Rule (Doc ID 557172.1)

Last updated on FEBRUARY 18, 2009

Applies to:

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

Symptoms

In Profitability Manager 11i, a Mapping Rule that references two statistics tables returns no rows. The following message is in the Output Log:

APP-FEM-416952: No records to process.

The FEMCCE debug log shows the view used to process the records in the instrument table / FEM_BALANCES table and the two statistics tables (CreateViewByOFSA_SQL SqlStr). The view joins all three tables together using the columns specified in the Statistic definition:

Instrument table / FEM_BALANCES
Statistic Table #1
Statistic Table #2

Steps To Reproduce:

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