Search Results xnp_sync_registration

Overview

The XDP_ORDER_HEADERS table is the central repository for provisioning order header information within Oracle E-Business Suite 12.1.1 and 12.2.2. It is a core table in the XDP (Provisioning) product module, which manages the automated fulfillment of services. This table acts as the primary anchor for all provisioning order data, storing the master record for each order that initiates a service activation or modification workflow. Its role is to uniquely identify an order and maintain high-level attributes that are inherited and referenced throughout the entire provisioning execution chain.

Key Information Stored

The table's structure is defined by its primary and unique keys, which enforce critical business rules. The primary key is ORDER_ID, a system-generated unique identifier for the provisioning order. A significant alternate key is the combination of EXTERNAL_ORDER_NUMBER and EXTERNAL_ORDER_VERSION. This allows the system to correlate internal provisioning orders with external identifiers and versions, typically sourced from an upstream order management system like Oracle Order Management (OM). Other essential columns include CUST_ACCOUNT_ID, which links the order to a customer account in the TCA (Trading Community Architecture) schema via the HZ_CUST_ACCOUNTS table, establishing the customer context for the fulfillment process.

Common Use Cases and Queries

This table is fundamental for tracking the lifecycle and relationships of provisioning orders. Common operational and reporting queries involve joining to related detail tables to get a complete order picture. A frequent use case is retrieving all components of a specific order for troubleshooting or status reporting. For example, to find all line items and parameters for an order known by its external reference, a query would join XDP_ORDER_HEADERS to XDP_ORDER_LINE_ITEMS and XDP_ORDER_PARAMETERS. Another critical scenario is analyzing order relationships and dependencies, which requires joining XDP_ORDER_HEADERS to XDP_ORDER_RELATIONSHIPS to understand parent-child or successor-predecessor links between different orders in a complex fulfillment scenario.

Related Objects

As the central hub for provisioning data, XDP_ORDER_HEADERS has extensive relationships with numerous child tables and is referenced by several process tables in the XNP (Provisioning Engine) layer. Key documented relationships include:

• Parent Reference: HZ_CUST_ACCOUNTS via CUST_ACCOUNT_ID.
• Core Child Tables (via ORDER_ID): XDP_ORDER_BUNDLES, XDP_ORDER_LINE_ITEMS, XDP_ORDER_PARAMETERS.
• Relationship Management: XDP_ORDER_RELATIONSHIPS (referenced twice, for ORDER_ID and RELATED_ORDER_ID).
• Provisioning Engine (XNP) Process Tables: XNP_CALLBACK_EVENTS, XNP_MSGS, XNP_SV_ORDER_MAPPINGS, XNP_SYNC_REGISTRATION, XNP_TIMER_REGISTRY.

These relationships illustrate that the ORDER_ID from XDP_ORDER_HEADERS propagates throughout the provisioning system to track bundles, line items, configuration parameters, inter-order dependencies, and all associated engine events and messages.