Concurrent Program

Emailing concurrent request output is a common requirement in any business. You can email a concurrent request output in Oracle Apps using Delivery Options while submitting the requestor using API FND_REQUEST.ADD_DELIVERY_OPTION or FND_DELIVERY. You should use this API when you are submitting a concurrent request from the backend using PL/SQL. I will explain how to […]

Oracle apps provide an option to define a concurrent program with a host as an execution option. For Linux, you can create a shell script and define the program on it. Many times a new developer ends with a Program exited with status 127 error while running the host-based concurrent program. In this article, let’s explore

FND_FILE is a built-in package provided in Oracle Apps/E-Business Suite to write log and output files in PL/SQL concurrent program. This is actually a wrapper on UTL_FILE to write files on the Unix server. You can open the log and output file using navigation View -> Requests -> Find. Select the respective request on the

Recently upgraded from Oracle Applications (apps) version 11.5.10 (11i) to 12.1.3. (R12). You observed that your concurrent programs not working, you are not able to see any value in some of the parameters of concurrent programs? Is anything wrong with Upgrade? No. There is nothing wrong with the upgrade. Oracle E-Business suite introduced MOAC (Multi-Organization Access

The concurrent Program is one of the most important functionalities available in Oracle Apps. It allows users to submit jobs parallelly. These programs run in the background and asynchronous manner. You can submit multiple instances of the same program. A concurrent manager controls and manages the running of all these programs. This is the way

The host is one of the execution methods available in Oracle Apps while defining concurrent program executable. It allows the concurrent program to execute operating system commands. Here, host (Operating System) could be Windows, Unix, or any supported operating system. Here, let’s see how to define Unix host based concurrent program. UNIX/Linux is the most

You might have noticed Executable options field while defining a concurrent program in Oracle Apps. What is the significance of executable options? Introduction Executable options allow passing runtime parameter to executable. Mostly it is used for executable based on Oracle Report or XML Publisher. In this article, let’s see the significance of executable options field

As discussed in last posts, concurrent programs in Oracle Apps allows submitting multiple concurrent programs. You can even submit multiple instances of the same program at the same time. In such case, multiple runs of the same program can interfere with each other if underline logic is not defined to run in parallel. It may

Oracle Reports is an enterprise reporting tool. You can generate reports in any popular format for web and paper, burst, and distribute reports to any destination. Businesses get immediate access to information to all levels within and outside of the organization in an unrivaled scalable and secure environment. Oracle Reports is the one of execution

SQL* Plus is one of the executable methods available while defining a concurrent program in Oracle Apps. It allows running SQL* Plus script against the Oracle ERP database under Oracle Apps Environment following all security and access control. This method helps to create some ad-hoc script as a concurrent program. Ideally, convert this standalone script