How To Create A PL/SQL Concurrent Program That Will Call Child Requests Using fnd_request.submit_request() (Doc ID 2282106.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Application Object Library - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

This document describes the steps to create a concurrent program (CP) that will allow the execution of multiple child concurrent programs. The program that will be submitted as a child is the ‘Active Users’ CP, so when you execute the new PLSQL program you will create (TESTPLSQL), it will spawn two child concurrent requests for the ‘Active Users’ concurrent program pointing to the respective parent concurrent request ID.

This sample code is provided for educational purposes only, and is not supported by Oracle Support. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using it.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms