Upgrade issue for Select Distinct

[Former Member]

Hello Friends,

Our system is currently migrated from 4.7 to ECC 6.0 and now we are facing the issue in select distinct. As data comes with random sequence which was not in 4.7.  I also know that we need to use Order By with Distinct to resolve the issues.  But to apply this thing in every program would not be feasible issue.

So please let me know if any suitable note can be applied or it is the issue in Kernel level or Oracle database.

Regards,

Shiv.

[Former Member]

Hello.

Found out the solution for this. Issue is due to rebuilding of index which should be run by DB13 but somehow this does not run.

Thanks.

[Former Member]

Hello.

Found out the solution for this. Issue is due to rebuilding of index which should be run by DB13 but somehow this does not run.

Thanks.