Retail Merchandising System (MOSC)

MOSC Banner

Error raised during the run of month sales history batch - hstmthupd

edited Jan 5, 2016 9:11AM in Retail Merchandising System (MOSC) 1 commentAnswered

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).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center