My Oracle Support Banner

Error Message Open Deliver Transactions Are Preventing Inventory Item Attribute Updates (Doc ID 1054029.1)

Last updated on MAY 22, 2018

Applies to:

Oracle Item Master - Version 11.5.10.0 and later
Information in this document applies to any platform.
INVIDITM.fmb
This document is for all users of Oracle EBS 11i and R12 and later.


Symptoms

When updating an Item in the Item Master form INVIDITM.fmb, when trying to un-check the 'Stockable' attribute for an item, Users receive a pop-up with the message: There are open Deliver transactions for this item. Please process these before changing the attribute. But, looking reviewing other Applications such as Work In Process/Receiving/Order Management, using the following scripts, no receipts without deliveries were discovered.

1. SELECT *
   FROM MTL_SUPPLY
   --SUPPLY_TYPE_CODE IN ('RECEIVING','SHIPMENT')
   WHERE ITEM_ID = &INV_ITEM_ID
   AND TO_ORGANIZATION_ID =&ORG_ID;
2. SELECT *
   FROM MTL_DEMAND
   WHERE INVENTORY_ITEM_ID =&INV_ITEM_ID;
3. SELECT *
   FROM MTL_RESERVATIONS
   WHERE INVENTORY_ITEM_ID =&INV_ITEM_ID;;
4. SELECT *
   FROM OE_ORDER_LINES_ALL
   WHERE OPEN_FLAG = 'Y'
   AND INVENTORY_ITEM_ID =&INV_ITEM_ID;
5. SELECT *
   FROM WSH_DELIVERY_DETAILS
   WHERE INVENTORY_ITEM_ID = &INV_ITEM_ID
   AND PICKABLE_FLAG = 'Y'
   AND INV_INTERFACED_FLAG IN ('N','P')
   AND RELEASED_STATUS <> 'D' ;
6. SELECT *
   FROM MTL_MATERIAL_TRANSACTIONS_TEMP
   WHERE INVENTORY_ITEM_ID =&INV_ITEM_ID;
7. SELECT *
   FROM MTL_TRANSACTIONS_INTERFACE
   WHERE INVENTORY_ITEM_ID =&INV_ITEM_ID;

 

Cause

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
Symptoms
Cause
Solution
References


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