My Oracle Support Banner

How To Update Lot Divisible Flag To Yes (Y) In Organization Items (Doc ID 1106005.1)

Last updated on AUGUST 08, 2023

Applies to:

Oracle Inventory Management - Version 11.5.10 and later
Oracle Item Master - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.


How do you update the Lot Divisible Flag to Yes (‘Y’) in Organization Items (form)?

If Transactions or On-hand or Lots Exist, the following error occurs:

You cannot update this field when

  1. There is on-hand quantity
    - OR -
  2. Transactions exist
    - OR -
  3. Lots exist.


  1. Query an Organization Item having "Transactions or On-hand or Lots" and with the following attribute values:
    • Lot Control attribute value = "Full Control"
    • Lot Divisible attribute value = "N"

  2. Attempt to update Lot Divisible attribute value = "Y" manually or using Item Import.

  3. The error appears.


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
 A. Workaround
 B. Patch

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