XITEM - Cannot Use MOD Message To Update Item Status
Last updated on APRIL 03, 2017
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.
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