Search Results fnd_submit




Overview
Explore in AI Chat

Overview

FND_SUBMIT is the core PL/SQL package body in Oracle E-Business Suite Concurrent Processing that provides the programmatic interface for defining and submitting concurrent requests, request sets, and their associated output and delivery options. The package encapsulates the server-side logic used throughout the EBS runtime to construct a submission, apply repeat and increment-date rules, resolve NLS and organization context, assign printers and delivery destinations, and finally hand the request to the concurrent manager. It is classified under ETRM as an OTHER API package owned by APPS and is the same object referenced when users search for "set_request_set," the procedure that associates an inline request set definition with the pending submission.

Because request sets (and their constituent stages and programs) are themselves stored as concurrent definitions, FND_SUBMIT bridges the definition side of the data model — FND_REQUEST_SETS, FND_REQUEST_SET_PROGRAMS, and FND_REQUEST_SET_STAGES — with the execution side, FND_CONCURRENT_REQUESTS and FND_RUN_REQUESTS. It is a heavily reused dependency, referenced by 17 other packages across the applications schema.

Key Procedures and Functions

The documented interface exposes 27 procedures and functions organized around configuration, set content, and delivery:

Tables Accessed

The package reads application and program metadata from FND_APPLICATION and FND_CONCURRENT_PROGRAMS to resolve executable definitions and application short names. Request set structure is read from FND_REQUEST_SETS, FND_REQUEST_SET_PROGRAMS, and FND_REQUEST_SET_STAGES; the ordering logic accounts for multiple occurrences of the same program within a stage using the RSP sequence. Execution and run context are stored in FND_CONCURRENT_REQUESTS, FND_RUN_REQUESTS, and FND_RUN_REQ_PP_ACTIONS. Printing and delivery configuration is sourced from FND_PRINTER, FND_PRINTER_INFORMATION, FND_PRINTER_STYLES, FND_CP_DELIVERY_OPTIONS, FND_CP_DELIVERY_COMMANDS, and FND_CP_IPP_PRINTERS. DUAL supports simple expression evaluation.

Usage Notes

FND_SUBMIT is invoked from concurrent program forms, the Submit Request form, request set definitions, and custom code that programmatically launches requests. Typical custom usage chains SET_NLS_OPTIONS, SET_ORG_ID, and optional SET_PRINT_OPTIONS or ADD_PRINTER calls before SUBMIT_PROGRAM or SUBMIT_SET. Because the package maintains private package state (P_OPS_ID, P_SET_ID, P_PRINT_STYLE, and similar variables), option setters must precede the submit call within the same session. Applications upgrading between 12.1.1 and 12.2.2 should note the notification record changes documented in the source header.