My Oracle Support Banner

Problem Updating Item Status Through WebADI -- Error "Error: Material shortage check can not be enabled unless the item is transactable. Cause: An item may not have Material Shortage Check = "yes" unless Transactable = "yes"." (Doc ID 2009221.1)

Last updated on NOVEMBER 01, 2023

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.


Using WebADI to do mass Item Status Updates.
In one case Item Status is being updated from Active to Inactive.
Per the Item Status Attributes configuration, in Active status the Transactable flag is Yes and in Inactive status Transactable flag is No.
In addition to this the Check Material Shortage Flag is Yes for the Item.

Item Status is Master Controlled attribute and Check Shortages Flag is Organization Controlled attribute.

When WebADI is submitted to change the Item Status from Active to Inactive, WebADI throws the below error.
Ideally WebADI program should update the check shortages flag to No when Item status is changed to Inactive as it is dependent on the Transactions enabled flag.
Due to this users have to update manually these flags to change the item status.



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.