How to extend Calendar to 2030 in Demantra

Problem: Demantra has calendar with dates only till 2010, as you could have possible seen in table INPUTS too. With 2009 going on, customers need the calendar to be extended way further in future.

Solution: Oracle has released a patch for this and is now available on Metalink for download.

Details: If your version of Demantra has INPUTS table extending only till 2010, then you need to refer to metalink note (551814.1). Based on which version of Demantra you are running, you can download specific patch to resolve your problem.

Remember that this patch would only populate standard columns and any custom columns representing your custom calendars will need manual intervention. You can populate your custom column upto 2030, once this patch extends the records to dates till 2030.

Metalink note: 551814.1

Demantra Versions applicable: 6.2.6, 7.0.2, 7.1.1, 7.2.0.X