My Oracle Support Banner

Stkvar Failed With ORA-01403 For Late Posted Transaction (Doc ID 2726504.1)

Last updated on NOVEMBER 10, 2020

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information 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


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