Error "ORA-01403: No Data Found" When pressing Snapshot Button In Recount
(Doc ID 2879002.1)
Last updated on NOVEMBER 24, 2023
Applies to:
Oracle Retail Store Inventory Management - Version 16.0.3 and laterInformation 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 |