My Oracle Support Banner

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:

Primavera Unifier - Version 23.12 and later
Primavera Unifier Cloud Service - Version 23.12 and later
Information in this document applies to any platform.


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.

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

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.




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.