CBA Inc

Archive for Oracle’ Category

18

Jul
2023
Comments Off on OPC Baselines and Time Travel

OPC Baselines and Time Travel

OPC Baselines and Time Travel

Before we get into OPC Baselines and Time travel, Oracle Primavera Cloud (OPC) is the newest Project Management solution offered by Oracle. While the OPC Scheduling suite and Primavera P6 are very similar in functionality, OPC has introduced several additional features that will give project managers powerful tools not previously at their disposal. We at CBA, Inc. are really excited about OPC and over the coming months we invite you to join us as we dive into many of the new features that we think make it a solution worth looking at. 

For our first blog in the series, I want to discuss one of my favorite features in OPC; OPC Baselines and Time Travel. 

That’s right, OPC allows you to travel through time. Ok, maybe not full-on time travel, but a special Baseline feature in OPC allows us to do the next best thing. Before we get into that though, a bit about Baselines in general.

The Baseline is a snapshot of the project as it existed at the time the Baseline was created.  Project managers typically create the initial Baseline just before the project starts.  This allows them to easily identify where slips have occurred.  As the project progresses, project managers will be able to view reports displaying the original plan (the Baseline) and compare it against the current project. 

The Baseline is an important tool in any project manager’s arsenal regardless of which scheduling software you are using.  The ability to see the variance between what was planned and what actually happened offers powerful reporting options to schedulers as they manage their project.  OPC continues to offer similar Baseline functionality as P6 with a few interesting additions.

Above is a picture of a Project that has been baselined and has subsequently slipped behind schedule.  The yellow bars show where each activity was supposed to start and finish vs the blue, red or green bars above them which show the current start and finish dates.

Most Project Management Software suites have similar functionality so many of you are probably familiar with this concept.  Where OPC shines (and back to the topic of this blog), is the ability to go back in time and create a Baseline from any specific day in the past. 

Essentially, OPC makes a copy of your project every night at 11:59pm.  The Baseline “From History” feature allows us to access those “copies” while adding new Baselines.  With this new feature, we can create a Baseline for our project based on any date from the current date all the way back to the beginning of the project.

Baseline from history
Above is a picture of the “From History” feature.  When adding a new Baseline, you can choose “From History” as the source.  This will allow you to select any date from the current date all the way back to the beginning of the project.

The ability to compare the current project against the project as it existed on any day from the past (on the fly!) is something we never had the power to do before and gives us a level of control over reporting that can help with change orders, claim situations and more. 

For instance, events may happen on the job site that at the time you did not realize would be of great significance.  Only later do you recognize the impact it had on the project.  With this feature, you can now go back in time and create a Baseline just before that event happened.  Want to see what the project looked like just before that big storm?  No problem!  Do we need to see what the project looked like before we shifted the focus from “here” to “there”?  No problem!  Heck, just plain forgot to make a Baseline at the beginning of the project?  No problem!  

In summary, OPC offers the same great Baseline features we had in P6 but now combined with the “From History” feature, Project Managers have more power than ever at their disposal for comparison reporting against their projects.

Come learn about this and many more great OPC features in one of our training classes.  Click here for more information on dates and locations.


Curtis Callaway

Curtis Callaway is a Sr. Consultant and Instructor with CBA and you can read more about him in his short Bio. He is the lead Instructor for our Atlanta, GA facility. You can register for one of his upcoming OPC class in Atlanta below.

OPC Scheduling – August 1-2: Atlanta, GA

OPC Scheduling – October 17-18: Atlanta, GA

read more

17

Dec
2020
Comments Off on When to Upgrade your P6 EPPM installation

When to Upgrade your P6 EPPM installation

Tune-up or Overhaul

Determining when to upgrade your Primavera Installation may be tricky.  This article will attempt to help in this decision process to ensure your team is on the leading edge, but not necessarily the bleeding edge of Primavera.  The goal of this article is not to provide a set timeline or cycle of how often an upgrade should occur as the title implies, but instead the goal is to help provide guidelines on how you can best determine that for your environment.

