Profitability Manager ORA-01400 Error Running Mapping Rule (Doc ID 345056.1)

Last updated on NOVEMBER 05, 2008

Applies to:

Oracle Profitability Manager - Version: 11.5.10
This problem can occur on any platform.
Oracle Financial Services Applications (OFSA) 11i
Profitability Manager

Symptoms

When attempting to run Mapping Rule using Profit Manager received error ORA-01400: cannot insert
NULL into ("FEM"."FEM_BALANCES"."CURRENCY_CODE").

Mapping Rule Detail:
Formula: Source: FEM_BALANCES.FEM_CURR_PERIOD_AMT * Percent Distribution:
FEM_BALANCES.FEM_CURR_PERIOD_AMT.

ERROR
APP-FEM-416515: Either USD, , or both currencies are invalid.
APP-FEM-416953: Exchange rate not found between From Currency USD and To
Currency . Defaulting to "1.0" for exchange rate.

FEM_PLSQLAPI_ERROR (ERROR_TEXT=The following combination of Dataset and
Calendar Period is occurring more than once in the Dataset Group. Dataset:
Actual Calendar : Year 2004 . This row in the input list is not being used for
dataset where clause generation)

APP-FEM-416921: Failed to register chain for object 10581 and request 245224.
APP-FND-01564: ORACLE error 1400 in drv_upi
Cause: drv_upi failed due to ORA-01400: cannot insert NULL into
("FEM"."FEM_BALANCES"."CURRENCY_CODE")

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