Item Import Using SOAP Webservice – Oracle Fusion
Introduction: This blog has the SOAP Webservice details that can be used to import the item data into Oracle Cloud application. Cause of the issue: Business wants to integrate…
Read MoreItem Ranging – Oracle Retail Merchandising System Module
Item Maintenance RMS is responsible for the creation and maintenance of all items. RMS uses a flexible data hierarchy for an item, with levels that allow you to model…
Read MoreQuery to get transactions of inventory items with available onhand quantity
SELECT recs.doc_type, recs.item_number, recs.doc_no, recs.po_number, recs.organization_id, recs.inventory_item_id, recs.primary_quantity, recs.transaction_date FROM ( /* receipt transactions*/ …
Read MoreQuery to get current onhand quantity of inventory Items.
SELECT ALL mtl.organization_id, orgs.NAME organization_name, mtl.inventory_item_id, mtl.segment1 item_number, mtl.description item_description, mtl.item_type, mtl.inventory_item_status_code, mtl.primary_uom_code, …
Read MoreMove Order Approval Process in R12.2
Move Order Approval Method through Planner. Before we learn about Move order, let us check the only setup for the move orders in organization Parameters. Create a Move order for…
Read MoreUOM and Conversions
Define Units Of Measure: Define units of measure, unit of measure classes, and base units of measure for tracking, moving, storing, and counting items. You can convert between the units…
Read MoreAllow Negative Quantity functionality in Shipping Process
Purpose: The purpose of this Document is to provide some troubleshooting guide for issue where sales orders are not getting backordered even though insufficient inventory is available. Goal: Book a…
Read MoreProblems while creating the New Locations in Oracle R12.2
Problems while creating the New Locations in Oracle R12 ERROR DETAIL: Not able to Create the new Locations as well as Update the existing Locations in Oracle. ERROR MESSAGE: “FRM-40735:ON-UPDATE…
Read MoreInventory Module Setup in Oracle EBS R12.2
What is Oracle Inventory? An Oracle Inventory Module is a facility where you store and transact items. Before you can use Oracle Inventory, you must define one or more inventory…
Read MorePhysical Counting in Oracle Inventory – R12.2
PHYSICAL COUNTING IN ORACLE EBS R12.2 Counting is used to verify the System On hand Quantity with Actual (Physical Qty) Quantity of the item and perform the adjustments in System…
Read More