Inventory

Query 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*/          …

Query 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,    …

Move 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…

UOM 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…

Allow 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…

Problems 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…

Inventory 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…

Physical 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…

Min-Max Planning Method in Oracle Apps – Planning Level: Organization, Source Type: Inventory, Item: Buy

Planning Level: Organization, Source Type: Inventory, Item: Buy Responsibility: Inventory          Navigation: Items > Master Items. Create a item in Item Master and assign it to Source and Destination Organizations.…

Min-Max Planning Method with various Scenarios in Oracle Apps