My Oracle Support Banner

Creating Non-sellable Item Using XItem Is Populating ORIGINAL_RETAIL Causing XItemMod To Fail (Doc ID 2850730.1)

Last updated on JANUARY 11, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

When a pack item is created via RIB XItem API, with Sellable_Ind = 'N', the pack is still getting a original retail price assigned.

When trying to send an update message for this item, it fails with the below error:

Error:

Error from {call RMSSUB_XITEM.CONSUME(?,?,?,?)}: [E] Error ORA-20001: Field should be NULL.Field: ORIGINAL_RETAIL,ITEM:XXXXXXXXXX returned by program unit CORESVC_ITEM.PROCESS_IM., stackTrace=java.lang.RuntimeException: Exception calling plsql inject.

Steps to recreate:
1) Create a non-sellable item using XItemCre message.
2) Update the same item using XItemMod message.
3) XItemMod message fails.

Changes

 

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
Changes
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.