PBCS December 2017 Update

This is a quick post about a recent update in PBCS I noticed by accident 😅,,,

The update as specified by Oracle December 2017 Planning and Budgeting Update

TREE VIEW SET AS THE DEFAULT FOR REPORTS AND TASK LISTS

I know its not a big deal, but I find it efficient and way easier than the old way of navigating reports and task lists which I found time-consuming and nerve-racking. Coming from On-Premise days and old standard interface where we had the relatively easy to navigate task lists and folders, I'm quite happy with this update.

So now when you go to Reports or Tasks the tree view is the default option.

Here is my Tasks card, and by default it's shown as tree (yeah finally!)

And from there you simply expand the task you want rather than select the task from a menu.

And similarly for Reports card

Another update was the new dates custom defined functions which can be handy.

The update as specified by Oracle December 2017 Planning and Budgeting Update

NEW CUSTOM FUNCTIONS IN CALCULATION MANAGER

Five new custom functions have been added to Calculation Manager. Each of these functions correspond to an existing function in that the existing functions return only positive numbers, and the new functions can return either a positive number or a negative number, depending on the calculated result. The new functions (and the existing function to which they correspond) are:

Existing Function	New Function
@CalcMgrDateDiff	@CalcMgrDiffDate
@CalcMgrYearsBetween	@CalcMgrYearsDiff
@CalcMgrMonthsBetween	@CalcMgrMonthsDiff
@CalcMgrDaysBetween	@CalcMgrDaysDiff
@CalcMgrWeeksBetween	@CalcMgrWeeksDiff

It's pretty self explanatory, prior to the new functions you had to make sure your To_Date is after From_Date otherwise you could run into trouble, so we used to workaround this by using validations rules in the form etc, now thanks to the new functions we can build the validation logic in the rule itself if required.

So here is a form with dates and I wrote a simple business rule using the old and new functions to highlight the difference. As you can see the new functions can return negative values unlike the old/existing functions which returns positive values and that could be misleading.

That's it for today.