You can use Secure File Transfer Protocol (SFTP) in flat-file formats to push or pull data into or from warehouse management systems, or you can use Microsoft Excel to upload or export data from Oracle Fusion Cloud Warehouse Management.
Key Features
SFTP, direct upload, and export are used in legacy systems where payload formats are more file based and text delimited.
Best Practices
- Some legacy ERPs still use file-based, text-delimited formats.
- Some legacy automations systems use a file-based approach for communication.
- Direct file upload or export is usually used in a warehouse management system as a standalone system or for low-volume implementations. For example, for master data setup.
- Certain metadata setups in warehouse management systems can only be completed with Microsoft Excel-based file uploads.
- You can submit large data flat files directly to Oracle Integration Cloud (OIC) for processing by SFTP.
Constraints
Excel-based upload and download can only be used for smaller payloads.