Time & Labor to Payroll to Projects – Pathways to Integration in Oracle Cloud

Integrating Time and Labor into Payroll and Projects

Is your company encountering issues attempting to integrate Time and Labor to Payroll to Projects? Keep reading as we dive into an Elire use case highlighting how to best integrate the two applications. 

Delivered Functionality Overview 

Time and Labor integration into Projects allows for validation of project-related reported time and the transfer of project-related reported time to Project Costing. There is no direct integration from Oracle Payroll to Oracle Projects, but we’ll offer you solutions that can easily meet your needs and fill gaps as you work to integrate the processes.  

Check out this overview of the delivered integration Oracle provides for Project Costing:  

overview of the delivered integration Oracle provides for Project Costing

Integration Requirements  

Typical Integration Requirements: 

In a typical integration process of Time and Labor to Payroll to Project, the following application requirements are taken into account:  

  1. Project is an assigned Segment in Chart of Accounts  
  1. Direct Labor Cost captured from OTL to Projects  
  1. Fringe Costs calculated off Project Segment in Payroll Costing and integrated into projects as needed  
  1. Grants allow for Direct labor and usually Fringe costs  

Unique Integration Requirements: 

In a unique integration process of Time and Labor to Payroll to Project, the following application requirements are taken into account:  

  1. Send detailed labor and non-labor costs to Projects by day 
  1. Include element, project, task, and expenditure type 
  1. Proration of costs required across non – chartfield segments 
  1. Labor and non-labor costs that include: 
  1. Project-related reported time 
  1. Absences taken 
  1. Monetary amounts for time, absences, and payroll 
  1. Labor costs associated with Fringe costs 

Typical use cases and unique use cases are different as Typical use cases only require payroll costs (Direct Labor and Fringe) which can be derived from OTL and a Project Segment in Oracle utilizing the Delivered Payroll Costing Functionality. Whereas Unique use cases need proration of costs required across non-chartfield segments. 

Gaps Between Unique Requirements and Delivered Capabilities  

Assessing the gaps across the Time and Labor to Payroll to Projects process, holes can be found with the allocation of absences taken to projects. For example, absences taken for vacation, paid time off, or jury duty. Unfortunately, delivered reported absences pages do not include functionality to report project-related data. 

The second gap that can be found is the capacity to define Expenditure Type when using multiple assignments. This may look like an Expenditure Type based on a combination of factors such as element or employee attributes.  

The third and final gap that can be found is the allocation of non-labor costs and fringe projects – these include FUTA, SUTA, FICA, and 401K employer contributions.  

Approach to Identifying Solutions  

When looking for solutions to integration hold-ups, you must first review the project requirements and identify the gaps. You must identify the delivered configuration to be leveraged and test different configuration options to determine what is and what is not viable. You must then collectively discuss with your team to identify viable options before moving forward with configuration, development of interface, and testing.  

Elire’s Solution 

Elire’s solution at a high level replaces the delivered integration with a custom one that calculates, compiles, and sends data to project costing. Data to be sent includes hours of worked time and absences taken, monetary amounts, and Fringe.  

By undertaking this Elire solution, you will be provided with a level of granularity required for Federal Oracle Cloud Users. Additionally, the solution is fully developed within the Oracle Cloud SaaS application.  

Ultimately, Elire’s solution brings costed payroll data to projects as it enhances the connectivity between HCM and ERP while extending to push data to Oracle Cloud EPM. The solution also accommodates multiple Legal Entities and accounts for Payroll Labor at the Assignment level including a project segment in the General Ledger and different expenditure types depending on time type.  Employer Liabilities are separately identified in projects by expenditure type.  

What’s Next  

As you aim to integrate Time and Labor to Payroll to Projects, take your time assessing requirements and identifying gaps. Make sure you do not lock into a design too quickly as requirements should be your priority. Resources from Time & Labor and Projects and Payroll should all be engaged equally. For the best outcome, look to engaging the Technical Team in your Functional Design of the solution.  

For more information on Time & Labor to Payroll to Projects, contact one of our Elire Experts at [email protected]. To learn more about successfully utilizing your Cloud application, subscribe to the Elire Monthly Cloud Newsletter.  

Looking to optimize your Cloud application? We’ve got you covered there too. Take a look at Elire’s Path to Cloud Webpage for next steps in your Cloud Optimization journey. In the meantime, follow Elire on LinkedIn and Twitter to stay up to date on all things Cloud HCM.   

Author

  • Jordan Hutchcraft

    Ms. Hutchcraft serves as Elire’s Marketing Associate, working to develop and optimize marketing brand assets. Jordan collaborates with the Elire Marketing Team to produce blog and social media content, strategize for social media expansion, and maintain Elire’s internal and external branding.

Recent Posts

Kyriba Live 2024: Treasury Revisited

Kyriba Live 2024 featured cutting-edge finance and treasury insights, unveiling new products, offering expert-led sessions, and providing networking opportunities for industry professionals.

Read More »

Related Posts

Sign up for newsletters

Want to Learn more?

Explore our upcoming Events & Webinars

Register now