My Oracle Support Banner

"ORA-30926...@2CORESVC_SALES_UPLOAD_SQL.WORK_TABLE_DENORMALIZE" Error While Processing POSU Files (Doc ID 2397453.1)

Last updated on MAY 10, 2018

Applies to:

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

Symptoms

The application throws the following error when processing POSU files.

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: 5006 Chunk_id: 1"

Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the Export of POS transactions from ReSA to RMS (SAEXPRMS) batch.
2. Run the UPLOADSALES_ALL.KSH script.
3. Run the Main Processing of Staged Sale/Return Transactions (SALESPROCESS.KSH) job.



Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.