My Oracle Support Banner

Profitability Management Interface and Processes Hang After Several Days of User Activity (Doc ID 1449789.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 to 7.2.12 [Release 7]
Oracle Financial Services Profitability Management - Version 5.2 to 5.6 [Release 5]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT) 5.6, after a certain period of time using the interface (ex. several days), users either cannot save their Allocations or the Allocation save is very slow.  Additionally, the Allocation processes are extremely slow or  hang.

There are many users performing actions in Profitability Management.

The following error is found repeatedly in the FUSIONSUBSYSTEMSService.log in the web server:

[FUSIONSUBSYSTEMS] Jan 24,12 10:33:35 : [CONNECTIONS]
javax.naming.NameNotFoundException: Name "jdbc/FSGBU" not found in context "java:comp/env".
at com.ibm.ws.naming.ipbase.NameSpace.lookupInternal(NameSpace.java:1178)
at com.ibm.ws.naming.ipbase.NameSpace.lookup(NameSpace.java:1095)

Additionally, you find there are many inactive sessions in the Oracle database from JDBC THIN CLIENT.

If all of the OFSAA server processes are stopped and re-started, the problem is resolved but it occurs again after a certain period of time.

Steps to Reproduce:

  1. Go to Profitability Management
  2. Go to Rule Specification > Allocation Specification
  3. Edit an Allocation and Save

The Save is very slow or never completes.

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.