My Oracle Support Banner

XITEM - Cannot Use MOD Message To Update Item Status (Doc ID 2065351.1)

Last updated on APRIL 13, 2021

Applies to:

Oracle Retail Merchandising System - Version 14.1 to 14.1.2 [Release 14.1]
Information in this document applies to any platform.



When using the item MOD message via XITEM with the intent of updating an item's status, the status will always get set to the item's current status in the SVC_ITEM_MASTER table rather than the status set in the message. The end result is the status in ITEM_MASTER will not get updated.

Steps to Reproduce:

1. Create an item in worksheet status using the RIB XITEM script.
2. Verify that it is in the SVC_ITEM_MASTER table in worksheet status.
3. Modify the item's status using the XITEM MOD RIB script.
4. Check the SVC_ITEM_MASTER table again which will show that the item is still in worksheet 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.