Sales Transportation Confirmation Process Flow

The following diagram depicts the process flow for the JD Edwards EnterpriseOne to Oracle Transportation Management Sales Transportation Confirmation integration point:

Sales Transportation Confirmation Process Flow

The Transportation Confirmation Import (R49T40) program runs on a scheduler system or standalone and upon execution imports all records associated to an Oracle Transportation Management shipment ID the staging table to determine whether the record has received confirmed transportation data from Oracle Transportation Management within a first leg buy-side shipment message. The system processes each staging record as follows:

  1. Allocates billable freight by order release. To determine allocated billable freight by order, the Transportation Confirmation Import program:

    • Imports the staged billable charge and currency codes by order release ID and sell-side shipment ID.

    • Converts currency codes to the sales orders's transactional currency code.

    • Creates a new freight line within each sales order on an Oracle Transportation Management shipment for the actual allocated freight charge allocated by order release ID.

  2. Updates the promised delivery date and promised delivery time

  3. Updates all sales order lines next statuses for which billable freight costs have been imported.