VERIFIED SOLUTION i

Sagent Design Studio - Plan Parameter is not sorted

Product Feature: Design Studio

Database: Oracle

 

Issue

Design Studio - Plan Parameter is not sorted after Oracle upgrade.

Cause

This issue is specific to Oracle version difference. ' Distinct' is used differently in Oracle 9i and 11g which  causes the sorting to differ after upgrade.
 

Resolution

UPDATED: September 21, 2017
This is expected behavior with the change at Oracle DB level. No adverse effect was observed.