https://community.sap.com/t5/application-development-and-automation-discussions/upgrade-issue-for-select-distinct/m-p/9495976#M1746663 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>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.</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 08 Jul 2013 10:23:34 GMT Former Member 2013-07-08T10:23:34Z https://community.sap.com/t5/application-development-and-automation-discussions/upgrade-issue-for-select-distinct/m-p/9495975#M1746662 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>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.&nbsp; I also know that we need to use Order By with Distinct to resolve the issues.&nbsp; But to apply this thing in every program would not be feasible issue.</P><P></P><P>So please let me know if any suitable note can be applied or it is the issue in Kernel level or Oracle database.</P><P></P><P></P><P>Regards,</P><P>Shiv.</P></BODY></HTML> Fri, 05 Jul 2013 07:27:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/upgrade-issue-for-select-distinct/m-p/9495975#M1746662 Former Member 2013-07-05T07:27:19Z https://community.sap.com/t5/application-development-and-automation-discussions/upgrade-issue-for-select-distinct/m-p/9495976#M1746663 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>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.</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 08 Jul 2013 10:23:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/upgrade-issue-for-select-distinct/m-p/9495976#M1746663 Former Member 2013-07-08T10:23:34Z