Integration of Suppliers from EBS to RMS Fails With Error "ORA-30926 Unable To Get A Stable Set Of Rows In The Source Tables Returned By Program Unit RMSAIASUB_SUPPLIER_SQL.INSERT_ADDRESS"
(Doc ID 2091683.1)
Last updated on MARCH 15, 2019
Applies to:Oracle Retail Merchandising System - Version 14.0.2 and later
Information in this document applies to any platform.
In Retail Merchandising System (RMS) 14.0.x, supplier integration from E-Business Suite (EBS) fails with following error:
Steps to Reproduce:
- Create a new supplier in EBS with 3 supplier sites and verify the message is successfully consumed in RMS.
- Create a new supplier site in EBS for the supplier created and verify the message is successfully consumed in RMS.
- Create another supplier site for same supplier in EBS.
- Note that message fails with error : ORA-30926: unable to get a stable set of rows in the source tables returned by program unit RMSAIASUB_SUPPLIER_SQL.INSERT_ADDRESS.
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