Allocation Failed with ORA-01400 on User Defined Dimension (Doc ID 1609553.1)

Last updated on FEBRUARY 15, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 6.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.1 to 8.0.1 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When attempting to run an Allocation on Ledger Stat, the following error occurs.

Error:
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
    oexn() SQL Function: [189] - SQL function not found! Oracle
    Error: ORA- 01400: cannot
insert NULL into ("ATOMIC"."LEDGER_STAT"."CUSTOM1_ID")

 

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