My Oracle Support Banner

Sort on Record Number Is Sorting by String Instead of the Record Number Itself (Doc ID 2546420.1)

Last updated on OCTOBER 12, 2019

Applies to:

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

Symptoms

On Unifier : After updating to version 18.8.7

The Business Process (BP) Log that is sorted by Record Number is sorting by string instead of the record number itself.

Expected Result: When the BP Sequence Policy is set to Company Based, and the BP log is sorted by Record Number, the record numbers should be ordered by record number.

Example: SMZ-22, SMZ-15, SMZ-14, SMZ-13, SMZ-12, SMZ-11, SMZ-10, SMZ-9, SMZ-3, SMZ-2, SMZ-1.

Actual Result: The BP log is sorting the records by string, or the digits in the record number, instead of the record number itself.

Example: SMZ-9, SMZ-3, SMZ-22, SMZ-2, SMZ-15, SMZ-14, SMZ-13, SMZ-12, SMZ-11, SMZ-10, SMZ-1

Cause

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
Symptoms
Cause
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.