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

GOP Inquiry using Manage Order Promising Demands

Use the Manage Order Promising Demands page/table in the Globa Order Promising work area to analyze demand, check availability, simulate different availability options, make changes that affect availability, then schedule your changes. Pre- Requisites: Navigation: Order Management > Global Order Promising Tasks: Manage ATP Rules, Manage Sourcing Rules and Manage Assignment Sets 2. Run GOP … Read more

Get All Components and Subassemblies from Parent and Child Work Definitions for Finished Good Product

A work definition defines the manufacturing process for a product and serves as a template for creating work orders during execution. When a final product includes subassemblies that are also manufactured in-house, you define a work definition for the finished good as well as separate work definitions for each subassembly. A phantom assembly is a … Read more

Oracle Manufacturing Cloud – Discrete vs Process Manufacturing

In Oracle Manufacturing Cloud, both Discrete and Process Manufacturing are supported. The choice between Discrete and Process depends on several key factors, including the nature of production, the type of product being made, and the level of tracking required. These elements collectively determine which manufacturing approach best fits a given business scenario. Feature Discrete Process … Read more