can you reproduce it here apex.oracle.com?
can i give you both the excel file and sql query, if need data in table i vl import and come back to you
Sorry for the delay.
The issue for getting dulipicate data while using GPV Interactive Report to Exce
is due to the sort descending done in IG. For the sql query there was 1105 records which displayed in IG as Ascending order by default and if we verify the 1105 records in IG there is no duliplicate record and no duplicate record in download excel.
but when i use the Sort Descending (Not from Action --> sort) for the date and verified the 1105 records in IG and found that the record no 940 and 1040 are same. ie dulplicate and bcos of that if i download by using GPV REPORT TO EXCEL , i am getting duplicate in excel.
Instead of using the sort descending from IG Label , i tried the sort from Actions--> Sort -->descending and verified the IG and no duplicate found in IG and so no duplicate in excel.
Why its showing duplicate record in IG when using sort descending? (Not from Actions--Sort)