Last updated on FEBRUARY 18, 2009
Applies to:Oracle Profitability Manager - Version: 11.5.10
This problem can occur on any platform.
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:
- Go to the Profitability Manager responsibility
- Go to Business Rules > Mapping
- Run a Mapping Rule that uses two Statistics tables
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms