Project Partners Blog


By Randy Egger
President, Project Partners LLC
Former chief architect of Oracle E-Business Suite Projects applications

Over 20 years ago, Finance and IT organizations (under the direction of the Chief Financial Officer), were in control of systems and desperately wanted to instill some financial controls and measures into the Delivery organizations that ran projects. The battle was always that the Project Managers (PMs) didn’t want to be controlled by departments they felt had no understanding of the world of project management, they wanted complete flexibility to best deliver their projects, and they were not concerned with the CFO’s desire for visibility into projects. Most PMs managed projects using personal systems based on Microsoft® Excel or Microsoft Access. The more sophisticated project managers used Microsoft Project, and the most advanced firms used Primavera, Cascade, Mantix, Artemis, and Cobra. BUT, the project systems used by PMs seldom could reflect accurate cost data which then made it difficult to really know the financial health of the project. Therefore, many PMs simply managed to effort and schedule.

In the “old days” a job code equating to a project was part of the general ledger chart of accounts – and most PMs were not strongly concerned about financials. So, how could you let accountants manage financials and project managers manage projects? You needed a system that allows both worlds to obtain the information that they wanted in the format that they wanted. To meet this need, in the early 1990’s Oracle released its first Project Accounting (PA) system: a true project based sub-ledger.

When the initial implementations of PA started, it was the Finance group that was imposing controls onto the Project Managers. Finance wanted visibility into ongoing projects, hence Finance was making most of the decisions, which generated friction between the organizations. To meet the requirements driven by Finance, PMs needed to change the way they were managing projects and that introduced a large opportunity for Change Management.

Getting structure into a non-structured environment was the primary challenge. When companies have been doing things a certain way for decades, it is VERY hard to change that culture… so compromises are made in an attempt to balance the needs of both organizations. Some folks would create a Work Breakdown Structure (WBS) to map to a Cost Structure simply so that they could track and control costs. Other companies placed intelligence into both the Project number as well as the WBS … because that was the way it was always done in the past. Some would claim that it made controlling charges easier while others would claim that it made reporting easier. But, in both cases, Project/Task naming was mirroring the way a General Ledger chart of accounts is structured, and not the way a project manager manages a project.

As time progressed, operations and project-based delivery organizations matured and developed a better understanding of what is needed to facilitate harmony between Finance and Project based Operations. At the same time, Oracle developed a Project Management system that was closely linked to its Project Accounting application. When Oracle released its Oracle Project Management (PJT) application and companies began to implement it, it became clear that Oracle had taken one step closer to really bridging the Accounting world to the Project Management world. But that still was not enough. PMs wanted and needed an EASY tool to assist them with their Project Management needs. Then, Oracle made the smart decision to purchase Primavera.

For those companies that implemented Oracle Project Costing and Project Billing only, without a futuristic vision of having a truly integrated Project Management system in place, trying to implement any form of integration of Project Accounting to a Project Management system became a horrible mess. When that happens, the only real thing that can be done is to update the implementation of Project Costing and Project Billing with a clear understanding of how it would integrate with either Oracle Project Management or Primavera. If there are other major issues that also need to be addressed, then a complete reimplementation of these modules should be considered.

Any company that is upgrading to E-Business Suite Release 12, or implementing R12 for the first time, will have the opportunity to rethink or redefine how they will move to become a truly project centric organization. Whether you are implementing for the first time, updating your implementation or re-implementing, thinking through the business needs that address both Project Accounting and Project Management will be paramount for your future long term success.

This issue applies to more firms than one might initially expect. I have always stated that “every company is a project company … they just don’t know it yet.” As more and more organizations decide to operate their firm or certain divisions on a project basis to better understand costs and level of effort and to develop repeatable processes using a structured Project Management methodology they will look to Oracle’s Enterprise Project Portfolio Management solutions, which remain the most complete in the market. And they will benefit from the significant evolution of these applications that enable Finance and Project Management to work together in harmony.

Try Us and Find Out How You Can Have It All Right Now!

By Pat Bowyer

On March 28, 2012, we presented an OAUG Sponsored webcast to discuss and demonstrate the timecard entry solutions we’ve developed, our mProjects Time Management™ mobile timecard and our TimeSpeed™ spreadsheet user-interface applications, both fully integrated with Oracle Time and Labor and Oracle Projects, and extending the functionality of those applications, that will help take the headache out of project timecard entry.

Sound interesting? You can register to view the recorded webinar here.
Read the rest of this entry »

By Rajesh Silswal

In both Release 12 and 11.5.10, out-of-the box integration between Oracle E-Business Suite Projects and Oracle Enterprise Asset Management (EAM) allows the collection of maintenance costs into Oracle Projects from EAM. You can carry out maintenance activities, consume different resources and the resulting costs of those activities can be transferred into Oracle Projects. These can be brought in as an accounted cost or an unaccounted cost and will facilitate the analysis of Project Based P&L’s. Oracle treats internal maintenance costs as Work in Process (WIP) and is used in conjunction with an Oracle WIP Job. Utilizing Oracle Project Manufacturing enables the integration of Oracle Projects and EAM. Without configuring PJM along with Oracle Projects and Oracle EAM, you cannot leverage this standard out-of-the-box integration.

Additionally, if you utilize Oracle Purchasing, standard configurations and integration further supports EAM, by allowing EAM based Purchase Orders to create corresponding commitments in the Oracle Projects module. That’s the good news!

Now for the “gotcha’s”… There are some challenges to be aware of. Project financial tasks cannot be mapped to the multiple operations required to complete the Oracle Work Order. In fact a financial task can only be linked to the Work Order header and not at the line level. This prohibits the smooth flow of flexible task structure functionality provided in Oracle Projects to EAM. There is a “wWorkaround” – If there are multiple financial tasks on a project that needs cost collection from EAM, you need to create multiple Work Orders to ensure the integration flow. While this works, it is not the most elegant process to follow and presents operational challenges.

We have seen creative solutions to this challenge. Listed below are two of these.

  • Customer X mapped an Oracle Project to a single EAM Work Order. This requirement created a design limitation where we had to define a single EAM task and dedicate it to the Work Order. In this  case, the project had the visibility of the rolled up cost from EAM mapped to a single task with various  expenditure types / resources. The problem was resolved by creating the Project, Task and Work Order automatically and linking them to ensure an improved end user experience.
  • Customer Y had multiple financial tasks and required costs to be collected from EAM Work Orders. Each Project with multiple Work Orders mapped to one financial task only and one Work Order was created. Again this was operationally less challenging and more user friendly, with the integration  between Oracle Project tasks and an Oracle Work Order.

As you can see, the solutions are not perfect. The integration and functional gaps between Oracle Projects and Enterprise Asset Management can be better handled if we think through the details of the financial task structure of that project and design it accordingly. Additionally, if the relation between an Oracle Project and Oracle EAM Work Order is properly thought through and configured, then more robust integration may be achieved with minor customization and stricter process discipline.

By Jose F. Bastidas

Continuing our discussion from last week, I’d like to share with you the importance of three more new features and functions in Release 12 Oracle E-Business Suite Financial Applications. Read the rest of this entry »

By Jose F. Bastidas

Oracle customers around the globe eagerly awaited the release of Oracle E-Business Suite Release
12 for several years. Oracle R12 was touted as being a truly globalized release.  Since Oracle R12 became publically available on January 31,2007 many customers have migrated to a full Oracle R12 environment by upgrading, implementing (or re-implementing). As an Oracle Financial Consultant for more than 10 years, my opinion is that Oracle R12 finally addresses some fundamental financial weaknesses from prior versions.  Across our customer base and the projects I’ve worked on, the most well received features and functions in Oracle EBS R12 Financials are related to new centralized functions to manage Ledgers and Legal Entities, Sub ledger Accounting, Taxes, Intercompany, and AR/AP Netting functionality. Read the rest of this entry »

The Southwest Regional Oracle Applications User Group will be hosting a conference on Friday, February 24 in Los Angeles, CA.  If you’d like to attend, visit their website here and click on “Conferences.”

At the SROAUG conference, Project Partners’ Neeraj Garg will be presenting Contract Based Project Billing with Fusion Project Portfolio Management

Neeraj will be presenting this content in his presentation:
Oracle Fusion Project Portfolio Management offers Project Contracts features that are part of the Fusion Enterprise Contracts model. Fusion Project Contracts offers sell side contracts functionality that helps to drive revenue and billing independent of project setup and execution. This presentation highlights the core features including a flexible approach to billing by contract lines, contract level summaries, consolidated bill plans, billing controls, improved user interface and improved process efficiencies.

If you can’t attend the conference in person, that’s not a problem!  You can view this presentation online here.

Oracle published an interesting article that lists the top three trends for the Engineering and Construction industry in 2012. We want to make you aware of this article.

“Technology professionals serving the engineering and construction industry should be aware of three major emerging trends in 2012,” said author Scott Bartlett.

The #1 Trend: Construction projects will continue to increase in complexity

The #2 Trend: Economic pressures will continue to force companies to work globally, with increased competition for the same projects

And the #3 Trend: Owners are demanding a more efficient way of turning over all documents at the end of a project

At Project Partners we see this same focus among our multi-national Engineering and Construction customers and are glad that Oracle’s products support these key trends.

You can read the full article here: http://www.oracle.com/us/corporate/profit/opinion/012312-sbartlett-1496768.html

 

By Steve Derivan

Businesses of various shapes and sizes across the globe continue to invest in and expand the footprint of their ERP applications. Much of this increased spend includes mission critical projects such as

1) Upgrades

2) Deploying new applications and

3) Migrating new businesses, acquired companies, countries and/or re-engineered processes into an existing “corporate” ERP.

So how do these companies begin the process? What are the key considerations in play to complete these daunting tasks within an Oracle ERP environment?

Oracle E-Business Suite Applications Releases 11i and R12, and Oracle Fusion Applications – the significant majority of existing Oracle ERP customers use these 3 applications suites.
Read the rest of this entry »

by Robert D. Anderson, CPA

On January 18th, I presented a webinar featuring a case study of a firm that is successfully using Oracle E-Business Suite Projects, Oracle Order Management and Oracle Receivables, and I showed how they manage their revenue.  This customer leverages R12.1.3 revenue management functionality for GAAP revenue recognition and uses EBS Projects with a different revenue recognition basis.  In this webinar I also showed how creative approaches to integrating Orders and Projects are possible with minimal development, that robust solutions support long term business needs while also providing flexibility for growth, and that simple approaches lead to the best long term solutions.

Sound interesting?  You can view the webinar here

Have two minutes?  View our new video showing how easy it is for you to manage your timecards and charge time to a project, while leveraging Oracle Time and Labor Functionality - from your smart phone.  Check it out here