If you missed it in the endless stream of Oracle acquisitions, in September 2012 Oracle acquired the assets of Skire. Skire made it’s mark by providing a complete set of management and government tools across all project phases from planning and building to operations, enabling companies to effectively manage their capital and construction programs. By combining Skire with industry leading capabilities from Oracle Primavera products, Oracle intends to create a full life-cycle Enterprise Project Portfolio Management (EPPM) platform that provides a comprehensive offering from capital planning and construction to operations and maintenance for owners and operators, contractors and sub-contractors. The ability to execute on that premise is being watched very closely by us at CBA and by extension our Primavera Contract Management customers. While this is an exciting development bringing a true SaaS model, cloud-based solution to the Primavera family, it also puts into question the future of traditional Primavera products especially that of Oracle Primavera Contract Management.
Oracle Primavera has already crowned Skire as the eventual replacement for Contract Management due primarily to the fact that Skire already contains 70% of the enhancement requests received for Contract Management. Right now Skire is in a sort of hibernation and is in controlled release until the first Oracle re-developed versions and new modules are released in January through March 2013 according to Oracle Primavera. For a sneak peak and an understanding of the Oracle roadmap for Skire, Oracle Primavera is hosting a webinar tomorrow December 5th, at 12:00 noon EST. Here is a link to register for the webinar https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=541959&sessionid=1&key=1648A6E955E7AA28696AB99D2A8A881D&partnerref=bulletin&sourcepage=register. In the weeks and months to come we will continue to provide information and insight into this development. Our CBA Sales and Technicalstaff will be glad to answer any questions you may have to help you understand the strategy and direction of both Skire and Contract Management.read more
A friend reached out to me this week with a new wrinkle in report R_SB_09 where the date format in the received column was wrong. Instead of 10/28/2012 appearing it was showing up as 28/10/2012. My first inkling was to look at the presentation or layout side of the report and look at date format. Much to my surprise, there wasn’t any formatting. Hmm, must be an issue with the data model? Sure enough, when I edited the data model and looked at data, received was 28/10/2012 and sent right next to it was 10/28/2012. Suspicion confirmed! The data model contained the following: CONVERT(nvarchar(30),SBMT.LATEST_RECVD_DATE,103) as LATEST_RECVD_DATE, CONVERT(nvarchar(30),SBMT.LATEST_SENT_DATE,101) as LATEST_SENT_DATE, First thing I noticed was converting the date being part of the syntax rather than just pulling the date and the one I liked (Sent) had a 101 and the other (Received) had a 103 in the variables. Simple solution! Change the 103 to 101. I did and it worked but why? Turns out 103 is British formatting and 101 is English, but there are many more choices available. Google “Oracle SQL Convert 101” to learn more.read more
Labor Day – The height of construction season for some, a winding-down point for others. Is your portfolio of projects producing the bottom line you need? Are things going as bid? Projects on-time, close to budget?
The answers lie in the proper application of a combination of standardized, best-practice project management processes and related technology implemented on an enterprise basis, such as the Primavera family of project management solutions, allowing timely project performance visibility and true collaboration on a company-wide basis. In today’s competitive economic environment, these aspects are no longer an option – they have become a necessity for long term growth and prosperity.
The benefits of adoption are borne out when reviewing Aberdeen Group’s 2010 Project Management Report – “Standardized Best Practices and Technology Adoption in the AEC Industry” – January, 2010, and extrapolating the findings to your organizational situation and practices.
We have included pertinent references to the Best Practices and Technology Improve Performance section of the report – summarized and/or paraphrased – here for your convenience. The full report may be accessed at http://www.oracle.com/us/2010-project-management-report-069877.pdf
In researching their findings for Architecture, Engineering and Construction firms, Aberdeen created three categories of AEC firms based on the extent of adoption of standardized best project management practices and enterprise level technology.
The first category of top performing companies utilize defined, documented and standardized best-practice project management processes and have implemented enterprise technology – implemented on an enterprise basis – that enables the insight and controls to deliver projects early or on time and within budget. For those projects with time or cost overruns, the combined processes minimize the negative impacts significantly. The average firm in this bracket achieved:
- 89% of projects delivered early or on time
- Projects not delivered on time are on average four weeks late
- 89% of projects delivered within budget
- 10% average overrun on those projects not delivered within budget
The second category of AEC firms utilize defined and standardized practice project management processes, however, the technology is limited to desktop tools, spreadsheets or manual processes. The average firm in this bracket achieved:
- 71% of projects delivered early or on time
- Projects not delivered on time are on average six weeks late
- 79% of projects delivered within budget
- 14% average overrun on projects not delivered within budget
The third category consists of firms that may utilize best practices on a project-by-project basis, but not on a company-wide basis. Technology resides solely on the desktop/laptop, severely limiting project visibility and collaboration. The average firm in this bracket achieved:
- 64% of projects delivered early or on time
- Projects not delivered on time are on average six weeks late
- 73% of projects delivered within budget
- 20% average overrun on projects not delivered within budget
As the data above indicates, there are significant differences when standardized best project management processes and enterprise applications are not utilized in a true enterprise fashion to provide not only true project portfolio visibility and team collaboration, but also add substantially to corporate financial performance. As budgets remain tight and project execution becomes critical, can you afford not to adopt such a holistic approach?
Are you planning for next season yet?
As the 2012 season wraps up, it is prime time to consider the funding of adjustments or refinements to your Project Management and technology approach, whether it is utilization of year-end monies or adequate budgeting for next fiscal year.read more
In the many Project Control Roles that I have performed over the years, one of the tasks that is always of substantial importance to the P6 Customer is managing the consistency of project data within an Enterprise Database. As most of you may have experienced, when a P6 environment lacks the guidance for maintaining project integrity across all projects in the EPS, the pristine data that was present when you first set up your environment becomes a faint image of times past. One of the easiest ways to manage these issues is found in P6 R8 and is called “Schedule Checker.” Now, many of the tasks that were too time consuming to manage or just not available in a refined singular tool format, are at your fingertips. Rather than setting up Schedule Logs, QC Filters, QC Layouts and Reports, you now have a simple 14 point checkup to provide a concise report where the QC results are determined by the configurable thresholds defined by you. Items such as long lag and large durations are especially helpful if you are running Risk Analysis against your project.
The first thing to do is set up the 14 Configurable User Thresholds. The Schedule Checker can be run against one or multiple projects. You can save the thresholds to run again for the project that is open.
Shown below is the top half of the Schedule Check Summary Report.
Reference below the lower half of the Schedule Check report. A detailed summary for all activities that fall outside of the thresholds can be displayed in each section. Note the expanded Soft Constraint and Invalid Progress Dates sections.
Of course, analyzing the results is just the beginning for schedule maintenance, but the quick access to the QC data is great!!
Next up – Using P68.2 Web to import Resources from Excel
Oracle P6 v8.2 EPPM Deployment Hurdles
Part 1 – TNSNAMES.ORA
Before software can be used for its intended purpose, some poor soul has to install and configure it…
You’ve just entered the Geek Zone.
Any typical scheduler might ask “What the heck kind of a word is tnsnames and what does it have to do with project management scheduling?” Somebody obviously needs to ‘buy’ a vowel or two.
Second part first – If you have ever installed Primavera, you have probably experienced the woes of seeing the “Connection Unsuccessful” screen when configuring a database alias. The ability for you to do your job relies on a database that must be up, running and fully functional at all times. If you use Primavera 8.2 for your scheduling, there is a high likelihood that your software attaches to an Oracle database. A typical/average P6 user creates and updates data that is locked in a server somewhere out in cyberspace, about which you know very little. Safe to say, whether you know it or not, ALL P6 users want to know about crucial items that affect their database.
Now the first part of the question; TNS is an acronym invented by Oracle. The prefix TNS refers to something called a ‘Transparent Nework Substrate’ (TNS). The suffix, ‘names’ is important for 2 reasons: One – it describes the subject and two – very important – it implies plurality. Oracle designed this file to contain connection string information to enable connection to many databases.
What is TNSNAMES?
TNSNAMES.ora is a special code file which is a part of a root communication method that Oracle uses to identify database files from any other directory full of files on a network. The file works like a ‘Table of Contents’ for data driven applications. It contains the network names (and/or IP Addresses) of any data source computer which might house data files which can be accessed by your Oracle based software. You can open the tnsnames.ora file with a text editor (like notepad). Upon doing so, you can see sentences written in what appears to be fairly simple code structure.
How do I get a TNSNAMES.ora File?
TNSNAMES.ora is born when the newly installed Oracle database product gets installed for the very first time. The bouncing baby file goes to a “house” called ORACLE_HOME, with a couple of simultaneously born sibling files – (it takes a village…). These files are shepherded by the good DBA (Database Administrator), who makes sure that they are kept as pure as the wind-driven snow at all times. As long as the files keep the good karma they were born with, life for database centric computer applications is very, very good.
What could happen?
Here is where the fun begins. (‘Fun’ that is, for those of us who like to have lemon juice squeezed into our paper cuts). Most of the ‘homes’ of these vulnerable, tender little offshoots are weakly guarded and have no alarm systems. With as little as one stroke of any common keyboard, a perfect little file can instantly join the legion of ne’r-do-wells in the intergalactic bit-bucket of cyberspace. Once befouled, the wayward TNSNAMES file becomes suddenly empowered to bring every database application end user storming (Yea, verily! Even ALL AT ONCE!) into the office of the nearest computer geek for help. The miserable cacophony will sound something like: “I don’t know what happened! Everything worked yesterday… I didn’t do anything!”
Lesson from the Tip of the Spear
As an Oracle software user, you may at some point be told by a well meaning helpdesk representative, directed by an error message, or otherwise tempted just to go look and experiment with TNSNAMES.ora. Sadly, as in the story of Faust, the story really can have a tragic ending. Like signing his contract with the devil, making “enhancements” to the TNSNAMES.ora, is both entirely too easy and terribly risky.
The moral of the story: If you are not absolutely sure of your actions, resist the temptation to edit these critical database files. Instead, seek the help of a qualified IT resource to administer your Oracle data system needs. Additionally, though this may seem obvious, make sure that your IT team is knowledgeable, qualified to work with Oracle products and immune to temptation, as well.
You’ll be thankful that you wisely considered the possibility of losing all of your schedule data and that of the rest of your team.read more
P6 is an enterprise application whether you are purchasing one license or ten. There are many factors to be considered when installing the product.
Do I want a stand-alone install? Do I want to take advantage of the web features? Do I have an Oracle database or SQL? Is my system 32 bit or 64 bit? Which operating system am I using? Am I installing a “Typical” or “Standalone” version and is it P6 v7 or P6 v8.2? Which Java JDK is installed and to what Home location should the oracle software be pointed to after the install is done? Which features of P6 should be configured? BI, Collaboration, Workflow, Web Services? Whew, and these are just a few of the things we need to understand.
I often am told “we can do the install ourselves”. Sometimes this is true, however, more often than not, because this is an enterprise application, it is not just a disc to fire up and click a few “next” buttons. I frequently get calls about error messages. I am in sales and I’m pretty good at it, but technical enterprise application install questions fall outside my area of competency. My suggestions would undoubtedly compound the problem. What I can do is get the right people involved.
Proper installations as well as training on the product are critical to your success. CBA, Inc. has been in the business of providing project management solutions, Primavera products, training, implementation and staff augmentation services since 1984.
Whether you are in the energy, oil and gas, construction, manufacturing, or any other industry that requires close management of budget, resources and timelines to be successful, CBA, Inc. can and does help. Large or small companies across the country have benefited from our expertise, and as a result, we are sought after time and time again by our customers because of our successes.
To find out what we can do you help you save time and maximize your investment, please contact your CBA, Inc. Michigan Account Executive – Donna McLean at (248) 522-7931 or by email at firstname.lastname@example.org.
Mention this Install article from this blog and receive 5% discount on new license orders placed through May, 2012.read more
Since the acquisition of Primavera by Oracle in 2008 we have seen first hand the the influence this powerful corporation has had on the once tight-knit Primavera user community. In case you are not well acquainted with CBA we are a founding PAR (Primavera Authorized Reseller) that pioneered Primavera products introducing them to much of the large install base in the mid-west from their infancy in 1984 through the Oracle acquisition and beyond, continuing today to provide Oracle Primavera products and associated professional services and training as an Oracle Specialized Gold Partner. Since 2008 we have helped our customers handle all the complexities in dealing with a far larger and geographically dispersed organization that is Oracle today. We find it curious that organizations with which we have long-standing relationships always call Oracle first for Primavera questions. I’m not talking about support calls here, that is another subject for another day, but routine questions regarding licensing, new product information, training, etc. I thought it would be illuminating to discuss how those calls are handled by Oracle and how one call to CBA can provide much more information in far less time.
As I said earlier we are an Oracle Specialized Gold Partner, so we obviously are proud of our relationship with Oracle, but as an independent organization and admittedly small business we operate differently. When someone has a Primavera question and calls Oracle they are typically transferred by the call center to the voicemail box of Katie, Lead Distribution Specialist in Houston Texas, Katie then transfers your voicemail to Jeff a Business Development Specialist in Missouri, who may call you to determine what your needs are and specifically if you need any additional licensing. Now here’s where it gets complicated Oracle has a direct sales staff that handles organizations with over a billion dollars in sales per year and a channel sales staff that is tasked with adding and supporting channel partners like CBA. Many of the new partners are just that, very new to Primavera. They may have a history selling other Oracle technologies, or no business history at all, just a desire to set up shop and try their luck at selling project management solutions. One organization in this category that we know of has gone so far as to buy a canned video testimonial off the internet (yes believe it or not there are sites that do that) with two people right out of central casting with no names and never even mentioning the company, it’s products or services and audaciously place it on the home page of their website (and on YouTube as well). Ah, the internet what an amazing place! I bring this up only because the next part of your calls journey once Jeff has determined the potential net worth to Oracle, will either get distributed through Lorraine in Philadelphia, or Angie in Chicago, to CBA or another partner as a lead, or get handled by an Oracle Sales Assistant and eventually to an Oracle Account Executive handling one of the billion dollar plus organizations. We have received these email leads days after the person orginally placed their call and in some cases has called several times, or has talked to another partner without the expertise to provide the necessary help. The funny thing is Oracle is only concerned with your software needs, since they discontinued Primavera training from Oracle University last May, so if you have a training or implementation question I’m really not sure where those calls go. I do know your support questions are usually handled by Raluca out of Romania.
Here is what happens if you call CBA directly (at either 419-874-0800 or toll-free at 800-874-8080). Most likely if you call us during business hours Linda our office manager will personally take your call. Linda has been with CBA for over 10 years and has done everything from setting up training classes to ordering manuals to sending out OLSA’s (Oracle License and Support Agreements). She knows and can navigate Oracle better than anyone I know, even those within Oracle itself. In many cases your quest for information stops right here with Linda, since she can answer many of your questions on the spot. If you need further assistance Linda will route your call to either a CBA Account Manager, or one of our certified consultants or trainers. The great thing about calling CBA first is that our concern isn’t just to sell you software, but as a full-service Oracle Primavera partner we can deliver exceptional training and implementation services that Oracle itself and many other partners can’t provide. Our goal is to provide an exceptional customer experience from the second you contact us and at every touch point within our organization, whether it is for professional services, training , software, support, or those general questions that seem to take a tour through the Oracle world. So save yourself a lot of time and effort and get all your Primavera questions answered with one call to CBA.
While many new partners are challenged to even have one person with Primavera knowledge on staff CBA has a deep bench of over 20 Primavera experts working in the field today from Cenovus in the oil sands of Canada to FirstEnergy and DTE in our own backyard and everywhere in between. CBA consultants, trainers and those on staff augmentation assigments are managing projects from inception through execution in the most demanding environments. To demonstrate our deep domain knowledge and expertise CBA is having a live Webinar in June with 10 of our top consultants and trainers leveraging their real-world experience to answer your Primavera questions. Look for a formal announcement and sign-up instructions coming soon. Remember with CBA one call does it all (419-874-0800 or toll-free at 800-874-8080).read more