Redwood: Manage Shipping Transaction Correction Records Using a Spreadsheet

While integrating with an external execution system, you will need to review and edit interface transactions and their corresponding errors related to shipping transactions received from the external system. You can now manage these records using a predefined spreadsheet template that's configured using the Oracle Visual Builder Add-in for Excel.

Use the Download Shipping Transaction Correction Records in Spreadsheet task from the Oracle Fusion Cloud Inventory Management work area or quick actions to download the predefined spreadsheet template.

Shipping Transaction Correction Records in Spreadsheet

You can use this spreadsheet to manage records in shipping open interface tables added through Perform Shipping Transaction Import file-based data import (FBDI), Material Shipment SOAP web service, or Shipment Transaction Requests REST Resource.

Oracle Visual Builder Add-in for Excel

Select Download Data to search for interface transactions.

Once the records are downloaded, review the interface transaction status and any associated error messages. You can update the shipment data as needed. To apply the changes, select Upload Changes.

To process the interface transaction after applying the changes:

Select Table Row Changes, and select Mark for Action from the drop-down. The Change column will be populated with the value Run Perform Shipping Transactions.
Select Upload Changes to submit the Perform Shipping Transactions scheduled process and process the interface transaction.

This feature provides you the ability to efficiently review and manage the shipping transaction records and corresponding errors related to shipping transactions received from your external execution system.

Steps to Enable

Follow these steps to enable or disable this feature:

In the Setup and Maintenance work area, search for and select the Manage Shipping Profile Options task.
On the Manage Shipping Profile Options page, search for and select the ORA_WSH_SHIPPING_TRANSACTION_CORRECTION_RECORDS_IN_SPREADSHEET_REDWOOD_ENABLED profile option code.
In the Profile Values section, set the Site level to Yes or No. The default value is No.

Yes = enables the feature
No = disables the feature

Click Save and Close. Changes in the profile value will affect users the next time they sign in.

Tips And Considerations

Download the latest version of Oracle Visual Builder Add-in for Excel.

Key Resources

Oracle Fusion Cloud SCM: Using Shipping guide, available on the Oracle Help Center.

Access Requirements

Users who are assigned a configured job role that contains this privilege can access this feature:

Manage Shipment Transaction Corrections (WSH_MANAGE_SHIPMENT_TRANSACTION_INTERFACE_PRIV)

This privilege was available prior to this update.