My Oracle Support Banner

Receive Message 'You Cannot Update This Field When...' Or 'This Field Can not Be Updated...' In The Item Form INVIDITM.fmb (Doc ID 1932995.1)

Last updated on JULY 27, 2018

Applies to:

Oracle Item Master - Version 11.5.10.2 and later
Information in this document applies to any platform.
INVIDITM.fmb

Goal

This document provides solutions to resolve the below messages received when attempting to make an update or change to an Inventory Item in the Master Items or Organization Items form INVIDITM.fmb. A User could potentially receive one of the the following messages when trying to save the Item changes, depending on the change they are trying to make.

Note: These messages are typically not related to data corruption, they are related to the Item being active with outstanding onhand quantity, transactions, or active lots.

A)

On hand quantity exists or There are open delivery transaction for this
item. So please process this before changing the attributes

B)

This field can not be updated as there are either Open Sales Order lines,
Pending Delivery transactions or Incoming Supply transaction.

C)

This field can not be updated as there are Open Sales Order lines

D)

Lot Control, Lot Divisible, Grade Controlled and Child Lot Enabled cannot be updated for this item if:
1) there is onhand quantity or transactions pending
OR
2) there are pending cycle count entries or physical inventory adjustments
OR
3) there are lots defined.

E)

"You cannot update this field when
1) there is on-hand quantity
OR
2) transactions exist
OR
3) lots exist."

F)

There are pending cycle count entries or physical inventory adjustments for this item.
Please process these before changing the attribute.

G)

APP-INV-05381: "Lot numbers exist that have been used for different items
Lot uniqueness will be violated - update not allowed

Please use this document in the following order:
A. Identification Scripts: This will confirm if you are having this data corrution.
B. Verifying your file versions: This will allow you and Support to confirm if you are already using a known fixed version.
C. Root Cause Analysis. It shows all the relevant information about this issue Root Cause.
D. Datafix Instructions. It will provide steps for fixing the data corruption.

Solution

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
Goal
Solution
 A - Identification Scripts.
 1. Determine the control level of the attributes that you are trying to change
 2. Determine the ORGANIZATION_ID and INVENTORY_ITEM_ID associated with the item with the issue
 3. Check files for pending inventory transactions
 4. Check for on-hand quantities
 5. Check for pending supply or demand
 6. Check for unprocessed sales orders
 7. Check for outstanding shipping transactions
 8. Check for open physical inventory entries
 9. Check for open cycle count entries
 10. If changing lot controlled item, check for enabled lot numbers for the Item / Organization combination
 11. Check for MRP scheduled items
 12. Check for WIP repetitive items
 13. Check for open move orders
 14. If the Install Base Product is installed, check the CST_TXN_ERRORS table
 15. Check for existing OPM batches related to WIP transactions
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. The given error messages can happen in the INVIDITM.fmb form if one of the following is true for the Inventory Item being updated
 2. Check the data
References

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