How to get concurrent request id in oracle reports

How to get concurrent request id in oracle reports

In this post , We will be discuss about How to get concurrent request id in oracle reports. We register the Oracle reports as a concurrent program in oracle apps and we runs the Concurrent Program as a Concurrent Request in Oracle Apps and system generates the Unique concurrent request id for each concurrent program Concurrent Request in Oracle apps. In this Post , I will share the steps for How to get concurrent request id in oracle reports.

 

 

Steps to get concurrent request id in oracle reports

Step1:-If You using the Oracle reports and you want to use the Concurrent Request id for that report then you need to create one Parameter "P_CONC_REQUEST_ID" in the Report RDF and in the concurrent Program too. So when you will run this report through Concurrent Program Requests oracle system will pass this Concurrent request id in this Parameter and then you can use this in Oracle Reports.

 

 

 

 

 

Step2:- We need to create the same Parameter "P_CONC_REQUEST_ID" in the Report RDF too and srw.user_exit('FND SRWINIT') --- Should be in before report trigger             
srw.user_exit('FND SRWEXIT') -- Should be in After report trigger           

 

Have to be use in the Oracle RDF Triggers.