My Oracle Support Banner

During Item Creation Process Item Zone Price Code is Comparing Zone_Display_Id With Zone_id in RMS (Doc ID 2450811.1)

Last updated on SEPTEMBER 24, 2018

Applies to:

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

Symptoms

When attempting to create a new item in RMS, while setting the Item Zone, the system the SVC process is comparing the zones of the newly created item using the RPM_ZONE.DISPLAY_ID instead of the RPM_ZONE.ZONE_ID.
Since the field can be duplicated it is preventing the item from being created,the following error occurs.

ERROR
-----------------------
@0PACKAGE_ERROR@1ORA-20001: Item/zone id combination passed for modification of pricing record does not exist.,ITEM:100045044@2CORESVC_ITEM.PROCESS_IZP


Steps to reproduce: 

1) Setup zone structure in RPM - at least 2 Zone Groups where the correspondent display IDs overlap.
2) Upload item via item induction.


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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.