My Oracle Support Banner

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 MARCH 08, 2023

Applies to:

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


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.



To view full details, sign in with your My Oracle Support account.

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

In this Document
1. Create Stored Procedure
 2. Define Executable.
 3. Define Program
 4. Add program to Request group
 5. Test

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.