My Oracle Support Banner

Error while Sending the XitemMod message to update PRIMARY_UPC_IND From Y To N Or Vice Versa. (Doc ID 2961485.1)

Last updated on JULY 14, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 to 19.3 [Release 19.3]
Information in this document applies to any platform.

Symptoms

When sending a 'XitemMod' message to change the PRIMARY_UPC_IND from Y to N or N to Y, the message is getting consumed but it is not changing the indicator.

Steps to recreate:

  1. Send a xitemmod message for item I1, making that item from Primary UPC to non Primary UPC (that is, PRIMARY_UPC_IND>N</PRIMARY_UPC_IND)
  2. This message is getting consumed by RIB without any error, but it is not changing the primary PRIMARY_REF_ITEM_IND in the system for I1.
  3. Then send another 'xitemmod; message for I2, making it primary (that is, PRIMARY_UPC_IND>Y</PRIMARY_UPC_IND).
  4. Observe that the message fails in RIB with the error ([E] Error ORA-00001: unique constraint (RMSXY.ITEM_MASTER_UK1) violated) as there cannot be more than one primary UPC.

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