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

Last updated on OCTOBER 23, 2015

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.

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