Search Results dpp_bpel_pollcreatenotif

Overview

DPP_BPEL_POLLCREATENOTIF is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. In releases 12.1.1 and 12.2.2, it forms part of the Oracle Demand Planning and Advanced Planning infrastructure, specifically the integration layer that bridges the EBS application tier with BPEL-based business process orchestration. The name itself is descriptive of its role: "DPP" identifies the Demand Planning product family, "BPEL" identifies the Business Process Execution Language middleware tier, "POLL" indicates a polling or wait-for-completion pattern, and "CREATENOTIF" indicates that the package supports the creation or dispatch of notifications associated with a request. In practice, the package exists to allow the EBS side of a distributed process to wait on, monitor, or respond to an asynchronous request initiated from the BPEL layer, ensuring that demand planning flows remain synchronized between the two systems.

Key Procedures and Functions

The ETRM metadata documents a single entry point for this package:

• WAIT_FOR_REQUEST — This procedure implements the polling behaviour implied by the package name. It blocks or repeatedly checks the state of an outstanding request until that request reaches a terminal or reportable condition, at which point control returns to the caller. In the context of BPEL integration, this supports a synchronous-looking handshake over an inherently asynchronous invocation: the BPEL process submits work, and the EBS-side package waits for confirmation or completion before notification creation proceeds. The procedure name and the package classification of OTHER indicate it is an internal helper rather than a public, instance-facing API.

No further procedures or functions are documented in the ETRM repository for this object. The parameter interface for WAIT_FOR_REQUEST is not published in the metadata and should be verified directly against the package specification in the target environment before any custom invocation is attempted.

Tables Accessed

The documented metadata lists no directly referenced application tables through APPS synonyms. The only dependency recorded is on SYS.STANDARD, which appears because every PL/SQL unit implicitly depends on the STANDARD package for base type and exception definitions. This suggests that WAIT_FOR_REQUEST interacts with its request state either through internal PL/SQL constructs, through the Oracle Application Object Library request utilities, or through database objects not captured in the excerpted dependency list. The package also references, and is referenced by, itself, which is consistent with internal recursive calls or nested subprogram usage. For a definitive view, the dependency chain should be re-queried in the customer instance using ALL_DEPENDENCIES for the package body.

Usage Notes

DPP_BPEL_POLLCREATENOTIF is an internal integration utility and is not intended for direct end-user or custom application use. It is most likely invoked in one of three contexts:

• Indirectly by BPEL composites or SOA Suite processes that call EBS demand planning services and require a wait-for-completion or notification step.
• From concurrent program or request-processing logic inside the Demand Planning module where a dependent step must await the outcome of a previously submitted request.
• As a supporting routine for notification creation within the DPP workflow, invoked by higher-level planning packages rather than by forms directly.

Because the package is marked VALID and classified as OTHER, it can be expected to remain stable across 12.1.1 and 12.2.2 with the standard caveat that the 12.2 online patching architecture changes how invalid objects and dependencies surface during patching cycles. Custom code should not call this package directly; any dependency should be introduced only after reviewing the package body and confirming the interface in the specific patch level deployed.