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

Last updated on AUGUST 08, 2023

Applies to:

Goal

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:

Error
You cannot update this field when

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

Steps

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.

Solution

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