Search Results submit_set

Overview

FND_CP_RT_PKG is a Concurrent Processing PL/SQL regression testing package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to exercise and validate the concurrent processing infrastructure rather than to support a functional business flow such as order entry, purchasing, or general ledger posting. The package is classified as OTHER in the ETRM data dictionary, which is consistent with its role as an internal diagnostic and verification utility rather than a public integration API.

The package body is attribute-driven, with a header version of 120.2 and an original creation credit to Christina Clark. It is designed so that a developer or support analyst can execute a small set of routines that submit concurrent requests, sub-requests, and request sets, then verify that the concurrent manager processed them correctly and that session and instance-level information is consistent. Because the package is referenced by zero other packages, it is a leaf-level utility invoked directly by a user, a concurrent program definition, or a test harness rather than being called from application logic.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions within FND_CP_RT_PKG: FND_CP_RT_PROC, SLEEP, BASIC, VERIFY_VALUES, SUBMIT_SINGLE_REQUEST, SUBMIT_SUB_REQUEST, SUBMIT_REQUEST_SET, and FINISH. The source excerpt exposes the implementation of several of these, confirming their behavior.

• SLEEP — Pauses execution for a caller-supplied duration. It writes start and finish timestamps to the concurrent request log via FND_FILE and calls DBMS_LOCK.SLEEP to perform the actual wait. This allows testers to simulate long-running jobs and observe concurrent manager behavior over time.
• BASIC — Runs the program in a stripped-down fashion. It writes a start and end marker for the concurrent processing regression test to the log and sets the standard concurrent program OUT parameters errbuf to 'Success' and retcode to 0. This routine provides the minimal compliant concurrent program skeleton.
• SUBMIT_SINGLE_REQUEST — Submits one concurrent request as part of the regression test, exercising the request submission path.
• SUBMIT_SUB_REQUEST — Submits a request that is a child or sub-request, exercising parent/child request relationships and phase propagation.
• SUBMIT_REQUEST_SET — Submits a request set, exercising the request set and set-member execution path. This is the routine most closely associated with the search term "submit_set", as it is the documented entry point for validating request set behavior.
• VERIFY_VALUES — Checks that expected values were produced by the preceding submissions, serving as the assertion step of the regression test.
• FINISH — Concludes the test run, performing final logging and cleanup consistent with the BASIC end marker.
• FND_CP_RT_PROC — The package-level driver procedure that orchestrates the regression test, invoking the supporting routines in sequence.

Private helper logic includes a section_title routine that formats FND_FILE.OUTPUT and FND_FILE.LOG with separator lines and section headers. Parameter lists for the public procedures are not fully documented in the ETRM metadata and should not be assumed beyond the OUT errbuf/retcode convention shown for BASIC.

Tables Accessed

The package reads and writes several objects through APPS synonyms, all of which are consistent with concurrent processing diagnostics.

• FND_CONCURRENT_REQUESTS — The central concurrent processing table. The package queries and inspects this table to confirm that submitted single requests, sub-requests, and request set members were created and completed with the expected phase and status.
• FND_PRINTER — Referenced when validating printer or output destination configuration associated with concurrent request submission.
• DBMS_LOCK — Used by the SLEEP procedure to suspend execution for a specified interval.
• DUAL — Used for simple scalar queries and expressions during verification.
• NLS_SESSION_PARAMETERS — Queried to inspect the session's NLS environment, which can affect date and number formatting in concurrent output.
• V$INSTANCE — Queried to confirm the database instance on which the concurrent request executed, supporting multi-node or RAC diagnostics.

Usage Notes

FND_CP_RT_PKG is typically invoked directly rather than through a form or a business flow. A common pattern is to define it as a concurrent program with the BASIC or FND_CP_RT_PROC procedure as the executable, register the program in the Concurrent Programs form, and submit it from the Submit Requests window. Because BASIC satisfies the standard concurrent program interface by accepting errbuf and retcode OUT parameters, it can be registered as a standalone program for smoke-testing the concurrent manager.

Support and development teams also call the package from SQL*Plus or from a custom PL/SQL test harness when diagnosing request set submission problems, sub-request phase propagation, or concurrent manager throughput. It should be treated as a test utility and restricted to non-production or controlled environments, since its submission routines create real concurrent requests. Because no other package references FND_CP_RT_PKG, its removal or modification does not affect application functionality.