1. Integration with Oracle Transportation Management Implementation Guide
  2. Sales Freight Request Process Flow

Sales Freight Request Process Flow

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

Sales Freight Request Process Flow

The process is threefold:

  1. The system filters sales order header and detail data. This includes sales order document types, line types, item types, date and time, and a new integration state indicating the state of the order line within the integration process.

  2. Data processing. This includes the retrieval of required data to be mapped to Oracle Transportation Management data, evaluation of customer sets to determine ship-to, override address consideration, date/time evaluation, shipping unit of measure processing, and credit order processing.

  3. The system updates order release, item, and location information to three staging tables: the Order Release Staging table (F49T10), the Item Staging table (F49T11), and the Order Release Locations Staging table (F49T50). The system also updates each sales order line successfully staged for transmittal to the Oracle Transportation Management system to a state flag value of FR in the Sales Order Detail Secondary Tag table (F49T211). After writing all records to the staging tables, the system creates the Oracle Transportation Management item and order release XML files to be placed on the configured file system. After successfully creating the XML files, the system deletes the records from all the staging tables for the processed Oracle Transportation Management shipments. The HTTP Post Java program, which runs on the native operating system scheduler, picks up the XML files and sends them to the Oracle Transportation Management system.