Master And Organization Items Form INVIDITM.fmb Cannot Save Changes To Items After Upgrade Of Database To 220.127.116.11
Last updated on JUNE 16, 2016
Applies to:Oracle Item Master - Version 12.1.1 and later
Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
In the Master and Organizations Items form INVIDITM.fmb, Inventory Items are not saved after hitting save, even thought the form reports the items are saved. Also when use when using the Translation Icon the item information is not saved.
There is no visible indication that the item is not saved, the database trace does not have rollback.
When the item is re-queried it can be seen item has not been changed.
1. Navigate to Inventory > Items > Master or Organization Items.
2. Query an item.
3. Make a change and note the new value.
5. Requery the item.
6. The original value is present.
In some cases, the following error is detected in the trace file
SELECT 1 FROM DUAL
WHERE ICAV.INVENTORY_ITEM_ID = TEMP.INVENTORY_ITEM_ID
AND ICAV.PO_LINE_ID = TEMP.PO_LINE_ID
AND ICAV.REQ_TEMPLATE_NAME = TEMP.REQ_TEMPLATE_NAME
AND ICAV.REQ_TEMPLATE_LINE_NUM = TEMP.REQ_TEMPLATE_LINE_NUM
AND ICAV.ORG_ID = TEMP.ORG_ID
Error encountered: ORA-00904
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