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 15, 2018

Applies to:

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

Symptoms

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms