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 JANUARY 30, 2022

Applies to:

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


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.


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.