Plan Run Fails With An Error: Analytical Query for engine derived dates is not valid or fails. Number of History Buckets

(Doc ID 2227882.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Fusion Planning Central Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

Executing a Demand Plan fails with an error:

"A database error occurred. Contact your help desk."

Analysis of the Log File attached to the RunPlan process in the Scheduled Process Screen revealed the following error:

Full run mode. Analytical Query for engine derived dates is not valid or fails. Number of History Buckets

The issue can be reproduced by executing the following steps:
1. Login to Fusion Application
2. Navigate to Value Chain Planning -> Planning Central
3. Search for Desired Plan -> Highlight the Plan -> from the Actions Menu select Run
4. Expand the Details -> Fill in required details -> Select Ok
5. Navigate to "Scheduled Process" and monitor Plan Run

 

 

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