Roll up job ends with deadlock error when both rollup and team rules are defined
Last updated on NOVEMBER 05, 2016
Applies to:Oracle Fusion Incentive Compensation Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : Rel 9.2 version, Rollup and Team Rules
Received deadlock and endless processing
On upgrade to R9, customer got 2 deadlock errors when trying to run rollup.
Of the 15 processes running, 14 had completed within 5 minutes, and had to cancel one process due to it running continuously for 1 hour. Process ID for cancelled rollup was 122202.
The issue can be reproduced at will with the following steps:
1. Create rollup and team rules
2. Run rollup job in TOTAL mode multiple times
The issue has the following business impact:
Due to this issue, users unable to completely run rollup process
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