First, off let us define what we mean when we say “upgrade”.  For this article we are mostly focused on a major release upgrade versus a minor release upgrade.  Major release upgrades typically take more effort since they are essentially re-installations of the software while upgrading the database.  Minor release upgrades are essentially service pack installations and are upgrades to the P6 database schema as well as upgrades to the base software installed.  Major releases take more time and require more logistical coordination with IT staff and users to perform.  While minor releases could be done much more easily.

For Example:

Major release:

18.8 to 19.12

Vs image

Minor release:

19.12.9 to 19.12.11

Now that we’ve setup the ground-rules for the article let’s get into the meat of it.  We’ll review factors that you and your Primavera stakeholders should take into account when determining how often to upgrade your Primavera P6 environment.

Factors to consider:

  • Support End of Life
  • Downtime of Primavera P6
  • New Features of potential upgrade
  • Bugs
  • Oracle Security Risk update
  • External Requirements
  • Integrations
  • Current IT Infrastructure (Windows Server upgrade on all servers from 2016 to 2019)
Support End of Life

The typical term for support life with Oracle products seems to be 5 years.  Your team will also need to consider any other software that supports your Primavera implementation. (ex. Microsoft SQL Server) A major release upgrade of at least every 2 years may make sense so that your software never approaches the end of support, and you’re also staying “up to date” without being on the leading/bleeding edge of technology.  Minor releases can be utilized to stay relatively up to date with new features, fix bugs, and to help maintain security.

Downtime of Primavera P6

Downtime can be easily managed on both minor and major upgrades by have a good plan for upgrade.  Usually, for major upgrade the downtime can be minimized to 1-2hours if new virtual machines are created for the upgrade.  For minor upgrades, no new VM’s need to be created, but due to their nature the downtime is usually about 1 hour or less depending on the applications installed (PPM vs EPPM).

New Features of potential upgrade

Key Primavera P6 stakeholders should review new features of upgrades in a consistent manner in order to determine that new features can provide more functionality or better performance while using Primavera P6.  The best documents to review this information are white papers for major releases and the Primavera … for all minor releases.

Bugs

Sometimes referred to as Oracle Primavera “features”, bugs can be annoying errors that are regularly encountered by users.  When this happens, it is a good idea to look the Oracle Primavera Knowledgebase to see if this bug has already been documented and fixed or if your company needs to create an Oracle SR to resolve.  Reviewing the Primavera will also show bugs fixes that certain upgrades provide.  Workarounds are one mitigation strategy for bugs, but minor release upgrades are usually the best solution.

Oracle Security Risk Update

Oracle produces a security risk update each quarter.  Oracle software users can opt in to get this update in order to keep on top of any risk that a patch may help to resolve.  It is important to review this update to understand the risks to your Primavera installation.  Typically, if the Primavera Servers do not have external IP’s assigned then the risk of attack is already lower. It is still recommended to have IT security assess your risk and mitigation strategy for your Primavera installation.

External Requirements

Contract requirements may define a specific version of Primavera required to use when submitting schedules.  Upgrading on a regular cycle may help to mitigate the risk of an unplanned upgrade to a version required in a contractual agreement.

Integrations

If your Primavera P6 installation is integrated with other products, then there may be some dependencies on specific version when either software is upgraded.  Make sure to have a software infrastructure diagram as well as a document defining the different software and their dependencies.  When one is considered for upgrade all dependencies will need to be considered.

Current IT Infrastructure

When it is time to update the server operating system it may also be a great time to perform an application upgrade.  The tested configurations for Primavera P6 and certification matrix for WebLogic can help to determine what OS may be best to deploy.

Next steps to take to help decide your software update frequency

  • Track New Features and Oracle Risks
  • Determine upgrade cycle right for your company
  • Determine a budget for software upgrades
  • Determine the key Features of the software and whether it improves or inhibits those features in the upgrade

If you’re ready to upgrade now and would like to get the ball rolling, please fill out our P6 Upgrade Help Request and we’ll be in touch.

