My Oracle Support Banner

Reim Auto Match Batch Fails With 'unable To Get Stable Set Of Rows' Error (Doc ID 2934462.1)

Last updated on MARCH 13, 2023

Applies to:

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


Reim auto match batch fails with 'unable to get stable set of rows' error

Steps to recreate:
1. Make sure to setup IM_SUPPLIER_GROUPS for the supplier with MATCH_KEY as PO
2. Create an item with same supplier and multiple origin countries and unit cost in item_supp_country table.
3. Create order with the above item criteria with two different locations and two different unit cost in ordloc.
4. Create an invoice for the above order and try to run auto match. Now notice that the job gets aborted with the 'unable to get stable set of rows error'.


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

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