Set Resource Daily Availability – Oracle & SQL

This process must be run using the “Execute a Process” job.  Job may be scheduled or run on-demand.  Process pulls Availability Rate from the Availability blob for each resource, where blob is not null.  Then it populates this value into a custom Daily Availability attribute (Number field with 2 decimals) on the Resource object.  This field does not have to be displayed to be used for reporting.

Because the OOB Availability Rate field is stored only in a blob, it is difficult to include in portlet or report output.  The use of this custom attribute makes the value easily reportable.