Introduction:   This SQL query is used to fetching the data of FG Items where used details like  Component Item, Component Item Description, Parent ,Parent Item Description, Item Seq, [...]

SELECT   recs.doc_type, recs.item_number, recs.doc_no, recs.po_number,          recs.organization_id, recs.inventory_item_id, recs.primary_quantity,     [...]

SELECT ALL mtl.organization_id, orgs.NAME organization_name,            mtl.inventory_item_id, mtl.segment1 item_number,           [...]

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 the same item and [...]

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 of [...]

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 [...]

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 [...]

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 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 OHQ. These are [...]

Planning Level: Organization, Source Type: Inventory, Item: Buy Responsibility: Inventory          Navigation: Items > Master Items. Create a item in [...]