ALM Cash Flow Generation Fails When Multiple Tasks Initiated within the Same Batch
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)
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms