Blogs about: Oracle Inventory

Featured Blog

How can I unreserved quantity, Reserved against a closed / canceled sale order

Problem In one of my operating unit sale officer enter order and released to ware house, after that sale officer cancel that sale order. Now it showing me quantity reserved for that sale order in syst… more »

Oracle E-Business Suite

Creating Oracle Home Inventory - Oracle Database 10g

advait wrote 4 months ago: Some times you clone an oracle home manually using OS level commands and this might cause problem in … more »

Tags: oracle database 10g, inventory corruption, register oracle_home

Oracle Purchasing with Other Oracle Applications Modules

Ahmad wrote 1 year ago: Oracle Purchasing with Other Oracle Applications Modules Oracle Purchasing integrates with a number … more »

Tags: Oracle General Ledger, Oracle Purchasing

How can I unreserved quantity, Reserved against a closed / canceled sale order

Ahmad wrote 2 weeks ago: Problem In one of my operating unit sale officer enter order and released to ware house, after that … more »

Tags: Oracle Order Management, SQL, How can I unreserved quantity reserved against a cancel, Inventory, Reservations Are Not Relieved When Order is Canceled or

Serial number is not available when doing a inventory transaction but shows in on hand quantity

Ahmad wrote 1 month ago: serial-number-is-not-available-when-doing-a-inventory-transaction-but-shows-in-on-hand-quantity … more »

Tags: SQL, serial number enabled item, serial number not shown in transaction interfaces, sub inventory

Formula to Calculate Available to Reserve at Different levels

Ahmad wrote 1 month ago: The formula is   Actual Available to Reserve = Minimum (Available to Reserve at Particular node/Su … more »

Tags: General, Available to Reserve, Inventory

SubInventory Creation

chetanz wrote 1 month ago: Subinventories are logical seperations of material inventory such as raw material, finished goods an … more »

Tags: Oracle E-Business Suite, oracle applications, Oracle Apps, Subinventory, Inventory, Oracle Subinventory

How to Delete Stock Locators by Using API — 2 comments

Ahmad wrote 2 months ago: How to Delete Stock Locators by Using API … more »

Tags: SQL, Stock Locators

How to Create Stock Locators By using API

Ahmad wrote 3 months ago: How to Create Stock Locator by using API … more »

Tags: Oracle Application Object, SQL

Item Catalogs Overview

Ahmad wrote 6 months ago: Oracle Inventory lets you use item catalogs to partition your items into groups that share common ch … more »

Change serial number on a Transacted Move Order

Ahmad wrote 7 months ago: The user types invalid serial number while transacting a move order during pick release. User type … more »

Tags: Oracle Order Management

How to Check Sale Order Flexfieled Setup — 3 comments

Ahmad wrote 8 months ago: Run following query by connecting User APPS SELECT id_flex_structure_code structure_code, DECODE (d … more »

Tags: Oracle Application Object, Oracle Order Management

Demand and reservation information used in Available To Promise, Planning and other Manufacturing Functions

Ahmad wrote 8 months ago: Following query returns Demand and reservation information used in Available To Promise, Planning an … more »

Tags: Oracle Advanced Supply Chain Planning, Oracle Manufacturing, Oracle Order Management

What are make to order and make to stock items in Oracle E-Business Suite and what are there decision factor?

Ahmad wrote 8 months ago: What are MTO and MTS in Oracle E-Business Suite and what are there decision factor? Make to Order (M … more »

Tags: Oracle Advanced Supply Chain Planning, Oracle Manufacturing, Oracle Order Management

Order Management Integration With Oracle Inventory Module — 1 comment

Ahmad wrote 1 year ago: Order Management integrates with Oracle Inventory Management in the following areas: Managing reserv … more »

Tags: Oracle Order Management