My Oracle Support Banner

Stkdly Batch Program Failing With ORA-01403 Error Due To Missing WEEK_DATA Row (Doc ID 1333611.1)

Last updated on AUGUST 07, 2020

Applies to:

Oracle Retail Merchandising System - Version and later
Information in this document applies to any platform.


On RMS, STKDLY.PC batch aborts due to missing data in WEEK_DATA table with the below error

stkdly_1~20110322012521~stock_result_cost~week_data~1403~ORA-01403: no data found~UPDATE: stock count (cost), dept=777, class=771, subclass=772, location=7792, loc_type=S, half=20112, month=3, week=4

Steps To Recreate:


1. Create a stock count with a stocktake date in a week other than the last week of the month.
2. Run stock counts jobs on the appropriate days (stkxpld, stkupd, stkupld).
3. Process stock count variances and adjustments and  run stkvar.
4. Run STKDLY to close stock count - it errors out.




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.