Allocation Batch Hangs in Ongoing While Processing Lookup Table Driver Allocations (Doc ID 2071150.1)

Last updated on FEBRUARY 02, 2016

Applies to:

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

Symptoms

In Oracle Financial Services Profitability Management (PFT) 6.1.x, when you run a Batch containing Allocations, the batch sporadically hangs in an ongoing status while processing a Lookup Table Driver Allocation.  The Allocation process (ofspa) remains on the server but never completes.

The batch does not hang at the same Allocation every time.  However, it always hangs when running a Lookup Table Driver Allocation.

Additionally, the ofspa log in $FIC_DB_HOME/log/FusionApps for the Lookup Table Driver Allocation always has the following at the end:

If you re-run the Batch, all Allocations complete successfully.  You do not understand why the Allocations hang at random.  This causes the processing cycle to stop.

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