Unable to Create Xitem With MERCH_HIER_DEFAULT With REQUIRED_IND Set to 'Y' For Location

(Doc ID 2411977.1)

Last updated on JUNE 25, 2018

Applies to:

Oracle Retail Merchandising System - Version 16.0 and later
Information in this document applies to any platform.

Goal

When attempting to create XItem with  MERCH_HIER_DEFAULT setting of REQUIRED_IND='Y for location,  the following error occurs.

2. Invoke a XITEM message using the dept/class/subclass combination for which the required_ind was set to 'Y'.
3. Notice that the message fails and lands in Retail Integration Bus(RIB) Hospital with message, 'The item could not be submitted' .
4. Also note that there are no details on why the message was failed and there are no records in the table ITEM_APPROVAL_ERROR.
 

Solution

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