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"
Last updated on APRIL 11, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms