How To Change Allow Reservations On Material Status When Status in Use? Request Datafix? -- Not Possible / "Cannot update status. On hand inventory or inventory locations exist"

(Doc ID 2387412.1)

Last updated on APRIL 17, 2018

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

How can you "Allow Reservations" checkbox on an existing material status that is already in use?

(Can you give a Datafix to change the Allow Reservations checkbox of the material status?)

Steps
1. Navigate to Inventory > setup > transactions > Material status
2. Query an existing status (that has been used like on a subinventory)
3. Attempt to change "Allow Reservations" from Yes to No.
4. Receive the error:


 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms