1. Integration with Oracle Transportation Management Implementation Guide
  2. Last Sales Order Line Confirmation

Last Sales Order Line Confirmation

The Sales Order Confirmation Export program determines whether all of the sales order lines of the pickup stops on an Oracle Transportation Management shipment have been confirmed, back ordered, or canceled. The program then initiates the following processes for an Oracle Transportation Management shipment:

  1. Order line data extraction:

    1. The JD Edwards EnterpriseOne system extracts and stages confirmed order lines, including any changed quantities, for transmission to Oracle Transportation Management.

    2. The JD Edwards EnterpriseOne system extracts and stages unshipped back ordered or canceled order lines for transmission to Oracle Transportation Management. The JD Edwards EnterpriseOne shipment number, Oracle Transportation Management shipment ID, and state flag related to any entire order lines left back ordered or canceled are cleared to enable subsequent Freight Request of the unshipped back ordered order lines.

    3. The JD Edwards EnterpriseOne shipment number that is associated with an order line and derived at Transportation Arranged is extracted and mapped to the corresponding Oracle Transportation Management order release for transmittal to Oracle Transportation Management for Oracle Transportation Management customer-facing reports to include the JD Edwards EnterpriseOne Shipment Number.

      See Sales Order Confirmation Assumptions.

    4. To enable Oracle Transportation Management reports to include the customer purchase order, the JD Edwards EnterpriseOne system extracts and maps the customer purchase order that is associated with an order line to the corresponding Oracle Transportation Management order release for transmittal as a reference value qualified as "CUST_PO".

      See Sales Order Confirmation Assumptions.

  2. The JD Edwards EnterpriseOne system extracts and stages actual shipment volume and weight for transmission to the Oracle Transportation Management system. The actual shipment weight and volume is calculated from the Sales Order Detail table (F4211).

  3. When the preceding processing finishes successfully, the system updates the Sales Order Detail Secondary Tag table sales order confirmation flag to C.

  4. The system advances the order to the next status based on the Next Order Status value that is specified in the processing option.