My Oracle Support Banner

OFSAA ALM Batch Is Stuck in Ongoing Status for More Than 24 Hours (Doc ID 2792853.1)

Last updated on MARCH 02, 2023

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

OFSAA Batch running ALM process is stuck in "[10107] Ongoing" status for more than 24 Hours.

Other ALM processes are running fine, as expected.

No activity is found on Database side while process is still running.

After enabling "Show All SQL" in ALM Application Preferences -> Debugging Output Level, the log stopped generating any more info at INSERT to RES_DTL_XXXXXX table.

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