Tuesday, April 16, 2013

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.


No comments:

Post a Comment