Category Archives: Oracle Timesheets

An all new and improved Primavera Solution Portal

We have many clients who use TimeControl with their Oracle-Primavera system.  Perhaps it’s no surprise.  TimeControl has integrated with Primavera since 1997 with P3 and we’ve maintained that link all the way up to the most recent P6r8 release even once Primavera was purchased by Oracle.  Primavera clients who need a single timesheet to update not only the task progress in Primavera but also Payroll, Billing, Finance, Job Costing or HR have looked to TimeControl to provide multi-purpose timesheet functionality that will allow a single point of timesheet entry and multiple back-end uses.
Our relationship with Primavera goes back to 1997 and our relationship with Oracle separately tc6_p6_linkalso goes back to 1997 when TimeControl was first able to store its data in either SQL Server or Oracle (We now also support MySQL which is coincidentally also owned by Oracle).  So the relationship has many facets and runs deep.
We’ve done a little work to remake our TimeControl and Primavera Solution Portal with a range of new materials that we hope you’ll find useful.  Aside from a remake of the portal itself, we’ve got new factsheets, slide presentations, white papers and an all-new on-demand webcast that shoes TimeControl 6 and Primavera’s P6 interacting back and forth.
The integration options between TimeControl and Primavera are extensive.  Not only can you bring into TimeControl Primavera tasks, resources, steps and assignments, you also have abilities on how to match employees to generic skills and Primavera codes to TimeControl user defined fields.  Updating your Primavera project data with TimeControl timesheets is incredibly flexible.  You can update hours and costs, Primavera Step progress, ETC, Financial periods and more.
The new and improved TimeControl / Primavera Solution Portal covers some of the benefits of integrating these two world-class tools including:

  • Automated Business Validation Rules
  • Extensive Rate Management
  • Management of Vacation, Sick Leave, Personal time banks
  • Management of Banked Overtime
  • Included integration with P6 and other project systems
  • TimeControl Mobile interface for tablets and smartphones
  • Missing timesheet management
  • The Matrix Approval Process for Labor Actuals™

Access to the portal and its resources is free.  Find out more at www.timecontrol.com/solutions/primavera.

Selecting TimeControl for Online or On-premises

online_vs_onpremisesWith TimeControl now available to be purchased for on-premises installation and for subscription to our TimeControlOnline hosted timesheet service, there is a choice to make.  Here at HMS we’ve been asked recently “Which is better – Hosted or Purchased?” and the answer isn’t obvious. Whether you subscribe to TimeControlOnline or purchase TimeControl to install on your own servers, there’s lots of great functionality including:

  • Multi-browser easy to use interface
  • TimeControl mobile smartphone interface
  • Links to project management systems like MS Project
  • Links to ERP/Finance, Payroll and HR systems
  • Matrix Approvals
  • Automated Validation Rules
  • Extensive Reporting
  • Vacation approvals
  • Email notifications
  • Multi-lingual functionality

But there specific advantages for both subscribing or installing so we’ve put together some resources that we hope you’ll find useful on our Timesheet Buyer’s Guide solution portal including:

Webcast
A short webcast by our President, Chris Vandersluis comparing the differences of purchasing TimeControl vs. subscribing to TimeControlOnline along with some basic questions you can ask yourself to see which path is optimal for you. Read more…

Slides
A PowerPoint slideshow that is used in the webcast.   Read more…

Factsheet
A 4-page factsheet entitled Online vs. On-premises which puts side-by-side comparison of the different options available with both products.  Read more…

Timesheet Buyer’s Guide
This solution portal contains numerous resources other than those we’ve listed here on how to select a timesheet for your needs and how TimeControl might apply to those requirements.  See more at buyersguide.timecontrol.com.

Linking to Primavera Financial Periods

When linking with Primavera’s P6, TimeControl can now optionally send actuals to be posted directly to Primavera’s financial period table. This is the same destination supported by P6 when “Period to date Actuals” are activated and then posted into a particular financial period.

Using this feature will update both the Actuals which are already updated by previous versions of TimeControl and the period records so that financial and earned value reports in Primavera will report the data in the appropriate financial areas.

In order to activate this function, the Primavera Administrator must first define the financial periods and ensure that the Financial periods completely cover any period for which actuals might be sent from TimeControl. This is done in the Primavera Administration menu.

Primavera Periods

If data from TimeControl is transferred while this option is on and the appropriate financial period for the TimeControl “Date Work Performed is not located, the transferred data will be rejected and this will be reflected in the PM Links log.

In the TimeControl Project Transfer options, the “Transfer to Primavera Periods” option must be selected.
TimeControl Transfer Options
When this option is selected, the Date Transfer Options are no longer selectable as the “Date Work Performed” now becomes the relevant transfer date. This date will be used to determine which Primavera financial period in which to put the posted line data from TimeControl.