We had an upgrade from 11i to R12.
Few discoverer reports are not working.
When checked using discover plus some column names were found to be changed. I checked the fan trap and coorected the column names.
After correcting the column names report works fine in discoverer plus.
But when trying to view from viewer I get the error.
Join configuration cannot be resolved. Reason: more than 1 of the detail folders uses non-aggregated items. Attempt to open workbook failed.
As mentioned earlier I enabled fan trap and did changes and saved. But in viewer I am still getting this error.
Plz let me know how to handle this.