Unable to Get A Stable Set Of Rows In The Source Tables While Processing POSU File
(Doc ID 2375872.1)
Last updated on MARCH 28, 2018
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!