When Inactivating Items in Oracle Item Master / Inventory Management get error: This field can not be updated as there are Open Sales Order lines
Last updated on AUGUST 10, 2017
Applies to:Oracle Item Master - Version 22.214.171.124 to 12.1.3 [Release 11.5 to 12.1]
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 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
-- Business impact
Due to this issue obsolete items are still available for transacting which can dramatically affect business operations.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms