Posting of Deal Invoice Fails With ORA-30926 Error: 'Unable to Get a Stable Set of Rows'

(Doc ID 1969275.1)

Last updated on MARCH 02, 2018

Applies to:

Oracle Retail Invoice Matching - Version 13.2.7 and later
Information in this document applies to any platform.


In Oracle Retail Merchandising System (RMS), when attempting to post a deal (whether a fixed or complex one) that has multiple locations, the following error occurs:

Steps to Reproduce:

  1. Create Deals either fixed or complex with multiple locations in RMS and upload to ReIM.
  2. Run reimposting batch.
  3. Notice the error.


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