My Oracle Support Banner

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

Last updated on APRIL 02, 2019

Applies to:

Oracle Profitability Manager - Version 11.5.10 to [Release 11.5]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 11i
Profitability Manager


When attempting to run Mapping Rule using Profit Manager received error ORA-01400: cannot insert

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

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.