Calling Concurrent Program in OAF public int submitRequest( String ProgramApplication,String ProgramName,String ProgramDescription,String StartTime,boolean SubRequest,Vector Parameters ) throws RequestSubmissionException ProgramApplication -Application Short name of application under which the program is registered. Home » APPS QUERIES » Find Concurrent Program Parameter Values for Last Run from Backend Wednesday, 11 January 2017 Find Concurrent Program Parameter Values for Last Run from Backend. We have now created the concurrent program, but now we want to run it. To be able to run it, we need to do some configuration. The concurrent program needs. Invoke concurrent programs in Oracle E-Business Suite using the WCF service model.; 4 minutes to read. For the concurrent programs that do not expose their metadata, the Oracle E-Business adapter exposes 100 optional parameters for each of these concurrent programs. Build the project and then run it.
OA Framework provides the ConcurrentRequest class to call the concurrent program from the page. The submitRequest() method in the ConcurrentRequest class takes 6 parameters and returns request id of the submitted concurrent request:public int submitRequest(
String ProgramApplication ,
String ProgramName ,
String ProgramDescription ,
String StartTime,
boolean SubRequest,
Vector Parameters ) throws RequestSubmissionException
ProgramApplication -Application Short name of application under which the program is registered.
ProgramName - Concurrent Program Name for which the request has to be submitted
ProgramDescription - Concurrent Program Description
StartTime - Time at which the request has to start running.
SubRequest - Set to TRUE if the request is submitted from another running request and has to be treated as a sub request.
Parameters - Parameters of the concurrent Request
Here is the example for calling a concurrent program from a OA framework page.
import oracle.apps.fnd.cp.request.ConcurrentRequest;
import oracle.apps.fnd.framework.server.OADBTransaction;
public int submitCPRequest(Number headerId) {
try {
OADBTransaction tx = (
Run Concurrent Program From Oaf Page
OADBTransaction)getDBTransaction();java.sql.Connection pConncection = tx.getJdbcConnection();
ConcurrentRequest cr = new ConcurrentRequest(pConncection);
String applnName = 'PO'; //Application that contains the concurrent program
String cpName = 'POXXXX'; //Concurrent program name
String cpDesc = 'Concurrent Program Description'; // concurrent Program description
// Pass the Arguments using vector
// Here i have added my parameter headerId
Run Concurrent Program From Oaf Pages
to the vector and passed the vector to the concurrent programVector cpArgs = new Vector();
cpArgs.addElement(headerId.stringValue());
// Calling the Concurrent Program
int requestId = cr.submitRequest(applnName, cpName, cpDesc, null, false, cpArgs);
tx.commit();
return requestId;
} catch (RequestSubmissionException e) {
OAException oe = new OAException
(e.getMessage());oe.setApplicationModule(this);
throw oe;
}
}
How to monitor the submitted concurrent request OA Framework
The Request Monitoring user interface provides the ability to search for a current user's requests. It allows the user to specify criteria to search for a request based on a specific request ID, requests for a specific program or a range of scheduled requests. Using the search results list, a user can select a request to see the details of that request or view its output file. From the Details page for a request, a user can place a hold on a pending request, cancel a pending request or view the request's log file.
You can call the Request Monitoring page by calling following URL