My Oracle Support Banner

Error "ORA-01403: No Data Found" When pressing Snapshot Button In Recount (Doc ID 2879002.1)

Last updated on JUNE 24, 2022

Applies to:

Oracle Retail Store Inventory Management - Version 16.0.3 and later
Information in this document applies to any platform.

Symptoms

After upgrade to 16.0.3.9 we find an error when doing the snapshot.

In sim log:
2022-05-16 16:34:59,802 ERROR [[ACTIVE] ExecuteThread: '31' for queue: 'weblogic.kernel.Default (self-tuning)'][o.r.s.s.d.d.StockCountOracleDao] Error executing stored procedure: {call stock_count_pkg.snapshot (?, ?, ?) }
java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "SIMPROD.STOCK_COUNT_PKG", line 1104
ORA-06512: at "SIMPROD.STOCK_COUNT_PKG", line 1216
ORA-06512: at "SIMPROD.STOCK_COUNT_PKG", line 1342
ORA-06512: at line 1

Steps to reproduce:

Prerequisites: Ensure the next values for STOCK_COUNT_CHILD_SEQ and STOCK_COUNT_ID are different.
1. Create Unit stock count for one item and schedule for today. Select to recount discrepancy and set variance to 0.
2. Validate SOH.
3. Take snapshot.
4. Do the counting with difference (example: stock was 79, count as 70) and complete.
5. Carry out the second count (snapshot, recount). Once pressing the Snapshot button, error is triggered.

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.