Understanding Procurement Freight Request

The Procurement Freight Request process enables the JD Edwards EnterpriseOne system to extract eligible purchase order lines and place them in the Procurement OTM Freight Request Staging table (F49T100), which then enables XML request for transportation planning to Oracle Transportation Management. This occurs when purchase orders have been added or updated within the JD Edwards EnterpriseOne Procurement system.

Apart from newly entered or modified purchase order lines, the JD Edwards EnterpriseOne system also extracts purchase order detail lines that were closed or canceled through other JD Edwards EnterpriseOne applications such as Purchase Order Entry (P4310), Purchase Order Receipts (P4312), and Voucher Match (P4314).

When Oracle Transportation Management receives the freight request lines it creates order base lines for transportation planning. When Oracle Transportation Management receives the closed or canceled status updates, it sets the order base line's release control status to RELEASE CONTROL_CLOSED or RELEASE CONTROL_CANCELED respectively. No further order releasing can be done on this order base line. However, the status change does not affect existing shipments or order releases. If the line is reopened, Oracle Transportation Management receives the transmission to update the release control status on the order base line's RELEASE CONTROL ALLOW_RELEASING. Oracle Transportation Management can then create order releases and shipments because the JD Edwards EnterpriseOne purchase order is reopened.

Note: When you use any of the JD Edwards EnterpriseOne programs to partial receive, two-way match, close, or cancel the Oracle Transportation Management eligible purchase order lines without the message from Oracle Transportation Management you must access Oracle Transportation Management to manually correct the order base. In other words, if the open quantity on purchase order and the order base differ in some exceptional cases (for example, when a partial purchase order is received without Oracle Transportation Management arranging shipments) Oracle Transportation Management's open quantities may be updated manually to match up with JD Edwards EnterpriseOne.