Deleting a Supplier Site in EBS Throws Error "ORA-30926: Unable to Get a Stable Set of Rows in the Source Tables"
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Merchandising System - Version 13.2.6 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.
Deleting a supplier site in EBS throws the below error message.
"com.oracle.retail.rms.integration.services.supplierservice.v1.IllegalStateWSFaultException: Error ORA-30926: unable to get a stable set of rows in the source tables returned by program unit RMSAIASUB_SUPPLIER_SQL.INSERT_ADDRESS"
Steps to recreate:
- Pick an existing supplier with 3 sites, already integrated with RMS.
- Choose one of the sites and delete it in EBS. This will inactivate the site in RMS.
- Observe in RFI logs that the mentioned exception above is raised.
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