My Oracle Support Banner

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

Last updated on MARCH 19, 2021

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)


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

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

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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.