Question

Demand Plan Server - Halted Aggregation Error

  • 18 April 2024
  • 2 replies
  • 21 views

Badge +1

I’m working with a customer to set Demand Planner back up in Apps 10.

When running the Create Forecast job for the first time, I have bumped into a few error messages that I haven’t seen before.

1)  Error in Inheritance Aggregation Process

2) Create Forecast - Halted Aggregation Error.

Has anybody seen this before please and knows how to resolve?
 

 


2 replies

Userlevel 5
Badge +12

Hi Stephen,

Looking at the various error messages, here are a few things to check …

‘The period version for the server not valid’

Use the RMB button to validate the dates

 

‘ORA00918: column ambiguously defined’

Sometimes (when the SQL is more advanced or non-standard database views are used) you may need to add “IFSAPP.” as a prefix to the field names as shown below

 

Once these things have been checked, I suspect that the ‘Error in Inheritance Aggregation Process’ may then go away the next time you run the Demand Server jobs.

If not, we would then need to take a look for Forecast Parts which are using Inheritance and check the settings.

I hope this helps and good luck!

Badge +1

Hi Richard,

 

Thank you very much for the response and really good to hear from you. I hope you are keeping well.

I’m going to work this through with the customer and will let you know on the outcome.

 

Thanks again,

Stephen

Reply