When Inactivating Items in Oracle Item Master / Inventory Management get error: This field can not be updated as there are Open Sales Order lines
(Doc ID 1501868.1)
Last updated on MARCH 02, 2020
Applies to:Oracle Item Master - Version 22.214.171.124 and later
Oracle Order Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Shipping Execution - Version 12.2.1 and later
Information in this document applies to any platform.
Form: INVIDITM.fmb - Master Items / Organization Items
Concurrent: INCIPS - Update item statuses with pending statuses
Concurrent: INCOIN - Import Items
Message Name: INV_TRANSACTABLE_YES_NO
When attempting to inactivate an item in Oracle Item Master / Inventory Management, the following error is raised: "This field can not be updated as there are Open Sales Order lines."
This error message can be raised in Master Items / Organization Items form (INVIDITM) or in the request log of below concurrent programs: (when debug mode is enabled)
- Update item statuses with pending statuses (INCIPS)
- Import Items (INCOIN)
This error message can be raised when just disabling a specific item attribute like the Transactable Flag as well.
"This field can not be updated as there are Open Sales Order lines."
The issue can be replicated at will per the below steps:
- Go to Master Items or Organization Items form, depending on your item attributes control settings:
Inventory: (N) Items : Master Items
Inventory: (N) Items : Organization Items
- Query an active item
- Set Item Status to Inactive (or to any other similar user defined item status) or just disable the Transactable Flag
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