STKDLY Batch Fails With 'No Data Found' Error for Regular Calendar

(Doc ID 1937448.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

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

Symptoms

In Oracle Retail Merchandising System (RMS) 13.2.x, the STKDLY batch fails with the following error for a regular calendar:

 



Steps to Reproduce:

  1. Make sure the SYSTEM_OPTIONS.CLOSE_MTH_WITH_OPN_CNT_IND = 'Y' and CALENDAR_454_IND = 'C'.
  2. Schedule a stock count for 24/08/2014.  Execute the process until stock ledger adjustment authorization.
  3. Run STKDLY on 25/08/2014. The batch will fail with 'no data found in MONTH_DATA' error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms