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 11.5.10.2 [Release 11.5]
Information in this document applies to 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

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
Symptoms
Cause
Solution
References


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