read more

14

Feb
2018
Comments Off on Using Fill Down in Primavera P6 – video

Using Fill Down in Primavera P6 – video

This short video shows how to save time scheduling your projects by using the “Fill Down” feature in Primavera P6. Add this shortcut to your routine to become a more effective scheduler. For more information about our instructor led, in-person training courses at CBA check out our Class Schedule.

read more

31

Jan
2018
Comments Off on The Benefits of BIM

The Benefits of BIM

CBA Subject Matter Expert on BIM, Cynthia Stiffler, President of VDC Services for Rock Ridge Virtual Design Construction, describes the different maturity levels of BIM, through the concepts of 4D, 5D and 6D scheduling, which are used to indicate the elements and benefits of increasingly complex BIM models.

There is a wide spectrum of possible uses of BIM on construction projects. At one extreme architects and engineers can use BIM simply to produce better quality design documents without providing the digital model to any other party. Contractors, likewise, can separately create models for estimating, fabricating or simulating construction without sharing the models.

Used in such limited ways, BIM does not come close to realizing its full potential. At the other end of the spectrum, BIM can provide a collaborative framework among all project parties, allowing the free-flow of data about what is being designed and how it will be constructed. Collaborative use of BIM takes full advantage of BIM’s capabilities. For more information on project management for horse arena construction, you can check out this resources at https://horsemenageconstruction.co.uk/project-management-for-horse-arena-construction/.

3D – Model

  • Model walkthroughs. These provide a great visualization tool enabling designers and contractors to work together to identify and resolve problems with the help of the model before walking on-site.
  • Clash detection. Traditionally design drawings must be coordinated to assure that different building systems do not clash and can actually be constructed in the allowed space. Accordingly, most clashes are identified when the contractor receives the design drawings and everyone is on-site and working. With clashes being detected so late, delay is caused and decisions need to be made very quickly in order to provide a solution. BIM enables potential problems to be identified early in the design phase and resolved before construction begins. Illustrating the advantages of BIM, one project for the General Services Administration in America saw BIM model reviewers find 257 constructability issues and 7,213 conflicts. On the same project, traditional plan reviewers found six constructability issues and one conflict.
  • Project visualization. Simple schedule simulation can show the owner what the building will look like as construction progresses. This provides a very useful and successful marketing tool for all those involved in a project. Contractors can also use project visualization to understand how the building will come together.
  • Virtual mock-up models. Often on large projects the owner will request physical mock-up models so they can visualize, better understand and make decisions about the aesthetics and the functionality of part of the project. BIM modelling enables virtual mock-ups to be made and tested for a fraction of the cost.
  • Prefabrication. The level of construction information in a BIM model means that prefabrication can be utilized with greater assurance that prefabricated components will fit once on-site. As a result, more construction work can be performed offsite, cost efficiently, in controlled factory conditions and then efficiently installed.

4D – Time

  • Construction planning and management. BIM models provide a means of verifying site logistics and yard operations by including tools to visually depict the space utilization of the job site throughout a project’s construction. The model can include temporary components such as cranes, heavy equipment, and fencing. Traffic access routes for heavy equipment, cranes, lifts, and other large items can also be incorporated into the model as part of the logistics plan. Tools can further be used to enhance the planning and monitoring of health and safety precautions needed on-site as the project progresses.
  • Schedule visualization. By watching the schedule visualization, project members will be able to make sound decisions based upon multiple sources of accurate real-time information. Within the BIM model a chart can be used to show the critical path and visually show the dependency of some sequences on others. As the design is changed, advanced BIM models will be able to automatically identify those changes that will affect the critical path and indicate what there corresponding impact will be on the overall delivery of the project.

