Ranging Mass Item/Locations Returns 30926 - Unable to Get a Stable Set of Rows Error (Doc ID 2012799.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 14.0.1 to 14.0.2 [Release 14.0]
Information in this document applies to any platform.

Symptoms

Ranging mass item/locations is very slow and sometimes fails with below error:

"javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_XITEMLOC.CONSUME(?,?,?,?)}: [E] Error ORA-30926: unable to get a stable set of rows in the source tables returned by program unit NEW_ITEM_LOC_SQL.GET_SUPPLIER.; nested exception is: com.retek.rib.binding.exception.RIBIntegrationException: Exception while processing request: Error from {call RMSSUB_XITEMLOC.CONSUME(?,?,?,?)}

Cause

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