My Oracle Support Banner

Cannot Change the Lot Divisible Flag if there is an Open PO or Requisition for the Item (Doc ID 1662667.1)

Last updated on MARCH 12, 2021

Applies to:

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


In : Release 12.1.3, Form INVIDITM.fmb

When attempting to update the Lot Divisible Flag to Yes (‘Y’) in an Organization Items, the following error occurs.

You cannot update this field when :

 - There is on-hand quantity
 - Transactions exist
 - Lots exist

The message appears even though none of the above three conditions is true.

The issue can be reproduced at will with the following steps:
 1.  In the Item Master form.
 2.  Attempt to change the Lot Divisible Flag to 'Yes' for an Item which has no On-Hand, but does have an outstanding Purhcase Order

Need to change this flag to enable user to issue partial lot quantity.

If there is a large number of Purchase Orders outstanding for the Item, it may not be
practical to cancel all of these in order to make the required change.



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

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