My Oracle Support Banner

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 later
Information in this document applies to any platform.


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.




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

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