Stkvar Failed With ORA-01403 For Late Posted Transaction
(Doc ID 2726504.1)
Last updated on JULY 25, 2022
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
Getting below error when try to run STKVAR job for the late posted transaction.
"stkvar_3~20200424224157~process~stake_prod_loc~1403~ORA-01403: no data found~UPDATE: c_count=295006, item=215623034, dept=3327, class=2, subclass=9, loc_type=S, location=3411"
Steps To Recreate:
1. Create a stock count and ensure one of the subclass doesn't have any transaction or inventory.
2. After it got exploded, post a late posted transaction with post date as of stock take date or earlier.
3. Now upload and accept the count.
4. Notice that the stkvar fails with above error.
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 |