Posts Tagged ‘Performance Reporting’

YTD Measures “backported” from R12 to R11.5.10.2

Tuesday, February 2nd, 2010 by Barry Crawley

Oracle released a patch (7388541) recently that “backported” YTD measures (in performance reporting) back from R12 to R11.5.10.2. In fact the patch does not backport functionality from R12. What it does is put in new measures in the project list only. Slightly irritating are the following facts:

  • The patch does not backport the YTD measures that exist under the reporting tab
  • The new measures that the patch introduces in R11.5.10.2, under the project list, do not currently exist under the project list in R12. As far as I can understand this is an ‘oversight’ by Oracle in R12, and will be resolved soon.

Anyway, all that aside, below is a link to a PDF file with 5 sections that compares what is available in R11.5.10.2 without the patch, with the patch, and in R12 (as at time of writing).

 Performance Reporting Measures comparison

Sections are:

  • Project List Table
  • PJI – Task Summary
  • PJI – Resource Summary
  • PJI Calculated Measures
  • PJI Stored Measures

Anecdotally I have heard of other problems with this patch. I am interested to hear about anybody’s experiences with this patch.

R12.1.1 – Projects Reporting Pack

Tuesday, December 1st, 2009 by Barry Crawley

The Oracle Projects suite of applications has always suffered from a reporting problem, or at least many user organisations have, for a long time, had a perception that this is the case. The reason for this can be summarised into a couple of salient points:

  • There have always been widely diverse reporting requirements for Projects reporting, not only between user organisations, but also between different users groups within these organisations.
  • Oracle has never quite come up with a ‘one size fits all’ solution to reporting in Projects. In fact the reporting capabilities in Projects have never really measured up to the rich functionality offered by these applications.

So taking a step back and thinking for a minute one can conclude that there is no ‘one size fits all’ solution. To report from the Projects applications you need to consider various options and be prepared to use multiple solutions, even within one organisation, dependent on requirements. There are a numerous options / combinations for consideration, and the selection of the most appropriate ones can be a bit of a minefield, even for the specialist. I do not, in this article, seek to migrate through this minefield, but to let people know that there is something new out there that needs to be considered. That is the R12.1.1 Projects Reporting Pack.

What is it?

It is a feature that enables you to monitor project performance without accessing the applications i.e. it sends reports to via email to recipients who are key members on a project(s). A number of reporting templates are supplied that can be added to a ‘reporting pack’ which is then run through the standard concurrent manager and distributes the reports accordingly.
Read the rest of this entry »

Year-to-Date (YTD) measures available in R12 Performance Reporting

Monday, September 7th, 2009 by Andy Coates

In Oracle Projects 11i, year-to-date (YTD) measures are not available in performance reporting (period to date, quarter to date and inception to date are the only offering). This was/is very odd, as the Project Intelligence (PJI) summarisation tables do summarise measures on a YTD basis. Fortunately, in R12.1.1, YTD measures are now available. For example, the YTD measures can be utilised in the Task Summary page of performance reporting, as well as user defined sored or computed YTD custom measures.

Setting up a custom measure. As can be seen, YTD is now available

Setting up a custom measure. As can be seen, YTD is now availablePersonalising the Task Summary page of performance reporting. As can be seen, all exisiting measures now have YTD equivalents.