Some Business Process Records Are Not Displayed When the Log Columns Are Sorted Ascending or Descending (Doc ID 3004271.1)

Last updated on FEBRUARY 27, 2024

Applies to:

Symptoms

When viewing a Business Process (BP) log page in a specific Project there are more than 10,000 records created for that BP. Example: Record Numbers BP1-0001 through BP1-10200 exist in the log. The highest number of records that can be viewed on a page is 10,000. A View is created that will filter out BP records with a specific status and this reduces the number or records displayed to 9500. When sorting by the "Record Number" column in ascending order, the records are displayed from BP1-0001 to BP1-9999 viewing from top to bottom. When sorting descending in the same column the records are displayed from BP1-9999 to BP1-0001 top to bottom, so records equal to or greater than BP1-10000 are not displayed no matter the sort order.

EXPECTED BEHAVIOR
----------------------------
When sorting the log view descending, the top record should be the highest number record in the list.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Log into the Unifier environment.
2. Navigate to a Project that has more than 10,000 records for a specific Business Process > User Mode > Upper BP Node > BP1 > Select View "No Cancelled Records" > Bottom left of page changes from Total: 10200 to Total: 9500. Bottom right of page displays 10000 Per Page.
3. Click "Record Number" column to sort ascending and records BP1-0001 through BP1-9999 are displayed.
4. Click the same column again to sort descending and this time records BP1-9999 through BP1-0001 are displayed.
5. Click the "Creation Date" column descending and then BP records that exceed BP1-10000 are now displayed and sorted by the most recent.

Changes

Cause

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