Transaction Tender Fact Load Failed in Retail Insights With an Error "ORA-30926: unable to get a stable set of rows in the source tables" (Doc ID 2507597.1)

Last updated on DECEMBER 03, 2019

Applies to:

Symptoms

Merge statement of SIL_RetailTrxTenderFact package return duplicate data ,In Mapping SIL_RetailTrxTenderFactLoad, VOUCHER_NUM and COUPON_NUM is missing in join condition of Merge Statement. Due to this while updating back posted data package error out.

Steps to Recreate:
1. Day 1 - Data for W_RTL_TRX_TNDR_LC_DY_F was loaded .
2. Day 2 - Data extracted from RDE but fails when we try to load that file in RI.
3. Due to missing columns in Merge statement, batch aborts with the error "ORA-30926": unable to get a stable set of rows in the source tables.

Changes

Cause

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