"ORA -30926: Unable to get a stable set of records" Error Occurs in ITEMLOC Form
(Doc ID 2095549.1)
Last updated on FEBRUARY 27, 2019
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.
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