My Oracle Support Banner

SOA 11G BPM WorkList: the Order of the Results Fluctuates, Causing Duplicate or Missing Rows to Appear in the Pagination (Doc ID 1308369.1)

Last updated on NOVEMBER 13, 2023

Applies to:

Oracle SOA Suite - Version 11.1.1.1.0 to 11.1.1.4.0 [Release 11gR1]
Information in this document applies to any platform.

Goal

When using the SOA API to present tasks in WorkList pagination the following behaviour can be observed:

When querying a view that has the sort column set to a non-unique field, such as Updated Date, the order of the results fluctuates, causing duplicate or missing rows to appear in the WorkList pagination. What typically happens is, that the last row of a range will appear in the beginning (first or second row) of the next range.

Solution

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