Error raised during the run of month sales history batch - hstmthupd
Hi All,
We are using RMS 14.1.
Running the RMS batches schedule, the last 2 months we had the below error:
"hstmthupd_1~20160102192250~init~system_variables, period, system_options~1403~ORA-01403: no data found~You are attempting the end-of-month run but the system date is not the next scheduled end-of-month."
The Gregorian Calendar is setup correctly. Also in period and system_variables tables we have the correct data.
Refeodinventory.ksh has run successfully prior to hstmthupd batch execution.
The sales per month posted in ITEM_LOC_HIST_MTH table are not completely, speaking about Item/loc information (we have sales for many stores, but in this table are posted sales just for 2 stores for last month).