My Oracle Support Banner

ReIM_AUTOMATCH_JOB is Getting Failed WITH "UNABLE TO GET A STABLE SET OF ROWS" ERROR (Doc ID 2722182.1)

Last updated on OCTOBER 27, 2020

Applies to:

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

Symptoms

When running the REIM_AUTOMATCH_JOB getting failed with the following Error :

Error:

Execution of stored procedure / function : REIM_AUTO_MATCH_SQL.PERFORM_DETAIL_MATCHING failed with the following error message:
@0PACKAGE_ERROR@1ORA-30926: unable to get a stable set of rows in the source tables@2REIM_AUTO_MATCH_SQL.PERFORM_SKU_LVL_DETL_MATCH_PO
Detailed inputs are printed : {I_MATCH_STGY_DTL_ID=xxx, I_CHUNK_ID=X, I_MATCH_LUW_ID=Y, I_WORKSPACE_ID=xxx, I_MATCH_TYPE=xxx}
ORA-30926: unable to get a stable set of rows in the source.

Steps To Recreate:

  1. Run ReIM AutoMatch Batch.

Changes

 

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!

In this Document
Symptoms
Changes
Cause
Solution
References


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