My Oracle Support Banner

Unable to Get A Stable Set Of Rows In The Source Tables While Processing POSU File (Doc ID 2375872.1)

Last updated on APRIL 16, 2020

Applies to:

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


Unable to get a stable set of rows in the source tables while processing posu file with simple pack item.

Steps To Recreate:

1. Create a simple pack item with 2 quantity of component item.
2. Ensure that both the above items have minimum 2 vat code in VAT_ITEM table for the same vat region.
3. Create a sale transaction for the pack item using GUI Screen or RTLOG file.
4. Run saexprms batch.
5. Run uploadsales.ksh.
6. Run salesprocess batch.
7. Check the table SVC_POSUPLD_STATUS , it shows the error : @0PACKAGE_ERROR@1ORA-30926: unable to get a stable set of rows in the source tables@2CORESVC_SALES_UPLOAD_SQL.WORK_TABLE_DENORMALIZE Process_id: 1725 Chunk_id: 1


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.