My Oracle Support Banner

"ORA-30926: Unable To Get A Stable Set Of Rows In The Source Tables@2CORESVC_SALES_UPLOAD_PRST_SQL..." Error When Executing Salesprocess.ksh Batch (Doc ID 2359180.1)

Last updated on AUGUST 05, 2020

Applies to:

Oracle Retail Merchandising System - Version 16.0 and later
Information in this document applies to any platform.


Batch salesprocess is failing with below error when trying to run salesprocess.ksh with POSU file having two records one with sale and positive quantity and the other with sale and negative quantity.

Steps To Recreate:

  1. Load sales transaction for same item on same business day one with positive quantity and the other with negative quantity 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.



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.