ReIM_AUTOMATCH_JOB is Getting Failed WITH "UNABLE TO GET A STABLE SET OF ROWS" ERROR
(Doc ID 2722182.1)
Last updated on APRIL 11, 2022
Applies to:
Oracle Retail Invoice Matching Cloud Service - Version NA and laterInformation 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:
- 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 |