5D – Cost

  • Quantity Takeoffs. To determine a project’s construction cost and requirements, contractors traditionally perform material ‘take-offs’ manually, a process fraught with the potential for error. With BIM, the model includes information that allows a contractor to accurately and rapidly generate an array of essential estimating information, such as materials quantities and costs, size and area estimates, and productivity projections. As changes are made, estimating information automatically adjusts, allowing greater contractor productivity.
  • ‘Real Time’ cost estimating. In a BIM model cost data can be added to each object enabling the model to automatically calculate a rough estimate of material costs. This provides a valuable tool for designers, enabling them to conduct value engineering. However, it should be noted that overall project pricing would still require the expertise of a cost estimator.

6D – Facilities Management

  • Lifecycle management. Where a model is created by the designer and updated throughout the construction phase, it will have the capacity to become an ‘as built’ model, which also can be turned over to the owner. The model will be able to contain all of the specifications, operation and maintenance (O&M) manuals and warranty information, useful for future maintenance. This eliminates the problems that can currently be experienced if the O&M manual has been misplaced or is kept at a remote location.
  • Data Capture. Sensors can feed back and record data relevant to the operation phase of a building, enabling BIM to be used to model and evaluate energy efficiency, monitor a building’s life cycle costs and optimize its cost efficiency. It also enables the owner to evaluate the cost-effectiveness of any proposed upgrades.

For more information about 4D Scheduling or BIM, contact CBA at 419-874-0800 or by email.

read more

14

Jul
2017
Comments Off on No More Java in Oracle Primavera P6 v 17?

No More Java in Oracle Primavera P6 v 17?

If you’re part of the Primavera Community you know what the bane of most user’s existence is. It’s, of course, Java.  Java, that once heralded Sun developed software that enabled developers to deploy code on almost any platform, has had it’s issues lately to say the least.  In Primavera software, Java is most common in the applets that run within P6 and is the cause for most of the support calls relating to stability and performance.  Users have been waiting patiently for Oracle to clear the decks of Java applets within P6.  As of version 17.7, which will be released the week of July 17, 2o17 they will have made significant inroads into delivering on that promise.

In this new release most Java applets will be replaced with HTML5 views and those few that remain can be disabled.  The new HTML5 views in 17.7 are:

• Capacity Planning
• Global Search and Replace
• Activity Network
• Resource Overallocation
• User Interface Views
• Schedules Services
• Trace Logic
• My Calendar
• Status Updates
• My Preferences
• Calendar View
• My Issues Portlet

The Java Applets that remain and can be “switched off” include:

• Risk Management (Project Tab and Dashboard Portlet)
• Portfolios
• Resource Planning (Resources Tab)
• Workspaces (Projects Tab)

There are many other refinements and new features in Primavera P6 included in the release that we’ll discuss at a later date.  But for most users the ability to cut down on your Java intake is a great reason to look at upgrading to the new release.  We’d be glad to help you evaluate your current P6 environment with our P6 Health Check and recommend how you can chart your best path forward.

read more

21

Feb
2014
Comments Off on An Ounce of Prevention is Worth More Than a Box of Donuts

An Ounce of Prevention is Worth More Than a Box of Donuts

Ounce of Prevention is Worth More than a Box of Donuts


In a perfect world, when awarded a project, you’d be allotted a full week of gloating, “Hoo-hahs!” and chest bumps followed by a full 30 days to submit a preliminary 90 day baseline schedule and another 60 days to submit the complete construction schedule for the full project. Of course, you’d not only have the non-partisan support and participation of the Owner for feedback along the way, you’d also have all your subs identified and ready to go. They’d all come filing into the first weekly project meeting with a fully detailed Primavera project schedule, smiles and a box of donuts to share!

Unfortunately, that’s not the world we live in. In most instances, notification of the award signifies “Go time!” Immediately all parties involved begin the frenzy to get the ball rolling. It seems that everyone from the owner, to the Project Manager, to the subs (if even known) is frantically moving at warp speed to get the project off the ground. While the effort is admirable, it is not always effective. Everyone is working in their own silo and there is often not enough team collaboration from the beginning, especially as it relates to the project schedule.

