Search Results order_parameter_name




Overview
Explore in AI Chat

Overview

The XDP_ORDER_PARAMETERS table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 deployments, specifically for the Oracle Communications Order and Service Management (OSM) product, part of the XDP (eXtended Data Processing) schema. Its primary function is to store all order-level parameters transmitted from an upstream system, such as Customer Care or Order Entry (e.g., Oracle Order Management). This table acts as a flexible, extensible storage mechanism for supplemental data associated with a service order, enabling the order management and provisioning workflows to process and act upon specific instructions or attributes not explicitly defined in the standard order header structure.

Key Information Stored

The table's structure is designed for key-value pair storage linked to a specific order. The most critical columns include the composite primary key, consisting of ORDER_ID and ORDER_PARAMETER_NAME. The ORDER_ID is a foreign key linking the parameter to its parent order in XDP_ORDER_HEADERS. The ORDER_PARAMETER_NAME (VARCHAR2(40)) defines the parameter's identifier, such as 'PRIORITY_FLAG' or 'INSTALLATION_WINDOW'. The corresponding ORDER_PARAMETER_VALUE (VARCHAR2(4000)) holds the actual data for that parameter. The table includes standard EBS "Who" columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) for auditing and a SECURITY_GROUP_ID for Virtual Private Database (VPD) support in hosted environments.

Common Use Cases and Queries

A primary use case is retrieving all extended parameters for a specific order to drive fulfillment logic or for troubleshooting. For instance, a workflow process might check for a 'RUSH_ORDER' parameter to prioritize task assignment. Reporting on orders with specific parameter values is another common scenario, such as identifying all orders marked for professional installation.

Sample query to fetch all parameters for an order:

  • SELECT ORDER_PARAMETER_NAME, ORDER_PARAMETER_VALUE FROM XDP.XDP_ORDER_PARAMETERS WHERE ORDER_ID = :1 ORDER BY ORDER_PARAMETER_NAME;

Sample query to find orders with a specific parameter set:

  • SELECT oh.ORDER_NUMBER, op.ORDER_PARAMETER_VALUE FROM XDP.XDP_ORDER_HEADERS oh, XDP.XDP_ORDER_PARAMETERS op WHERE oh.ORDER_ID = op.ORDER_ID AND op.ORDER_PARAMETER_NAME = 'SERVICE_TIER';

Related Objects

The table has a direct and essential relationship with the XDP_ORDER_HEADERS table, which stores the core order information. The documented foreign key constraint defines that the ORDER_ID column in XDP_ORDER_PARAMETERS references the ORDER_ID column in XDP_ORDER_HEADERS. This ensures referential integrity, meaning every parameter record must be associated with a valid, existing order header. The table's primary key constraint, XDP_ORDER_PARAMETERS_PK, enforces uniqueness on the combination of ORDER_ID and ORDER_PARAMETER_NAME, preventing duplicate parameter definitions for a single order. The table is also referenced by the APPS synonym XDP_ORDER_PARAMETERS, which is the standard access point for all application code.