Search Results invoice_number_id

Overview

The WSH_INVOICE_NUMBERS table is a core data object within the Oracle E-Business Suite (EBS) Order Entry (OE) module, specifically in the context of the Shipping (WSH) execution layer. Its primary role is to maintain a record of invoice numbers generated for shipments. This table acts as a critical junction, linking the physical delivery of goods managed in the Shipping module with the subsequent financial invoicing process. By storing this relationship, it ensures traceability from a delivery to its corresponding financial document, supporting key business flows like order-to-cash.

Key Information Stored

The table's structure is designed to capture the essential link between a delivery and an invoice number. While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal its core data. The primary key, INVOICE_NUMBER_ID, uniquely identifies each invoice number record. The most significant foreign key is DELIVERY_ID, which references the WSH_DELIVERIES table. This column stores the identifier for the specific delivery for which the invoice number was generated. Additional columns likely exist to store the actual invoice number value, creation dates, and status information, forming a complete audit trail for the invoicing step of a shipment.

Common Use Cases and Queries

This table is central to reconciliation and reporting tasks between logistics and finance operations. A common use case is identifying all invoice numbers associated with a specific delivery or shipment for customer inquiry resolution. Another critical scenario involves auditing the invoicing process by verifying that all completed deliveries have a corresponding invoice number record. A typical reporting query would join this table to WSH_DELIVERIES and related order headers to produce a shipment-to-invoice cross-reference report.

SELECT wdn.name delivery_name,
       win.invoice_number,
       ooh.order_number
FROM   oe.wsh_invoice_numbers win,
       oe.wsh_deliveries wdn,
       oe.oe_order_headers_all ooh
WHERE  win.delivery_id = wdn.delivery_id
AND    wdn.source_header_id = ooh.header_id;

Related Objects

The WSH_INVOICE_NUMBERS table has a direct and documented foreign key relationship with a primary Shipping entity, as per the provided metadata.

• WSH_DELIVERIES: This is the primary related table. The foreign key constraint links WSH_INVOICE_NUMBERS.DELIVERY_ID to a delivery record in WSH_DELIVERIES. This relationship is fundamental, as every invoice number record must be associated with a specific delivery instance.

While not listed in the excerpt, this table is also intrinsically related to the core Order Entry tables (e.g., OE_ORDER_HEADERS_ALL) via its connection to WSH_DELIVERIES, completing the link from order to shipment to invoice.