One of your ideas has been delivered from your suggestion.Generate a Unique Process Number Per Order Number Using the Generate Shipping Request Process

When integrating with a 3PL or WMS, it's essential to transmit all eligible shipment lines for outbound deliveries as required in your fulfillment process. Additionally, these shipment lines should be organized into relevant groups to facilitate clear communication with the external execution system regarding specific shipment details.

You now have the flexibility to tailor the grouping attributes on the Shipping Parameters page, giving you precise control over how these shipment lines are categorized. These attributes contain various criteria such as order type, order number, customer, delivery location, shipping method, item, and shipment set.

Each group is then associated with an external system order ID before sharing the information with your 3PL or WMS. This ID serves as a reference number or can even be used as the official order number by the 3PL or WMS.

With this feature, you can:

  • Generate a unique sequence number (External System Order ID) for each group of shipment lines selected for interfacing with a WMS or 3PL system via an outbound shipment request.
  • Group shipment lines using configurable attributes. For example, if you group by Order Number and Ship-to Location, all shipment lines in the batch with the same order number and ship-to location will receive the same sequence number.
  • Available grouping attributes include:
    • Order Type
    • Order Number
    • Shipment Set
    • Customer
    • Ship-to Location
    • Shipping Method
    • Item
  • Define the starting value for the sequence using the seeded document sequence setup.
  • Map the generated sequence number, exposed through the WMSBatchNumber attribute in the ShipmentLines REST service, to your WMS or 3PL system.

You can now collaborate with your 3PL or WMS with greater ease and fewer errors or miscommunications. This leads to faster order fulfillment, improved customer satisfaction, and reduced operational costs.

Steps to Enable

Specify grouping attributes:

  • In the Setup and Maintenance work area, search for and open the Shipping Parameters task.
  • In the shipping parameters for the relevant organization, select one or more External system order identifier grouping attributes.

Shipping Parameters

Shipping Parameters

Set the starting value of the sequence:

  • In the Setup and Maintenance work area, search for and open the Manage Shipping Document Sequences task.
  • On the Manage Shipping Document Sequences page, search for the document sequence name: ORA_WSH_EXT_SYS_ORDER_SEQ.
  • In the search results, click Expand and enter the Initial Value. Click Save and Close.

Shipping Document Sequences

Shipping Document Sequences

Tips And Considerations

  • The sequence number is generated only when at least one grouping attribute is selected for the external system order ID in the shipping parameters of the organization.
  • If a line is backordered or reset for integration, the previously assigned sequence number will be removed from the line.

Key Resources

  • Oracle Fusion Cloud SCM: Implementing Manufacturing and Supply Chain Management guide, available on the Oracle Help Center.
  • Oracle Fusion Cloud SCM: Using Shipping guide, available on the Oracle Help Center.
  • Oracle Fusion Cloud SCM: REST API for Oracle Fusion Cloud SCM guide, available on the Oracle Help Center.

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

  • Create Outbound Shipment Request (WSH_CREATE_SHIPMENT_REQUEST_PRIV)
  • Generate Shipment Request (WSH_GENERATE_SHIPMENT_REQUEST_PRIV)

These privileges were available prior to this update.

Users who are assigned a configured job role that contains this duty role can access this feature:

  • Create Outbound Shipment Request Using Responsive Shipping (ORA_WSH_CREATE_OUTBOUND_SHIPMENT_REQUEST_PWA_DUTY)

This duty role was available prior to this update.