Search Results oe_drop_ship_sources

Overview

The OE_DROP_SHIP_SOURCES table is a critical transactional entity within the Oracle E-Business Suite (EBS) Order Management (ONT) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to serve as the central repository for establishing and maintaining the relationship between sales order lines and their corresponding procurement documents. This table is essential for orchestrating drop-ship fulfillment processes, where an item ordered by a customer is shipped directly from a supplier. It acts as the definitive link between the sales order in the OE_ORDER_LINES_ALL table and the associated purchasing requisitions in PO_REQUISITIONS_ALL or purchase orders in PO_LINES_ALL, enabling integrated process flow and visibility across the Order-to-Cash and Procure-to-Pay cycles.

Key Information Stored

The table's structure is designed to store foreign key references that create the necessary relationships. The most significant columns include LINE_ID, which links to the sales order line in OE_ORDER_LINES_ALL, and HEADER_ID, which links to the sales order header in OE_ORDER_HEADERS_ALL. For procurement linkage, the table contains PO_HEADER_ID and PO_LINE_ID to reference the purchase order in PO_HEADERS_ALL and PO_LINES_ALL, respectively. Similarly, for requisition-based drop shipments, it stores REQUISITION_HEADER_ID and REQUISITION_LINE_ID to link to PO_REQUISITION_HEADERS_ALL and PO_REQUISITION_LINES_ALL. Additional columns typically track creation and last update dates, the requesting organization, and the line location ID to manage inventory and accounting contexts.

Common Use Cases and Queries

The primary use case is tracking and reporting on the status of drop-ship orders. A common operational query involves joining OE_DROP_SHIP_SOURCES to sales order and purchase order tables to identify pending shipments or invoice matching issues. For instance, to list all active drop-ship lines with their associated PO numbers, a query would select from OE_ORDER_LINES_ALL, join on OE_DROP_SHIP_SOURCES using LINE_ID, and then join to PO_HEADERS_ALL using PO_HEADER_ID. This table is also pivotal for custom reports analyzing drop-ship fulfillment cycle times, supplier performance, and the volume of drop-ship transactions. Data integrity checks often query this table to find orphaned records where a purchase order was deleted but the link in OE_DROP_SHIP_SOURCES remains.

Related Objects

As indicated by its foreign key constraints, OE_DROP_SHIP_SOURCES has direct dependencies on several core EBS tables. It is fundamentally linked to the Order Management base tables OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL. Its integration with Purchasing is established through links to PO_HEADERS_ALL, PO_LINES_ALL, PO_REQUISITION_HEADERS_ALL, and PO_REQUISITION_LINES_ALL. This table is frequently accessed by standard Oracle APIs and user interfaces within the Order Management and Purchasing modules to display sourcing information. Custom interfaces or data migration scripts for drop-ship orders must also populate this table correctly to maintain process integrity.