Search Results xnp_csisoful_u




Overview
Explore in AI Chat

Overview

XNP_CSISOFUL_U is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It participates in the Oracle Advanced Supply Chain Planning and Order Fulfillment messaging infrastructure, specifically bridging the Oracle XML Gateway / Notification infrastructure (XNP) with the Oracle Order Management and Shipping execution APIs. The package functions as a fulfillment notification handler: it converts fulfillment, shipping, and order transaction events into messages routed through the XNP_MESSAGE framework so that downstream systems — internal or external — can be notified. Its name follows the XNP convention (XNP = XML Notification Platform) with the "CSISOFUL" root reflecting its association with CSI (Customer Service/Installed Base) Order Fulfillment logic. Because it is documented under the ETRM object catalog with a status of VALID, it is an active, supported component of the application stack rather than an obsolete stub.

Key Procedures and Functions

The package exposes six documented program units, all oriented around constructing, validating, and dispatching fulfillment messages:

  • CREATE_MSG — Builds the outbound message payload. It gathers the relevant fulfillment or shipping context and assembles it into a structure suitable for the XNP_MESSAGE queue.
  • PUBLISH — Publishes the constructed message to the messaging infrastructure, making it available for delivery to subscribers.
  • SEND — Transmits the message according to the configured delivery mode.
  • PROCESS — The main orchestration entry point that drives the create/publish/send lifecycle for a given event.
  • DEFAULT_PROCESS — Supplies default processing behavior when no explicit process is supplied by the caller.
  • VALIDATE — Performs pre-send validation of the message or its parameters, ensuring required attributes are present before publication.

Tables Accessed

The ETRM metadata lists a single referenced table, DBMS_AQ, accessed via an APPS synonym. DBMS_AQ is the Oracle Advanced Queuing administrative package rather than a data table; its inclusion confirms that XNP_CSISOFUL_U enqueues messages onto an AQ queue as part of the XNP_MESSAGE delivery mechanism. No application data tables are documented as directly accessed by name, indicating that the package relies on the XNP_MESSAGE framework and on caller-supplied record structures or public APIs of the CSI Order Fulfillment packages to obtain its data. The primary external dependency is APPS.XNP_MESSAGE.

Usage Notes

XNP_CSISOFUL_U is not typically invoked interactively from a form. It is called programmatically by the shipping and order fulfillment APIs that drive it: the metadata identifies CSI_ONT_TXN_PUB, CSI_ORDER_FULFILL_PUB, and CSI_ORDER_SHIP_PUB as referencing packages, along with CSISOFUL and XNP_CSISOFUL_U itself. This means the package fires automatically when order transaction, fulfillment, and shipment events occur in the Order Management and Shipping execution flows. Its messages then travel through the XNP_MESSAGE queue (enqueued via DBMS_AQ) to downstream subscribers. When troubleshooting, confirm the queue is operational and that validation in VALIDATE passes; when extending, custom code should call the package through the same public entry points used by the CSI APIs rather than querying XNP_MESSAGE directly.