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 18.104.22.168 and later
Information in this document applies to any platform.
On RMS 22.214.171.124, STKDLY.PC batch aborts due to missing data in WEEK_DATA table with the below error
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