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 laterInformation 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 |