Custom Report upgraded from 6i to 10.1.2.0.2 is not showing output

Hi,

 

We are in the process of upgrading to oracle apps R12.1.3, so we are migrating the custom reports from version 6i to Reports version 10.1.2.0.2

the report query if i run in before-report trigger returns the data (proving the query is fine and should get data), but the report is not showing any output.

i have added a debug code in the report query (autonomous commit), and no debug is logged when i run the report from SRS.

it shows that report query is not being executed, any idea what causing this issue?

 

another test i did is, commented the user exits and set the org context in before report trigger and ran the report from the Report Builder and the report is returning the data correctly...