Search Results fnd_cp_rt_proc




Overview
Explore in AI Chat

Overview

FND_CP_RT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the OTHER API category. Its stated purpose, taken directly from the package header comments, is Concurrent Processing PL/SQL regression testing. The package was created on 21-DEC-2002 by Christina Clark and carries a version identifier of 115.3 dated 2003/02/13. It is declared with AUTHID CURRENT_USER, meaning that its unqualified object references resolve under the privileges of the invoking user rather than the package owner.

The package is not a functional business API. It exists to exercise and validate the Concurrent Processing infrastructure of Oracle EBS — the Concurrent Manager, the request submission pipeline, request sets, child requests, and the log/out file lifecycle. It is an internal diagnostic and testing utility rather than an interface intended for customer application logic. As documented, it is referenced by zero other packages, reinforcing its standalone, tooling-oriented role. This behavior is consistent across both Oracle EBS 12.1.1 and 12.2.2, where the package remains a regression aid for concurrent processing rather than a supported integration point.

Key Procedures and Functions

Eight documented procedures constitute the public interface:

  • FND_CP_RT_PROC — The main concurrent program procedure and default entry point. It accepts error buffer, return code, a run mode, a duration, and three typed parameters, then orchestrates the regression test flow.
  • SLEEP — Pauses execution for a specified number of seconds, allowing request duration and manager polling behavior to be exercised.
  • BASIC — Runs the program in a stripped-down fashion, providing a minimal path through the concurrent program lifecycle.
  • VERIFY_VALUES — Selects and displays data, used to confirm that parameter values were passed and persisted correctly.
  • SUBMIT_SINGLE_REQUEST — Submits a single request, exercising the standard request submission path. This is the procedure most frequently referenced when users search for "submit_single_request."
  • SUBMIT_SUB_REQUEST — Submits a single child request, validating parent/child request relationships.
  • SUBMIT_REQUEST_SET — Submits a request set, testing multi-request scheduling and set-level processing.
  • FINISH — Writes a message indicating that all phases have completed, marking the successful end of the test run.

Tables Accessed

The documented table references (through APPS synonyms) support both request submission and environmental verification:

  • FND_CONCURRENT_REQUESTS — The core concurrent request table, read and written as requests and child requests are submitted and their status monitored.
  • FND_PRINTER — Referenced for printer and output destination resolution during request submission.
  • DBMS_LOCK — Used to control timing and concurrency behavior during regression runs.
  • DUAL — Used for simple single-row selection and validation queries.
  • NLS_SESSION_PARAMETERS — Read to confirm session-level language and territory settings.
  • V$INSTANCE — Read to identify the database instance under test.

Usage Notes

FND_CP_RT_PKG is normally invoked as a concurrent program definition registered in the Concurrent Programs form, where FND_CP_RT_PROC serves as the executable procedure. Because it is a regression testing package, it is typically run by technical staff, DBAs, or Oracle support during patching, upgrades, or concurrent manager troubleshooting rather than by end users. Its results appear in the standard concurrent request log and output files. Custom code should not depend on this package, as it is an internal, unsupported testing utility and may change between releases. Its presence in a system confirms only that the concurrent processing regression test scaffolding has been deployed.