My Oracle Support Banner

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 FEBRUARY 03, 2019

Applies to:

Oracle Item Master - Version 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


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)

This error message can be raised when just disabling a specific item attribute like the Transactable Flag as well.

-- Error
"This field can not be updated as there are Open Sales Order lines."

-- Steps
The issue can be replicated at will per the below steps:

  1. 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
  2. Query an active item
  3. 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

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