Mapping Rule Errors With ERROR: APP-FEM-416952: No records to process. When CURRENCY_TYPE_CD = "ENTERED' (Doc ID 467649.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Profitability Manager - Version: 11.5.10.2 to 12.0.3
Oracle Enterprise Performance Foundation - Version: 11.5.10.2 to 12.0.3
This problem can occur on any platform.

Symptoms

When attempting to run Profitability Mapping Rule, the following error occurs when currency_type_code is ENTERED:

ERROR: APP-FEM-416952: No records to process. Edit the Mapping rule or the run time parameters. Rule Name: ALL.

 Steps To Reproduce:

1. Populate FEM_BALANCES with rows with currency_type_code = ENTERED
2. Create mapping rule simple source on allocation with FEM_BALANCES as source and debit.
3. Run the rule.
Complete successful but with no output. In the output log we can find:
APP-FEM-416952: No records to process. Edit the Mapping rule or the run time parameters. Rule Name: ALL.
APP-FEM-416624: Not all ORACLE driver copies destroyed.

If the currency_type_code is updated to TRANSLATED there is output generated as intended.

The Oracle Profitability Manager User's Guide, Release 11i, Part No. B31407-01 specifies:
"The engine ignores rows that are designated CURRENCY_TYPE_CODE=Translated.  It only processes rows for which CURRENCY_TYPE_CODE = Entered"

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