"ORA -30926: Unable to get a stable set of records" Error Occurs in ITEMLOC Form
Last updated on JANUARY 04, 2018
Applies to:Oracle Retail Merchandising System - Version 14.0.2 and later
Information in this document applies to any platform.
The following error occurs on the [itemloc] form:
Error: ORA -30926: Unable to get a stable set of records returned by program unit NEW_ITEM_LOC_SQL.COMPUTE_ITEM_COST
The issue occurs only when ranging is done for ALL Stores or in a location list where there are multiple stores. For single locations, no error occurs and the item gets ranged.
Steps to Reproduce:
- For an approved item, try to range it to Group Type as Location List-Store. The location list should have multiple stores.
- Provide the supplier details and source method as Supplier.
- Click on Apply.
- Message appears that ranging will happen in asynchronous mode.
- Error message above appears on screen and no ranging happens.
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