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 laterInformation 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
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
| Goal |
| Solution |
1. Create Stored Procedure |
| 2. Define Executable. |
| 3. Define Program |
| 4. Add program to Request group |
| 5. Test |