Posting of Deal Invoice Fails With ORA-30926 Error: 'Unable to Get a Stable Set of Rows' (Doc ID 1969275.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

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.

Cause

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