Report doesn't return data / srw.message not working

Sometimes when the query returns data from sql but fails from oracle report.
This happens mostly in multi org structure. Make sure you have the below checks.

1. Check if User Parameter has P_CONC_REQUEST_ID defined. No need to define this parameter in concurrent request definition.
2. SRW.USER_EXIT('FND SRWINIT');  has to be used in AfterPForm (After Parameter) trigger.
3. Run the report from correct responsibility.

Initialze ORG specific values in Oracle Reports

Use USER_EXIT('FND SRWINIT') in before report trigger along with 2 user parameters p_conc_request_id and p_org_id to initialize org specific values and data.