ALM Cash Flow Generation Fails When Multiple Tasks Initiated within the Same Batch (Doc ID 2139114.1)

Last updated on MAY 17, 2016

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.1 to 8.0.2 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

ALM Cash Flow Generation fails intermittently when multiple tasks are initiated within the same batch in parallel.

Error
ORA- 00001: unique constraint (ATOMIC.PK_FSI_RESULT_QUEUE) violated Driver Function:

Steps
1. Ran ALM process in a batch with 11 tasks via Batch Execution.
2. When executed with precedence set to be sequential (e.g. Task2 runs after Task1, Task3 runs after Task2), all execution completes without error.
3. When executed with no precedence set (e.g. meaning all tasks run concurrently), there is an intermittent unique constraint violation on FSI_RESULT_QUEUE.
4. Upon reviewing the logs, noticed that each task is checking, deleting , and inserting the same record into FSI_RESULT_QUEUE.

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