Search Results qp_pricing_engine_url




Overview
Explore in AI Chat

Overview

QP_JAVA_ENGINE_UTIL_PUB is a public PL/SQL package in the Oracle E-Business Suite Advanced Pricing module (QP) that provides the runtime plumbing between Oracle Forms, concurrent programs, and the external Java-based pricing engine. Beginning with the 11.5.10 code line and continuing through EBS 12.1.1 and 12.2.2, Oracle transitioned pricing engine execution from a pure PL/SQL implementation to a servlet-based Java engine accessed over HTTP. This package encapsulates the detection, configuration, and transport logic required to reach that remote engine, insulating pricing callers from the mechanics of HTTP requests, timeouts, wallet-based authentication, and proxy traversal.

The header revision $Header: QPXJUTLB.pls 120.2.12010000.3 2010/01/18 ... $ confirms the file was last patched in the 12.1 code line, and the ETRM metadata classifies the API as PUB, meaning it is a supported interface that Oracle expects customers and integrators to call directly. The package metadata records six documented program units and identifies twenty-six other packages that reference it, indicating it sits at a widely shared layer of the pricing stack rather than in an isolated corner.

Key Procedures and Functions

The documented program units are:

  • JAVA_ENGINE_INSTALLED — Returns a flag indicating whether the Java pricing engine is installed and available in the current environment. Internally it inspects the profile option QP_INTERNAL_11510_J; the observed source compares this value against a sentinel literal to decide the result. Callers use it to decide whether to route pricing requests to the Java engine or fall back to the PL/SQL engine.
  • JAVA_ENGINE_RUNNING — Determines whether the Java engine is currently up and in use, as opposed to merely installed. This distinction matters for failover logic in concurrent pricing runs.
  • GET_ENGINE_URL — Retrieves the configured URL of the Java pricing engine, derived from the QP_PRICING_ENGINE_URL profile option in the original design.
  • SEND_JAVA_ENGINE_REQUEST — Formats and transmits a pricing request payload to the Java engine endpoint and returns the response for parsing by the caller.
  • SEND_JAVA_REQUEST — The lower-level HTTP transmission routine used by the engine request wrapper.

Package-level state includes transferTimeout and defaultTimeout (PLS_INTEGER), wallet path, wallet password, proxy server globals, and a debug flag l_debug — reflecting the transport concerns the package owns.

Tables Accessed

No application tables are referenced. The package operates exclusively against system-supplied PL/SQL utilities, which the ETRM metadata lists via APPS synonyms: UTL_HTTP (HTTP request/response transport to the servlet), UTL_TCP (lower-level socket handling), DBMS_LOCK (serialization of engine calls), DBMS_UTILITY (diagnostic and formatting support), and PLITBLM (PL/SQL integer table manipulation). Configuration is read from profile options rather than from database tables.

Usage Notes

QP_JAVA_ENGINE_UTIL_PUB is normally invoked indirectly. Oracle Pricing concurrent programs, the pricing forms, and the core pricing engine dispatcher call it when the environment is configured for Java engine execution, typically after JAVA_ENGINE_INSTALLED or JAVA_ENGINE_RUNNING has been checked. Because the API is classified PUB, custom pricing integrations and extensions may call it directly to submit requests to the Java engine, but developers should respect the detection functions first to avoid hard failures when the engine is unavailable. The timeout, wallet, and proxy globals must be initialized by the calling context before transport functions are used.

The user's search term, set_detailed_excp_support, does not appear among the six documented program units in this ETRM record. It is likely a procedure defined in a related pricing engine package or in a different revision of the source; readers seeking it should verify the object name and the patch level of their installation rather than assuming it exists in QP_JAVA_ENGINE_UTIL_PUB at 12.1.1 or 12.2.2.