Inventory – Review Receipts Interface for Pending/Error Transactions and Process Using the ADFDI Excel Plugin

Some companies use Warehouse Management Systems (WMS) such as Oracle Warehouse Management or Manhattan Active Warehouse Management /third party WMS systems for goods receiving, shipping the products to customers, and inventory movements such as sub-inventory transfers and inter-organization transfers etc., In such cases, all inventory transactions generated in the WMS must be interfaced back to … Read more

Inventory – Overview of Completed Transactions and SQL Query to get the Completed Transaction Export

Oracle Inventory Cloud, along with Order Management, Purchasing, Work Execution, Maintenance Asset, and Warehouse Management, provides a comprehensive set of transactions and reports for effective inventory control. This allows you to control the flow of material from the time you receive items to the time you ship finished goods to the customer, including production activities. … Read more

Subinventory Transfers using Visual Builder Add-in for Excel

Subinventory transfers are performed using the “Create Subinventory Transfer” standard UI task, But this is for a limited no of transactions. For Mass Subinventory transfers, the FBDI import process is commonly used. However, the FBDI process is lengthy and tedious process, as it requires file preparation/generation, upload, and import execution. While FBDI is suitable for … Read more

Oracle Fusion SCM – Process Supplier Returns without Receipt

When we implement Oracle Fusion ERP/SCM Cloud applications, we will be converting only open purchase orders (POs) that have not yet been received in the legacy system. We won’t be converting closed or closed-for-receiving POs in general. We will also be performing an on-hand conversion to bring inventory/stock from the legacy system into Oracle Fusion … Read more

Overview of Manufacturer Part Numbers and On-Hand Quantity by Manufacturer Part Number

Manufacturer Part Numbers (MPNs) are used to uniquely identify parts from specific manufacturers, distinguishing them from internal item numbers. You can use this information for reporting purposes, communicating with the manufacturers using their own part numbers and and in catalog searches for particular items. We can create a manufacturer part, then assign it to an … Read more

Overview of Inventory Movement Requests and SQL Query to get the movement request details

Movement requests are used for the movement of materials within an inventory organization, such as a warehouse or facility. There are three types of movement requests: requisition, replenishment, and shop floor movement requests. Shop floor movement requests support manufacturing and maintenance work orders by ensuring required components are available. Materials are moved either to WIP … Read more