"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 FEBRUARY 18, 2018

Applies to:

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

Symptoms

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.

 

Changes

 

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