AnsweredAssumed Answered


Question asked by sku029 on May 24, 2013
Latest reply on May 24, 2013 by another_martink
Guys, I need help regarding one query. We have one portlet that is showing below data.

Resource name

Project name

Task name

Timesheet status

Pending Actuals (non posted hours on a timesheet)

Posted Actuals

Total Actuals ( sum of posted and non-posted hrs on a timesheet)

Time Period Start

Time Period End

This portlet shows data in weeks. But sometimes last week extends to another month and this is the problem area. What we want that it only display half week data that in part of that particular month and remaining for the next month

How we can select the time period in months in filter instead weeks. I found that BIZ_COM_PERIODS

Table lists periods in months but I am not able to find how to connect it with timesheet tables like PRTIMEPERIOD table. Please suggest me if we it is at all possible.

Also can we use timeslices for this? Your valuable inputs are highly appreciated.