Inventory

Item Regulatory Interface

Procedure: Item Regulatory Interface Objective The purpose of this document is to outline the process for loading and updating Item Regulatory Information into…

Item Where-Used Analysis Report (Excel – PL/SQL)

Introduction: This blog has the SQL query that can be used for Item where used Report in Oracle Apps R12. Cause of the issue: Business wants a PLSQL excel based…

Query to get Shipping and Inventory Material Transactions in fusion.

SELECT dha.source_order_number, dha.order_number, dfla.status_code, dfla.source_line_number FROM fusion.doo_headers_all dha, fusion.doo_fulfill_lines_all dfla,…

Query to get Inventory on hand quantity details in fusion.

SELECT esi.inventory_item_id, esi.item_number, esi.organization_id, inv.organization_code, esi.enabled_flag, esi.end_date_active, ohq.transaction_quantity onhan…

Updating bulk records pending under Inventory Transactions using Oracle Visual Builder Add-in

Introduction: The Oracle Visual Builder Add-in for Excel connects Excel spreadsheets with REST services, enabling you to retrieve, analyze, and edit business da…

Delete ITEM Category in EBS using API

Delete ITEM Category in EBS using API. Introduction: To delete an Item Category in Oracle E-Business Suite (EBS) using an API, you’ll typically interact with an…

Inventory Item Product Variant Setups Creation

This document provides detailed steps on how to create the Style Item and SKU Items from UI. The Style items can be used to group similar items (called SKUs or…

Oracle EBS – Query to get Price list details for 5 Years

 Execute the below query into EBS database. SELECT line, empty, pricing, item, from_date, TO_DATE, total, uom, attirubute, org FROM (SELECT ‘NL’ line, ” empty,…

Query to fetch Routing Details

Introduction: Routing is a set of operations that will be performed in sequence to manufacture an assembly Item. The below query will give the operation sequenc…

Update Item Using SOAP Webservice – Oracle Fusion

Introduction: This blog has the SOAP Webservice details that can be used to update the item data in Oracle Cloud application. Cause of the issue: Business wants…

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: Busin…

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

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…

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,   &n…

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…

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…

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…

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. E…

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

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

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

Min-Max Planning Method with various Scenarios in Oracle Apps

Receiving Transaction Processor errors out with error numbers RVTTH-445, RVTBM-008 & RVTBM-120

RECEIVING TRANSACTION PROCESSOR ERROR ISSUE Title: Receiving Transaction Processor errors out with error numbers RVTTH-445, RVTBM-008 & RVTBM-120 Issue Descript…