My Oracle Support Banner

Batch Engine Completes Successefully But No Future Forecast Generated In The Worksheet (Doc ID 549708.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version and later
Information in this document applies to any platform.
***Checked for relevance on 14-Mar-2013***


On  in Production:
The user loaded POS data in preparation for a batch analytical engine run. Normally the batch
engine takes approximately 10 minutes to run to completion. This particular run the batch engine
only ran for 10 seconds instead of 10 min and it did not create any new expected future forecast.
The forecast_history table shows status=1 (successful) for the current engine run. The
engine2k.log has a misleading error message which can be ignored but creates confusion since it's
shown as an error:

RAC is not available.

Further troubleshooting shows that all item location combinations in the mdp_matrix table have
prediction status = 99 (dead). It is unknown how this happened as the engine will only work on
combinations with prediction_status = 1 (mature). The 2 parameters on init_parms_0 and
sys_params table called " last_date_backup = "01/06/2008" and max_sales_date = "01/06/2008" appear
to be set correctly

Expect the batch engine run and generate future forecast which will be available to users. .

The issue can be reproduced at will with the following steps:
1. Run the batch analytical engine
2. Check worksheets to see if new future forecast was created, but it was not.

The issue has the following business impact:
Future forecast is not generated by the forecast analytical engine. Therefore users cannot manage
any new future forecast for item location combinations.



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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.