Even if you have the luxury of 60 days to submit the final construction schedule for baseline approval, the real work on the schedule often begins far too late into that time frame. Everyone is not working together to plan the work accurately, to reflect the real world, intended progression of the project. The Owner will nit-pick about adherence to the schedule specs, the subs will complain that they don’t need a schedule because they have been doing this for years, and the Project Manager will want to strangle them all because he just wants to make things happen, get home in time for dinner at least once this month, and not get sued down the road!

It’s exactly at this time, at the inception of a project, that Critical Business Analysis, Inc. should be brought on board.

CBA is often utilized as a third party schedule consultant to not only develop the project schedule, but to act as an objective team participant to facilitate the collaboration process among all parties involved. We know scheduling and project management. We understand scheduling specs and best practices. We have no private agenda and our advice can be trusted.

Far too often, we are brought into a project only after major issues with the project schedule have been identified. Certainly we can help in these situations, but issues like these, and the meetings surrounding them, are adversarial, ugly and definitely confection deprived.

Whether you are the Owner or the General Contractor, save yourself the agony. Contact us at the beginning of your project to be a “second set of eyes” for the development of your project schedule and then use us as a reliable resource throughout the life of the project to be sure your scheduling effort is still on track. We all know that the project schedule can be your best friend, or your worst enemy. Bring us aboard and let us make the introduction to your new BFF…we’ll even bring the donuts!

read more

15

Jan
2014

Better Safe than Sorry!

Information Security - Better Safe than Sorry

I want to share some very useful tips with you on information safety.

Unfortunately, I recently learned the hard way when my credit card number was stolen as I checked into a Las Vegas Hotel for a seminar. Luckily though, my bank was very diligent and the breach was under $100 and very short lived!

  • 1)  ALWAYS use strong passwords (combinations of capital letter, number and punctuation work best and are harder to crack). An easy way to remember is also using something similar to the following short phrase: I8cookies
  • 2)  Don’t use the same passwords for all accounts and change passwords regularly. This is easier said than done and is more secure. There are password vault applications available (many free) on the web and on smartphones that can help you compile and manage your different passwords securely. Granted, you sometimes get as much functionality as you pay for. There are some really good paid options too. A personal favorite of a colleague of mine is called RoboForm.
  • 3)  Back up your data into multiple and diverse solutions such as an external portable hard drive in conjunction with a secured cloud based backup solution. Don’t rely on a single storage medium for your most important data (family photos, etc.)
  • 4)  Basic information like your address and birthday are easily obtainable online. For Password Reset questions always use secret questions that are fairly obscure and only you or close family would know.
  • 5)  Another good practice is to make sure public profiles on Google, Facebook, etc. are controlled and you only share information that you are comfortable with the whole world seeing. Don’t make it easy for someone to guess your password. Also, don’t set your social, email or other accounts to “auto login”. If someone nabs your computer or device, you have given them instant access.
  • 6)  Full disk encryption (e.g., BitLocker for Windows, FileVault for Mac OS X, dm-crypt + LUKS for Linux) for your personal machines is critical to secure your data in the event you misplace or lose it. That way, despite the loss of the hardware, it becomes more difficult for someone else to access your data.
  • 7)  Be wary of using your credit card or other sensitive information online with websites that are not well known. Always ensure that HTTPS/SSL encryption is used when performing any transaction that requires you to enter sensitive information including your username and password. Look for https on the URL and the padlock icon in the URL. To even be safer, one can click the padlock and ensure the site has a valid certificate (such as Verisign).
  • 8)  Enable every alert possible for transaction confirmations, password changes and other notifications. It is one of the best ways to keep on top of any unauthorized change in any online account. Pay attention to the options each site provides and enable as many as possible.
  • 9)  Be aware of email phishing scams where a hacker attempts to gather information about you such as your username, passwords, or credit card details by masquerading as a trustworthy entity like Google Cloud platform security that can protect you. Avoid clicking on any suspicious links or providing any data about yourself. Always contact the entity directly using their published contact details to validate if it’s a legitimate request.

read more

Page 1 of 812345...Last »