Search Results fnd_request_copy




Overview
Explore in AI Chat

Overview

FND_REQUEST_COPY is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, documented in ETRM with a status of VALID and classified as an OTHER-type API. It resides in the Concurrent Processing layer of the FND (Application Object Library) product family. Its purpose is to support the internal copy operation of concurrent requests—reproducing an existing concurrent request definition and its associated arguments so that a request can be resubmitted or duplicated without manual re-entry of its parameters. The package is fundamental to the "Copy" and "Resubmit" actions available in the Submit Requests and View Requests forms, and it works in conjunction with the concurrent manager infrastructure. In the documented 12.2.2 metadata the package exposes a single documented procedure or function, REQUEST_ARGS, which encapsulates the argument-handling portion of the copy operation.

Key Procedures and Functions

The ETRM documentation for FND_REQUEST_COPY lists one documented procedure or function: REQUEST_ARGS. By its name and its role within a package named FND_REQUEST_COPY, REQUEST_ARGS handles the argument component of a request copy. When a concurrent request is copied or resubmitted, the source request's argument values (as stored for the concurrent request) must be transferred or re-associated with the new request record. REQUEST_ARGS provides this behavior programmatically. Because the ETRM metadata does not publish a parameter list, the signature is not reproduced here; callers should reference the package specification for the exact argument list before invoking it from custom code. No other procedures or functions are documented for this package.

Tables Accessed

The documented table references—resolved through APPS synonyms—are FND_CONCURRENT_PROGRAMS, FND_CONCURRENT_REQUESTS, and FND_CONC_REQUEST_ARGUMENTS. FND_CONCURRENT_PROGRAMS defines the concurrent program or executable associated with the request being copied, allowing the copy operation to validate and re-establish the program context. FND_CONCURRENT_REQUESTS is the master repository of concurrent request records; the copy operation reads the source request and, in related processing, drives the creation of the new request row. FND_CONC_REQUEST_ARGUMENTS stores the individual argument values submitted with a concurrent request, and it is the primary table manipulated by REQUEST_ARGS when reproducing argument data for the copied request. Together these tables constitute the minimum set needed to clone a request definition and its runtime arguments.

Usage Notes

FND_REQUEST_COPY is not an end-user-facing API; it is invoked internally by Oracle EBS forms such as Submit Requests and View Requests when a user selects the Copy or Resubmit action, and it may also be called from the Concurrent Manager processing stack. Because the package is not documented as being referenced by other packages (0 dependents in the ETRM metadata), customizations should treat it as an internal Oracle-owned object rather than a supported integration point. Custom developers who need to copy or resubmit requests programmatically are generally advised to use supported alternatives such as FND_REQUEST.SUBMIT_REQUEST to resubmit with explicit arguments, rather than invoking FND_REQUEST_COPY directly. Where direct invocation is unavoidable, developers must ensure the executing user has appropriate privileges on the FND_CONCURRENT_REQUESTS and FND_CONC_REQUEST_ARGUMENTS tables and must be aware that the package signature may change across EBS patch levels. Support of FND_REQUEST_COPY is governed by standard Oracle EBS licensing and support terms; any modification to this package invalidates Oracle support for it.