Fatal Exception in Price Inquiry Screen: "No row with the given identifier exists" (Doc ID 2022225.1)

Last updated on APRIL 14, 2017

Applies to:

Oracle Retail Price Management - Version 14.0.1 and later
Information in this document applies to any platform.

Goal

The Retail Price Management (RPM) application is throwing the following error on the Price Inquiry screen when selecting all available zone groups:


Steps to Recreate: 

  1. Create a new store.
  2. Make sure the store has been created in Retail Merchandising System (RMS).
  3. Do not range an item to this store.
  4. Delete this store and execute the dlyprg batch in RMS
  5. Ensure that the store has been deleted.  No rows inserted into RPM_STAGE_DELETED_ITEM_LOC table.
  6. Now run itemLocDeleteBatch.sh to delete location information from RPM tables.
  7. Note that after running the RPM item location delete batch, you still see the record in the RPM_ZONE_LOCATION table.  This causes an issue with the RPM price inquiry screen.

 

Solution

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