My Oracle Support Banner

SCM INV: Troubleshooting Tips and FAQs Related To Inventory Reservations Functional Area (Doc ID 2715508.1)

Last updated on AUGUST 30, 2023

Applies to:

Oracle Fusion Supply Chain Orchestration
Oracle Fusion Receiving
Oracle Fusion Shipping
Oracle Fusion Order Management Cloud Service
Oracle Fusion Distributed Order Orchestration
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 Reservations 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
 Reservation Errors
 1) You cannot edit the reservation because the document shipping status prohibits editing. (INV-2416281)
 2) Revised Sales Order shows as Change Pending for ATO make line with GOP error: DOO_FUNC_ERROR "42"
 3) A reservation was not created because the reservation quantity is greater than the available-to-reserve quantity. (INV-2415050)
 4) The Reservation Task fails with errors when the Orchestration process tries to reserve a Sales Order line
 5) The reserved UOM must match the UOM defined in the item master
 6) The reservations cannot be updated or deleted for the material transaction row
 7) The request to create a pick wave was partially completed with warnings
 8) 'FND_AS_UNEXPECTED_ERROR' when attempting to create reservations using FBDI template
 9) You cannot edit the material status because there are reservations against the subinventory. (INV-2415689)
 10) The shipment line was not progressed successfully because an error occurred while validating the quick ship process
 11) You cannot change the status of this locator because reservations are associated with it. (INV-2415699)
 12) You must enter supply information. (INV-2415030)
 FBDI Process
 1) Performing Inventory Reservation using the FBDI Import process
 2) ‘Manage Reservation Interface’ job, to upload reservations using FBDI, is ending in warning
 3) Transfer inventory reservations using FBDI
 4) The value provided for the Account Alias attribute is invalid. Value provided: {ACCOUNT_ALIAS}
 5) Ability to import Reservation against Transfer Order line Using FBDI
 Web Services
 1) Serial Item Reservation using REST API
 2) Updating reservations using REST works fine in Postman with http verb PATCH, but this verb is not working in SOA CS
 3) Unable to fetch the Inventory Reservation using the REST web service
 4) Updating Inventory Reservation using the REST web service
 5) Reserving inventory Lots in bulk, using REST we service
 6) This subinventory value must match the value already entered for subinventory on the sales order line. (INV-2415189)
 7) Reserving a sales order against a purchase order (supply) using Inventory Reservation REST API
 8) Definition SourceShipmentId of type Attribute is not found in InventoryReservations
 Lot Specific Reservation
 1) Automatic Lot reservation is not happening on a Sales Order line
 2) Unable to change Lot Material Status from 'Non Reservable' to 'Reservable'
 Reservations Interface
 1) Records stuck in INV_RESERVATIONS_INTERFACE table with no Errors
 2) Enough On Hand available, no reservations exist, still unable to perform reservations
 Retained Reservations Against Demand Doc
 1) Material shown as reserved, even after the corresponding Sales Order line is Closed
 2) Material shown as reserved, even after the corresponding Sales Order line and Shipment is Cancelled
 3) Material shown as reserved, even after the corresponding Back to Back Sales Order line is Closed
 4) Reservations tied to a past due Sales Order line
 SQL Queries
 1) Database tables to fetch reservation related details, with a sample SQL query
 2) Finding the item reservations against a sales order, and other useful details
 Frequently Asked Questions
 1) Why is the Pick Release not happening for a Sales Order line with Back-to-back item?
 2) How to create a reservation for Demand from a Sales Order, with Supply from a Work Order?
 3) Can a reservation be created for a Purchase Order line, which is closed for Invoicing?
 4) How To Remove the 'Manage Reservation and Picks' Task from the Inventory Task Panel?
 5) How to create custom role to access only manage reservations and Picks task?
 6) Why does the 'Manage Reservation and Picks' UI show order fulfillment line id instead of the sales order line number?

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