Shipped Load Interface

Oracle WMS Cloud can derive order detail status whenever the order detail is shipped. Order Quantity Consume is meant to be used by integration to consume quantity against the shipped quantity. Deriving the status on the order detail helps you to know about order status, so that you can plan further activity during shipping and manifest.

After loading and performing shipping, if the shipped quantity is within the maximum/minimum shipping tolerance percentage defined on the order detail and the order detail doesn't have any pending allocation/picks, then the order detail status will be derived as "Shipped".

  • Order detail status is shipped when shipping is performed via the RF or UI ShipLoad transaction.
  • Order header status is marked as shipped when all the order details against the order are shipped.
When inventory is shipped against the order detail, the order detail will be updated with:
  • ShippedQuantity: Total inventory shipped against the order detail.
  • Order Quantity to consume: Total order quantity to consume sent against the order detail.
Note: During Ship Load, the system generates the Outbound Load Export (SLS) file which has information associated with the order detail including:
  • Maximum Shipping Tolerance%

  • Minimum Shipping Tolerance%

  • Order Quantity to Consume

Shipped Order Details Service Level Report UI

The Shipped Order Details Service Level Report provides an overview of order fulfillment performance over a specified time period. It tracks the total number of order details processed and analyzes how quickly these orders are shipped, categorizing them by the number of days taken to ship (from day 1 through day 5, as well as those not shipped). The report includes calculated service-level percentages that show the proportion of orders shipped within specific time frames, offering valuable insights into shipping efficiency.

Here are descriptions of the fields in the report:

Column Format Description
Date Date The date records are generated. Format supported is YYYYMMDD
Nbr Order Details Numeric Total number of order details present
Details Shipped Day 1 Numeric Total number of order details shipped in day1
Details Shipped Day 2 Numeric Total number of order details shipped in day2
Details Shipped Day 3 Numeric Total number of order details shipped in day3
Details Shipped Day 4 Numeric Total number of order details shipped in day4
Details Shipped > Day 4 Numeric Total number of order details shipped in day5
Details Not Shipped Numeric Total number of order detail not shipped
Service Level Day 1 Decimal TOTAL value of 'Details Shipped Day 1' / TOTAL value of 'Nbr Order Details' * 100
% Service Level Day 2 Decimal TOTAL value of ('Details Shipped Day 1'+ 'Details Shipped Day 2') / TOTAL value of 'Nbr Order Details' * 100
% Service Level Day 3 Decimal TOTAL value of ('Details Shipped Day 1'+ 'Details Shipped Day 2' + 'Details Shipped Day 3') / TOTAL value of 'Nbr Order Details' * 100
% Service Level Day 4 Decimal TOTAL value of ('Details Shipped Day 1'+ 'Details Shipped Day 2' + 'Details Shipped Day 3' + 'Details Shipped Day 4') / TOTAL value of 'Nbr Order Details' * 100
% Service Level > Day 4 Decimal TOTAL value of ('Details Shipped Day 1'+ 'Details Shipped Day 2' + 'Details Shipped Day 3' + 'Details Shipped Day 4' + 'Details Shipped > Day 4') / TOTAL value of 'Nbr Order Details' * 100
% Orders Not Shipped Decimal TOTAL value of 'Details Not Shipped' / TOTAL value of 'Nbr Order Details' * 100