Search Results fnd_conc_pp




Overview
Explore in AI Chat

Overview

FND_CONC_PP is a PL/SQL package body owned by the APPS schema that supports the Oracle E-Business Suite concurrent processing infrastructure, specifically the handling of concurrent program request parameters and their propagation across phases and actions. Within the Oracle EBS 12.1.1 and 12.2.2 releases, the package operates as a low-level utility layer that concurrent managers, the request submission engine, and the parameter validation framework call upon when a concurrent request moves through its lifecycle. It is classified as an OTHER API, meaning it is not a public, externally supported interface but rather an internal component of the FND concurrent processing schema.

The package is documented as VALID in the ETRM repository and is listed as not referenced by any other database object, although package metadata indicates it is referenced by two other packages. This dual signal suggests that FND_CONC_PP is predominantly an internal implementation detail whose direct callers are the standard concurrent manager and request-handling components rather than customer extensions.

Key Procedures and Functions

Three documented program units constitute the public surface of FND_CONC_PP:

  • MESSAGE — Handles the generation or retrieval of messages associated with concurrent program parameter processing. It is used to surface diagnostic or user-facing text when parameter actions are evaluated or when a request cannot proceed.
  • ASSIGN — Responsible for assigning parameter values or parameter-related attributes in preparation for concurrent request execution. It supports the mechanics by which runtime parameter values are bound to a request before the concurrent manager dispatches it.
  • RETRIEVE — Retrieves stored parameter information, either for display in a form, for re-submission, or for downstream processing by the concurrent manager. Together, ASSIGN and RETRIEVE form a matched pair for persisting and reading parameter state.

The parameter lists for these procedures are not published in the ETRM excerpt and must not be assumed; developers should inspect the package specification in the database for exact signatures.

Tables Accessed

The package body references the following base tables through APPS synonyms:

  • FND_CONCURRENT_REQUESTS — The central request registry; ASSIGN and RETRIEVE read and update parameter-related columns tied to a specific request ID.
  • FND_CONC_PP_ACTIONS — Defines the actions attached to concurrent program parameters, which drive the parameter submission workflow.
  • FND_EXECUTABLES — Provides executable metadata so parameter handling can be aligned with the correct program definition.
  • FND_APPLICATION and FND_APPLICATION_TL — Supply application identifiers and translated application names for message construction and lookups.
  • DUAL — Used for single-row evaluations and version checks.

The dependency list also includes FND_GLOBAL and the package itself, plus SYS.STANDARD, consistent with a package that relies on session context (FND_GLOBAL) and recursive internal calls.

Usage Notes

FND_CONC_PP is typically invoked indirectly. The standard Oracle Forms interface for submitting concurrent requests (the "Submit Requests" form) and the concurrent manager processes call into this package when parameters must be assigned, validated, or retrieved. Because it is classified as OTHER and is not referenced by any database object in the dependency listing, Oracle does not support direct invocation by customer code. Custom concurrent programs and extensions should rely on the supported FND_REQUEST and FND_CONCURRENT APIs instead. In upgrade or diagnostic scenarios, DBAs and technical consultants query the package source when investigating parameter propagation defects between 12.1.1 and 12.2.2.