My Oracle Support Banner

OFSAA 8.1.2.2 Cash Flow Edits Process Failes With "ORA-01400: cannot insert NULL into ("OFSATOMIC"."FSI_O_CFE_EDITS_MESSAGES"."PK_COLUMN_VALUE")" (Doc ID 2999642.1)

Last updated on MARCH 01, 2024

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.1.2 and later
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI / AAI)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

ALM 8.1.2.2 Cash Flow Edits Process Failed while saving output in FSI_O_CFE_EDITS_MESSAGES.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Login to OFSAA >> Open FTP >> FTP Process >> Cash Flow Edits New >> Execute any CFE.

ERROR
-----------------------

CashFlowEngine log:

java.util.concurrent.ExecutionException: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("OFSATOMIC"."FSI_O_CFE_EDITS_MESSAGES"."PK_COLUMN_VALUE")

Changes

 

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
Changes
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.