CORESVC_ITEM Does Not Honor Retail Price in XItem / XIZPDesc Record (Doc ID 2076837.1)

Last updated on NOVEMBER 12, 2015

Applies to:

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


The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

Using Retail Integration Bus (RIB), when creating a tran level 2 item and specifying retail prices in XIZPDesc records, rows are written into SVC_XITEM_RIZP with the provided details.  However, when the item is actually created by the item induction process, the items are created with the retail price of the item_parent.

Steps to Reproduce:

  1. Create a style (item_level =1 , tran_level = 2) with retail price (e.g., $24.99) with XItemCre message.
  2. Create a color/size SKU (item_level 2, tran_level 2) with a different retail price (e.g., $25.99) with XItemCre message.
  3. Verify that the 1st item is correctly created with $24.99 in RPM_ITEM_ZONE_PRICE; but that 2nd item is not created with a retail of $25.99 in RPM_ITEM_ZONE_PRICE.


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