How to get request id of concurrent program in oracle apps

How to get request id of concurrent program in oracle apps

In this post , we will discuss about How to get request id of concurrent program in oracle apps. Concurrent Program Request Id is the Concurrent Request Id. When we submits the Concurrent Program in Oracle apps then system runs these Concurrent Program as a concurrent request in oracle apps and system generates unique Concurrent Request id for each Concurrent Program. Some times we need to find out this Concurrent Request id to use in the Oracle Reports or in the PLSQL package so for this Oracle have given us some methods and profiles which we can use to get request id of concurrent program in oracle apps.

 

Steps to get request id of concurrent program in oracle apps

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:-

 

If You using the Oracle PLSQL Packages and you want to use the Concurrent Request id for that package in the Data base package then you can use this Standard Profile as below.

fnd_global.CONC_REQUEST_ID