My Oracle Support Banner

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:

Oracle Retail Merchandising Insights - Version 16.0.1 and later
Information in this document applies to any platform.


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.




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.