Concurrent Program

Business users sometimes need functionality to email the output of the concurrent program as soon as it completes. Let’s see how to email concurrent request output in Oracle Apps You can achieve this using another custom concurrent program based on Unix, PL/SQL so send an email of a concurrent program. Unix provides mailx and in […]

fnd_request.submit_request Oracle Apps PL/SQL API helps to submit the concurrent program from the backend. backend means from the Database. fnd_request.submit_request Below is the signature of fnd_request.submit_request  API. This function submits a concurrent request for processing by concurrent Manager and returns, request id – if the request is submitted successfully 0 – if the request is not

How to make Parent concurrent request to wait until all child concurrent programs complete in Oracle Apps? So what we are looking at here is a Parent program that submits multiple child requests at once and waits till all child programs complete either successfully. Oracle apps provide a built-in package FND_CONC_GLOBAL and FND_REQUEST to achieve

Concurrent programs in Oracle Apps are batch jobs.  You can define a concurrent program on PL/SQL stored procedure, Oracle Reports, Host – an Operating system based execution file, Perl, C or Pro* C based spawned program, Java file. Here, I will show you how to define concurrent programs in Oracle Applications (Apps). We will use

This article explains, how to enable trace for Concurrent Program and generate TKPROF in Oracle Apps. These steps should work for Oracle Apps 11i and R12 release. Concurrent programs execute business logic by connecting to the database and performing database operations like updating, inserting, and deleting. These operations consume CPU, Memory, and other resources. An