Oracle R12 Projects – Contingent Worker Functionality


The Contingent Worker functionality available from Oracle allows you the ability to setup contingent workers as sub-contract employees in the HR system.  Thus, allowing them to enter time in OTL.  The integration with Oracle Projects allows these transactions to be interfaced as labor transactions rather than supplier invoice transactions.  In addition, you may also implement additional AutoAccounting rules to derive further detailed accounting for these transactions.  PO/AP integration allows for the automatic generation of receipts based upon approved timecards and additionally, allows for the automatic creation of supplier invoices.

As far back as Family Pack M for Oracle Projects Contingent Worker functionality has been in place.  And with the current release Oracle has made the functionality more robust, however, there still seems to be quite a number of basic questions as to how the functionality works and that’s what we’ll focus on today.

What are the advantages of implementing the Contingent Worker functionality? – There are several advantages to implementing this functionality

  • Invoice Reconciliation
    • By implementing Electronic Receipt Settlement (ERS) for your contingent worker vendors you can eliminate the tedious effort of reconciling vendor invoices to hours recorded to a project.  With ERS vendor invoices are automatically created based upon the approved timesheets for their contingent workers
  • Project Billing
    • By interfacing the contingent worker transactions as labor transactions to Projects, contingent workers can be billed the same as employees, thus eliminating any issues with converting vendor dollars to labor hours.
  • Project Performance
    • With contingent worker transactions processed as labor you will gain the benefits of being able to track all labor hours on the project against budget.  This will aid in the development of more accurate forecasts.
    • In addition, you will also be able to maintain a historical record of all labor charges for future bids and proposals.

Do we have to implement Accrue on Receipt functionality for the Contingent Worker functionality to work? – In a word, no.  The only thing that needs to be done is to make sure the matching level is set to three-way and the supplier is Pay on Receipt for the purchase order for the services.

What are the options for controlling the transactions and accounting for Contingent Worker transactions? – On the Costing tab of the System Implementation Options form you can select whether or not you want to import Contingent Worker transactions. This option will determine whether or not the costs are viewed in projects as labor transactions or as supplier invoice transactions.  In addition, you can also select whether or not you want to interface the Contingent Worker transactions from Projects to GL.  If this option is checked you will need to take into consideration the fact that the accounting lines from AP will post to GL and you do not want to double post the transactions.  As an example, your accounting from AP would look like the following:

  • DR = Expense
  • CR = AP Liability

While the accounting from Projects for the Contingent Worker labor could look something like this:

  • DR = Job Cost
  • CR = Expense (Same as account above)

Are remaining Purchase Order balances stored as Commitments? – As a matter of fact they are and depending upon your method of importing the costs to projects the commitments are relieved.

What types of adjustments are available in for Contingent Worker transactions?  The standard adjustments in Oracle Projects (Transfers, Splits, etc.) are available to use as with standard labor transactions.  In addition, options can be set in OTL to allow for the timecards to be adjusted even though it has already been approved.

About these ads

One response to “Oracle R12 Projects – Contingent Worker Functionality

  1. Hi Shiv,

    Thanx for the information. It’s really helpful.
    I have a doubt here. How would Contingent Worker Functionality affect , in case, the payroll and time mangement is handled by the third party.

    Thanx in advance.
    Rhythm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s