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