Search Results xdp_perf_bm_pkg




Overview
Explore in AI Chat

Overview

XDP_PERF_BM_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM (E-Business Suite Technical Reference Manual) as an OTHER API. Its naming convention ties it to the XDP module, which in Oracle EBS corresponds to the Telecommunications Service Ordering and Provisioning functionality, commonly deployed in the Communications/Telecom industry vertical. The "PERF_BM" component indicates a performance-oriented benchmark or provisioning utility that supports order submission, order dispatching, and status reconciliation for service fulfillment flows.

The package is marked VALID in the ETRM documentation for both 12.1.1 and 12.2.2. It depends only on SYS.STANDARD and is not referenced by any other packages, indicating it operates as a leaf-level utility invoked directly by forms, concurrent programs, or external integration code rather than through a broader public API chain.

Key Procedures and Functions

The documented package exposes five procedures and functions:

  • SENDORDER — Transmits a service order to the downstream provisioning or gateway system. This is typically the outbound dispatch step that takes an order prepared in the XDP staging tables and forwards it for fulfillment.
  • SUBMITORDER — Submits an order record into the processing pipeline, creating or updating the order header state so subsequent operations can act upon it.
  • PRINTSUBMITORDERSTAT — Produces diagnostic or status output summarizing the results of submit-order activity, useful for troubleshooting batch or concurrent runs.
  • GETREPORT — Retrieves report-level data, most likely aggregating order or service-activity information for display or printing.
  • GETFLOWTHROUGHSTAT — Returns flow-through status, i.e., the state of orders that have progressed through provisioning without manual intervention. This supports monitoring of straight-through processing rates.

No parameter lists are documented in the ETRM metadata; these should be confirmed against the live package specification before invocation.

Tables Accessed

The package interacts with two base tables through APPS synonyms and one supplied PL/SQL package:

  • XDP_ORDER_HEADERS — The primary order record store. SENDORDER and SUBMITORDER read and update header rows to track order lifecycle state.
  • XDP_SERVICE_VAL_ACTS — Service validation activities. GETFLOWTHROUGHSTAT and GETREPORT likely query this table to determine validation and flow-through outcomes.
  • DBMS_UTILITY — Oracle's supplied utility package, used for supporting operations such as error formatting or name resolution within the package logic.

Usage Notes

XDP_PERF_BM_PKG is not referenced by any other package, so it is invoked directly rather than as a dependency of a higher-level API. Typical invocation paths include XDP forms that manage service orders, concurrent programs scheduled to batch-submit and monitor provisioning orders, and custom integrations that call the procedures explicitly for performance or benchmarking purposes. Because the ETRM classifies it as OTHER with no documented parameter signatures, developers should treat it as an internal or non-public utility and validate the specification against the target release before reuse. The package is valid in both 12.1.1 and 12.2.2, so behavior is expected to be consistent across those releases unless patched independently.