"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
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.
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:
- Load sales transaction for same item on same business day one with positive quantity and the other with negative quantity in RESA.
- Execute uploadsales_all.ksh and validate SVC_POSUPLD* tables.
- Execute salesprocess.ksh.
- 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