Inventory

Inventory

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

by

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

by

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

by

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

by

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

by

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

by

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

Oracle Cloud Inventory – Inventory On-Hand Visibility by Subinventory, Locator, and Lot

by

One of the most common business requirements in Inventory Management is the ability to view on-hand inventory at a detailed level- specifically by Subinventory, Locator, and Lot. This level of visibility helps business users clearly understand current stock positions and make informed operational decisions. Inventory is not always immediately available for use. While some stock … Read more

Fusion SCM Cloud – Export of Shipping Method setup in the system

by

A freight carrier is a commercial company that transports shipment/deliveries to and from customers, suppliers and internal organizations. Freight Carriers are setup commonly for the Order Management, Inventory and Procurement. The freight carriers are setup with their model of transport like Air, Ground, Ocean, Service levels like 1 Day, 2 day and Overnight etc., and … Read more

SQL Query to get Back2BackSales Orders and their corresponding Supply Order details

by

Here is the SQL Query to get Back2Back Sales Orders and their corresponding Supply Order details. SELECT sh.SUPPLY_ORDER_REFERENCE_NUMBER “Sales Order”,sl.SUPPLY_ORDER_REF_LINE_NUMBER “SOLine_Num”,sh.SUPPLY_ORDER_NUMBER,sh.status_code hdr_status,sh.SUPPLY_ORDER_SOURCE,sl.LINE_NUMBER “Supply_Lines”,sl.EXEC_SYSTEM_ITEM_NUMBER “Item”,sl.quantity Requested_Qty,stl.status_code status,–stl.quantity tl_qty , stl.available_quantity avail_qty ,sl.need_by_date Requested_Delivery_Date,sl.supply_type supply_type,sl.DESTINATION_ORGANIZATION_CODE Supply_Destination, –sl.DESTINATION_BU_ID , sl.DESTINATION_ORGANIZATION_ID ,sl.MOVEMENT_REQUEST_FLAG,sl.contract_manufacturing_flag CM_FLAG,sl.back_to_back_flag B2B_FLAG,sl.CONFIG_ITEM_FLAG,sl.OUTSIDE_PROCESSING_FLAG OSP_FLAG,DECODE (stld.document_type,‘ORA_PR’, ‘Purchase Requisition’,‘ORA_PO’, ‘Purchase Order’,‘ORA_RSV’, ‘Reservation’,‘ORA_RCPT’, ‘Receipt’,‘ORA_TO’, ‘Transfer Order’,‘ORA_WO’, ‘Work Order’,‘ORA_SH’, ‘Shipment’) “Document Type”,stld.document_number … Read more