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 7.0.2.4 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Mar-2013***


Symptoms

On 7.0.2.4  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

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

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


BUSINESS IMPACT
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.


.

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