File-Based Data Import (FBDI)
Consider using FBDI if you need to import high-volume data into Oracle Fusion Cloud Inventory Management.
Also consider using the FBDI integration option if you need to import transactional data in bulk into Oracle Inventory Management.
To use this option:
- Download Microsoft Excel templates that are available for several inventory-management entities.
- Provide the required data.
- Generate a comma-separated values (CSV) file and upload it to the desired location.
- Run processes to transfer the data to the interface tables.
- Import the data to the target Oracle Inventory Management tables.
Key Features
- Used only for inbound integration of data into Oracle Inventory Management.
- Supports the import of large volumes of data into Oracle Inventory Management.
Best Practices
- Review the field/attribute level instructions provided in the Microsoft Excel templates before entering the data that needs to be imported.
- If the data size is very large, submit the data in a smaller set of records.
- If the scheduled process you use to process the data inserted using FBDI supports multiple child processes, identify the appropriate number of child processes to use to process the large data set in parallel.
- Purge the staging records periodically. We also recommend that you review the staging table records for any errors and take the required actions to re-process the records.
Constraints
This option isn't suitable for importing inventory data on a real-time basis.
Oracle Inventory Management Objects that FBDI Supports
| Object | Description | FBDI Template |
|---|---|---|
| Inbound Receipts | Receives and processes receipt confirmations to acknowledge the receipt of material, updates the source documents and available details for quantities and other related information, such as lots, serials, external packing units, and the return of rejected material. | ReceivingReceiptImportTemplate.xlsm |
| Inbound Shipments | Confirms the shipments executed in the external system (3PL/WMS). | PerformShippingTransactionImportTemplate.xlsm |
| Miscellaneous Inventory Transactions | Processes inventory adjustments from an external system. | InventoryTransactionImportTemplate.xlsm |
| Inbound Manufacturing Picks | Receives the details of the picked manufacturing or maintenance work order transactions from the external system. | InterfacedPickTransactionsImportTemplate.xlsm |
| Synchronize Inventory Balances | Receives and processes inventory balance updates from an external system. | InventoryBalanceImportTemplate.xlsm |
| Inbound Reservations | Receives Reservation requests from an external system. | InventoryReservationImportTemplate.xlsm |