My Oracle Support Banner

SCM INV: Troubleshooting Tips and FAQs Related To Inventory On Hand Functional Area (Doc ID 2716507.1)

Last updated on AUGUST 22, 2023

Applies to:

Oracle Fusion Inventory Management Cloud Service - Version and later
Oracle Fusion Inventory Management - Version and later
Oracle Fusion Global Order Promising Cloud Service - Version and later
Oracle Fusion Order Management Cloud Service - Version and later
Oracle Fusion Distributed Order Orchestration - Version and later
Information in this document applies to any platform.


 This document provides information about issues or questions related to common Errors, FBDI and Web Services, SQL Queries, FAQs, and a few other processes related to Inventory On-hand functional area


The functionality described in this document applies to Oracle Fusion Inventory Management Application


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Common Issues (UI/FBDI/Web Service/REST API):
 1) Quantity not available to transact or reserve
 2) Back to back sales order issued but still item qty showing under On-Hand and Reservations
 3) Error 'ORA-20101: Unable to request lock' observed when loading on-hand quantity through FBDI
 4) Why disabling 'Allow negative balances' & 'Allow negative on-hand transactions' generate a warning message (RCS-3360127)?
 5) Why on-hand quantity total is not the same as the quantity displayed on the Inventory valuation report?
 6) Unable to view DFF values in UI which were processed using Inventory On Hand Balance FBDI
 7) Error 'INV_LOT_SERIAL_VALIDATION_FAIL - The lot or serial validation failed' when loading item on-hand through FBDI
 8) Why does on-hand quantity details REST service return null on-hand quantity?
 Frequently Asked Questions
 1) How to check the accuracy of Available to reserve (ATR) of an item on-hand quantity?
 2) How is on-hand quantity in the "Manage Item Quantities" UI calculated?
 3) How to view consolidated on-hand quantity for all organizations (at BU level)?
 4) Is there an external event trigger once the on-hand quantity gets updated?
 5) How to query on-hand by using manufacturer part number?
 6) How to correct incorrect on-hand item costs (CST_I_INCOMING_TXN_COSTS) that were uploaded using FBDI?
 7) How to import consignment inventory on-hand quantity into Fusion?
 8) How to automate item on-hand reservation against Transfer Order?
 9) SOAP Web service sample payload for querying all inventory on hand.
 10) How to get current on-hand details of item in specific subinventory using REST API?
 11) Why ATT and ATR is showing 0 while on-hand value shows quantity as 1?
 SQL Queries
 1) Query to Find Inventory On Hand Details
 2) Query to find on-hand quantity under specific expired or unexpired Lot
 Useful Guides and Documentation
 1) Overview of Manage Item Quantities

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.