Search Results xdp_oe_order_headers_u1

Overview

XDP.XDP_OE_ORDER_HEADERS is a table owned by the XDP schema within Oracle E-Business Suite. It stores order header information for orders generated by the Oracle SFM (Service Fulfillment Manager) Order Entry Interface. In the context of Oracle EBS 12.1.1 and 12.2.2, this table acts as a staging and tracking repository where order headers originating from external fulfillment and provisioning flows are captured before, during, and after downstream processing. The XDP schema is associated with telecommunications and fulfillment-oriented extensions to EBS, and this table centralizes header-level order attributes such as version, status, customer, service provider, and key dates required to manage the order lifecycle.

The table resides in the APPS_TS_ARCHIVE tablespace with PCT Free of 10, reflecting its role as a persistent archive-oriented structure. Based on the heuristic Data Vault classification derived from its foreign key structure, this object is hub-leaning. As a modeling suggestion, it can be treated as a hub entity keyed on the business identifier, with surrounding descriptive attributes behaving as satellite-style properties. The primary key is defined as XDP_OE_ORDER_HEADERS_UK on (ORDER_NUMBER, ORDER_VERSION), and the unique index XDP_OE_ORDER_HEADERS_U1 also enforces uniqueness on the same column pair.

Key Information Stored

The table contains 30 documented columns. The most significant of these include:

• ORDER_NUMBER (VARCHAR2 40) — the customer's order number, part of the composite business key.
• ORDER_VERSION (VARCHAR2 40) — the version of the order, completing the composite business key used by the unique index XDP_OE_ORDER_HEADERS_U1 and the primary key XDP_OE_ORDER_HEADERS_UK.
• SDP_ORDER_ID (NUMBER) — unique identifier generated by SFM to track the order.
• STATUS (VARCHAR2 40) — the current order status.
• ORDER_TYPE, ORDER_ACTION, and ORDER_SOURCE — classify the type, action, and origin of the order.
• PROVISIONING_DATE, COMPLETION_DATE, DUE_DATE, and CUSTOMER_REQUIRED_DATE — the critical lifecycle dates for fulfillment and customer expectations.
• CUSTOMER_NAME, CUSTOMER_ID, ORG_ID, and SERVICE_PROVIDER_ID — customer and organizational context.
• SP_ORDER_NUMBER and SP_USERID — service provider order reference and user identifiers.
• RELATED_ORDER_ID — supports tracking of bundled orders.
• JEOPARDY_ENABLED_FLAG — indicates whether jeopardy tracking applies.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting row-level security.

Standard WHO columns (CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN) are also present.

Common Use Cases and Queries

This table is frequently queried for order status reporting, fulfillment tracking, and reconciliation between SFM-generated orders and downstream systems. A typical query retrieves active orders by status and due date:

• SELECT order_number, order_version, status, due_date FROM xdp.xdp_oe_order_headers WHERE status = :status;
• Joining to lines for line-level detail: SELECT h.order_number, l.* FROM xdp.xdp_oe_order_headers h JOIN xdp.xdp_oe_order_lines l ON h.order_number = l.order_number;
• Identifying orders in jeopardy: SELECT order_number FROM xdp.xdp_oe_order_headers WHERE jeopardy_enabled_flag = 'Y';
• Tracking by service provider: SELECT sp_order_number, status FROM xdp.xdp_oe_order_headers WHERE service_provider_id = :sp_id;

Related Objects

The following objects are most significant in relation to this table, based on documented foreign key relationships:

• XDP.XDP_OE_ORDER_LINES — references XDP_OE_ORDER_HEADERS via ORDER_NUMBER; holds line-level order detail.
• XDP.XDP_OE_ORDER_PARAMETERS — references XDP_OE_ORDER_HEADERS via ORDER_NUMBER; holds order parameters.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID, providing security group context.

These relationships establish XDP_OE_ORDER_HEADERS as the header hub for order entry data generated through the SFM Order Entry Interface, with lines and parameters acting as dependent child entities.