Allocation Model Fails with 'ORA-03114: not connected to ORACLE' in Messageserver Log (Doc ID 2078496.1)

Last updated on NOVEMBER 19, 2015

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT) 8.0 with OFSAA Infrastructure 8.0.1, you get the following error in the messageserver log, msg_trace_file.log, in $FIC_DB_HOME/log when running an Allocation Model:

Error Msg :-> ORA-03114: not connected to ORACLE

Log Message here 1: Wed 11 Nov 2015 04:37:42 PM CST||SEVERE||WriteToDataBase: Error, Could not execute insert statement ...Error code ...3114...Error message ...ORA-03114: not connected to ORACLE

Log Message here 1: Wed 11 Nov 2015 04:37:42 PM CST||WARN||ThreadMessage::PopFromQ : s_pLogger->Write failed
Log Message here 1: Wed 11 Nov 2015 04:37:42 PM CST||INFO||Message : FASG_203918_EXEC_20150731_2: ICC: NOTASKID: ICC_0004: ICC.BATCHMONITOR.BATCH_START: APPUSER: INFORM: NOMESSAGE

The Allocation Model errors out after processing 1 or 2 allocations.  These errors do not occur if the Allocations are run individually.

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