Hi, I would suggest to verify the base flow sql statements performance. Most likely the view/the query used for this has bad performance. This could be the explanation for the long start up times and long run times for create forecast. Easiest way to identify the performance bottle neck is to put the server to start and verify the session and cursors in the databased used by DemandServer oracle user (If this is the user you have used in the Demand server). This way you could easily identify which cursors are taking a longer time to run. Regards,Jithendra
Hi @Tharaka Senevirathne You could check this after restarting the Demand Plan Server. Regards,Jithendra
Hi @thvilk , One more thing to check is, how many records exist for the query, sql developer by default has a limit for the records returned, 5-6 seconds for 50 records does seem a bit slow, which means if the total amount of records is large, it might take time for the qualify job to execute.
Hi @ravi.soni A bit confused now, At the beginning of the question you mentioned that there is no historical data, that is what lead us down this path of creating a forecast part. But in some way, if there is any historical data, by “some way” I mean having the historical data in one of the default views or a custom view. You can simply map this view with the base flow SQL definition and then run the qualify parts job. Also, I wonder if there are 35k parts without history?
@ravi.soni , No there is no way to import from Excel, but if you have the Inventory part created, you can create the forecast part directly from the Inventory Part Screen using the Forecast Command.
Hi @Alain de Martin de Viviés Yes, You need to download the Demand Forecast Client setup ( if this is what you're referring to). You can download it from the addons section on the Landing Page in Aurena. Furthermore, we have a lite client in Aurena which you can also use, it is found under Demand Planning → Demand Forecast in Aurena. Thanks and Regards,Jithendra
Hi @Alain de Martin de Viviés I had a look at the environment you mentioned, the Demand Server is already connected to Server Setup 1000, if you would want to connect to another Server Setup, you first need to disconnect the server from Server Setup 1000. You can have a look at the below youtube video we have made on this new functionality. Hope it helps . Thanks and Regards,Jithendra
Hi @ravi.soni The MAD value is calculated by theDemand Plan Server, I assume you have used the duplicate functionality to create the new Forecast Part, I would suggest creating the forecast part without using the duplicate functionality. /Jithendra
Hi @ravi.soni , To add parts to the Demand Plan Server we need to run the Qualify Parts Job, but there is no way to automatically qualify parts without historical data, Therefore if you still need to include parts to a specific flow you can do so manually using the Forecast Part window in IEE/Aurena. /Jithendra
Hi @Rasika Lakmal , Oracle client 19 should technically work for Demand Planning Server App 10 UPD 10, we have also come across instances where Oracle 12.2 client works alright with Oracle DB 19c. Regards,Jithendra
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
