Sales Upload Fails With "ORA-30926: Unable to Get a Stable Set of Rows" Error

(Doc ID 2109859.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.0 to 14.0.3 [Release 14.0]
Information in this document applies to any platform.
Checked for relevance on 02-August-2017


The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

Batch salesprocess is failing with below error:

Steps To Recreate:

1. Load sales/return transaction for same item on same business day in RESA.
2. Execute uploadsales_all.ksh and validate SVC_POSUPLD* tables
3. Execute salesprocess.ksh
4. Notice that the program fails with above error.




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