Search Results fnd_cp_request_set

Overview

FND_SUBMIT is the Oracle E-Business Suite public PL/SQL package that provides the programmatic APIs for concurrent request set submission and for controlling the attributes under which concurrent requests execute. In Release 12.1.1 and 12.2.2 it resides in the APPS schema and is classified by ETRM under the business entity FND_CP_REQUEST_SET, with a public scope and an active lifecycle. The package addresses a long-standing limitation of the standard FND_REQUEST API, which submits a single concurrent program at a time. FND_SUBMIT extends that model to request sets — the groupings of concurrent programs defined in FND_REQUEST_SETS, FND_REQUEST_SET_STAGES, and FND_REQUEST_SET_PROGRAMS — allowing custom forms, database triggers, and batch scripts to drive multi-stage, multi-program submissions with the same fidelity as the Submit Request and Submit Request Set forms.

Key Procedures and Functions

The package exposes twenty-seven documented procedures and functions, organized around a set-before-submit model. Setup routines establish the context for the run:

• SET_MODE — flags that the request originates from a database trigger, altering submission behavior accordingly.
• SET_NLS_OPTIONS — establishes language, territory, and request attribute values such as implicit-request handling and update protection.
• SET_ORG_ID — sets the operating unit context for the submission.
• SET_REPEAT_OPTIONS, SET_INCREMENT_DATES_OPTION, SET_REL_CLASS_OPTIONS — define repeat execution, date increment rules, and release class behavior for the run.
• SET_PRINT_OPTIONS, ADD_PRINTER — configure printing, including printer style and named destination printers.
• SET_REQUEST_SET — identifies the request set to be submitted.
• SUBMIT_PROGRAM and SUBMIT_SET — the core submission entry points for a single concurrent program and for a full request set, respectively.

A second group of routines attaches post-processing and output distribution actions: SET_DEST_OPS, ADD_LAYOUT, ADD_DELIVERY_OPTION, ADD_NOTIFICATION, ADD_EMAIL, ADD_FAX, ADD_FTP, ADD_WEBDAV, and ADD_IPP_PRINTER. These populate delivery commands, layouts, and Internet Printing Protocol printer definitions used by the Concurrent Processing delivery infrastructure.

Tables Accessed

FND_SUBMIT reads and writes a well-defined set of APPS synonyms. Definition data is drawn from FND_REQUEST_SETS, FND_REQUEST_SET_PROGRAMS, FND_REQUEST_SET_STAGES, FND_CONCURRENT_PROGRAMS, and FND_APPLICATION. Runtime state is recorded in FND_CONCURRENT_REQUESTS, with run-time control information in FND_RUN_REQUESTS and FND_RUN_REQ_PP_ACTIONS. Output and delivery configuration is resolved through FND_CP_DELIVERY_OPTIONS, FND_CP_DELIVERY_COMMANDS, FND_CP_IPP_PRINTERS, FND_PRINTER, FND_PRINTER_INFORMATION, and FND_PRINTER_STYLES. DUAL is referenced for simple evaluations. Collectively these tables support stage sequencing, program argument resolution, printer and delivery assignment, and the creation of concurrent request rows.

Usage Notes

FND_SUBMIT is invoked from custom Forms, database triggers, and concurrent programs where request sets must be submitted without user interaction. The conventional pattern is to call the SET_* routines first to establish mode, NLS, organization, repeat, and print context, then SET_REQUEST_SET, followed by SUBMIT_SET; delivery and notification routines are called before submission so that completed output is routed correctly. Because the package is public and marked compatible, it is supported for customer extensions, though it is sensitive to correct ordering — calling a submit routine before the context routines yields unpredictable request attributes. The package is referenced by seventeen other packages, and its behavior in 12.2.2 remains consistent with 12.1.1, making it a stable foundation for automated request set submission.