Spreadtables: Service Request and Tasks Not Sorted Properly by Number (i.e. Find Service Request, Tasks tab)
(Doc ID 2175680.1)
Last updated on JULY 21, 2020
Applies to:Oracle Teleservice - Version 12.1.3 and later
Information in this document applies to any platform.
Service Request (SR) or Tasks are not sorted in ascending/descending order properly based on SR or Task numbers.
In the "Find Service request" form, when searching for a SR by giving some parameters, the results are not sorted correctly when trying to arrange the results in ascending or descending order of the Service Request number.
When you sort a set of SRs or Tasks (say 108743, 89786, 90312, 100337, 19824), the expected output would be:
However, it considers all the elements starting with '1' as the lowest value, producing the following output:
A similar behavior can be observed when using SQL*Plus, against the base views (JTF_TASKS_V or CS_INCIDENTS_ALL_B) and using ORDER BY TASK_NUMBER (or REQUEST_NUMBER).
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