My Oracle Support Banner

Incorrect Sorting in the Notes And Attachments Section of the Case Form When CASE_NOTES_ATTACH.SEQ_NUM Reaches a Certain Value (Doc ID 2472230.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 7.0.5 to 8.1 [Release 7.0.0 to 8.1]
Information in this document applies to any platform.

Symptoms

When attaching documents in the Notes and Attachment section of the Case Form > Additional Information tab, the records are correctly displayed in chronological order with the latest record at the bottom of the list.  However, when the SEQ_NUM of CASE_NOTES_ATTACH table increases by one digit the latest attachment record is no longer displayed in the bottom row.

Example 1 - Correct Default Sort Order in Notes and Attachment Section

SEQ_NUM       Default Sort Order       
100328        1
100329        2
100330        3
100331        4
100332        5
100347        6


Example 2 - Incorrect Default Sort Order in Notes and Attachment Section

SEQ_NUM       Default Sort Order
100328        1
1003290       5    <---
100330        2
10033100      6    <---
100332        3
100347        4

 

Changes

 

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!

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