Wednesday, January 25, 2012

Call Concurrent Program with Configurator Extension

First you need to intialize Apps parameter.

             CallableStatement cspro =
             connection.prepareCall("{call FND_GLOBAL.APPS_INITIALIZE(?,?,?)}");
             cspro.setString(1, "0");
             cspro.setString(2, "20420");
             cspro.setString(3, "1");
             cspro.executeUpdate();
             cspro.close();

After that Use ConcurrentRequest class to submit request from the you java class.

             ConcurrentRequest cr = new ConcurrentRequest(connection);
             int requestId = cr.submitRequest("Application Name",
"Prog short Name", "Prog Description", null, false, parameter in vector);
             System.out.println(requestId);

check the status of the concurrent program.


SELECT * FROM FND_CONCURRENT_REQUESTS WHERE   REQUEST_ID=your request id.



mail me for any further info.




No comments:

Post a Comment