Emerald Blog

Stories, Tips And Tricks From Our Team’s Experiences With Primavera Since 1995

01 November 2018

Oracle Prime – Cost Sheet & Viewing Budget Changes

Written by Mary Lynn Backstrom, PMP, PMI-SP, PMI-BA – Implementation Specialist

Oracle Prime uses the Cost Breakdown Structure (CBS) to track, manage and report costs in the Cost Sheet page. Costs in the Cost Sheet can be viewed in the base currency or the project currency.

Before we visit the Cost Sheet in Oracle Prime, let’s have a high level look at the CBS and Cost Categories.

The Cost Breakdown Structure (CBS)

A Cost Breakdown Structure (CBS) is a set of cost codes used to track, manage, and report costs related to a project. The CBS standardizes costs into categories that represent manageable cost sources (customized to your organization requirement) and a standard cost classification system. The CBS cost codes are classified into three types: expense, capital, or none. CBS codes are used in top-down and bottom-up cost planning and tracking.

Segment Definitions:

Use a segment definition to define the hierarchical depth of the CBS and how codes will be concatenated.

Segments Definitions can be edited in the Cost Sheet as well the CBS screen if need be.

You can create a custom CBS at the workspace and project level. When you create a CBS at the project level you can select the budget sources for your project, which can be edited from the Cost Sheet page up until the project is baselined. Our file (above) is already baselined, so we don't need to do this.

Cost Categories

A cost category is used to define costs into a category more specific than a CBS code.
Cost Categories are customizable - above is a very simple set for our small example.

Overview of the Cost Sheet

The Cost Worksheet can be viewed by CBS Codes or Cost Categories. (CBS Codes shown above.)

You have access to a flat list display and a hierarchical display of CBS codes.

The image above is a Cost Worksheet by Cost Categories. Cost sheet columns can be customized to view only required information.

Budget Changes

A Budget Change request to increase the Direct Labor Budget by $50,000.00 has been created (above). This budget change is then submitted for approval.

Recalculation of the Cost Sheet shows our Budget Change submission in the column Pending Budget Changes as it has not yet been approved.

As projects progress, changes in scope, resource reallocation, funding additions and withdrawals, or other factors can affect original budgeted amounts. Oracle Prime tracks budget changes and budget transfers.

The Budget Changes page enables you to track modifications that affect the budget. Use this page to view all approved, pending, and rejected change requests including who approved or rejected the change request, what the change entails, and any additional comments about why the change request was necessary. Pending change request amounts are also visible on the project Cost Sheet page if pending budget fields are displayed.

A second Budget Change has been created/submitted and approved (BC10 above).

The Cost Sheet (recalculated above) shows the approved budget change and the budget change that has not yet been approved. The approved budget change also appears in the Budget Window, both as part of the current cost for direct labor and in the details for that budget line item.

Note: Please keep in mind that you must have the required security access to create/make changes to the Cost Sheet and Budget sheets.

14 August 2018

Are You Tracking Ideas? Are Approved Ideas Easily Translated into Project Proposals?

Written by Mary Lynn Backstrom, PMP, PMI-SP, PMI-BA – Implementation Specialist

Ideas in Oracle Prime:

Use Oracle Prime to create ideas: capture, evaluate, and process the ideas for new initiatives and business endeavors.

Ideas are processed using a submission and approval workflow. Prime Projects provides a default workflow for processing ideas, or you can create a customized workflow. First the idea creator creates an idea and specifies the idea's business case. When an idea contains sufficient information, the creator can submit the idea for further processing by routers and owners.

 

02 August 2018

Oracle Prime Lean Scheduling

Written by Mary Lynn Backstrom, PMP, PMI-SP, PMI-BA – Implementation Specialist

What is the Tasks App in Oracle Prime about?

 

With the Lean Scheduling functionality in Oracle Prime you have access to the Planning Board (below). This enables the user to create customized views for their information in the Work Plan screen in the Tasks App.

27 July 2018

DOT's and Emerald Associates - We Can Make Your Job Easier

Written by Sue Hopkins - Implementation Specialist

Emerald Associates is well known in the US and Canada for our homegrown add-on tools for Primavera P6. We have assisted numerous companies in many diverse areas to get the most out of their P6 software. You may wonder how our tools can assist in the Departments of Transportation (DOT) field to get more done in P6, with less time, while still providing useful data to your stakeholders, and remaining good stewards of the public's funds. Our tools will help you do more work in less time, so that your project management group has more time to analyze and perfect their schedules.

09 May 2018

P6-QA and the Project Scheduler

Written by Sue Hopkins - Implementation Specialist

Manually wading through a schedule and looking for errors is time consuming and prone to human error. Not only that, it's boring. No one wants to do it, but you need to check your schedule for errors!

Even worse then working through your own schedule for errors, is slogging through a contractor's. When you don't know how they have built the schedule, it can take days to make sure things hold together. Some of our clients have several layouts, reports and even special access databases and outside tools to do this which is very time consuming, error prone and boring.

02 May 2018

Finding Setting Up or Changing Resource Availability in P6 a Struggle?

Written by Mary Lynn Backstrom, PMP, PMI-SP, PMI-BA – Implementation Specialist

We have all experienced at one point or another how tedious (and time consuming) setting or changing resource availability can be in the P6 resource dictionary. Particularly for an example like the one we will walk through where you are setting up or adjusting turnaround resources and the weekend rule happens to be ½ crews.

 

The P6-Loader can ease the pain of these types of tasks.

24 April 2018

Global Calendars – Exactly Which Projects Are Using Each Calendar?

Written by Mary Lynn Backstrom, PMP, PMI-SP, PMI-BA – Implementation Specialist

In P6, identifying each specific project using each of the Global Calendars in a concise, fast, easy to use manner is challenging. Some may think this is not necessary very often, but in my experience, it has been quite the opposite!

Is this functionality already handled in Primavera P6, Client or Web? A very good question - let’s have a look.

01 March 2018

Do You Need EV Calculated at the Resource Level?

Written by Mary Lynn Backstrom, PMP, PMI-SP, PMI-BA – Implementation Specialist

You are correct; out-of-the-box P6 does not calculate Earned Value (EV) at the resource assignment level. It only runs EV at the activity level which is fine for a start, but what to do when you need to ‘dig deeper’ and analyze crew performance? You can't use Global Change to calculate the resource assignment EV because the activity percent complete isn't available in the Global Change list of fields.

A very simple option is to use TAPS to input your schedule updates. TAPS is barcode updating (with additional functionality). By using TAPS, updates are faster and more accurate giving you (and your team) more time for schedule analysis. Yes, TAPS runs EV calculations at the resource level.

14 February 2018

P6-Loader v5 Usage Sheets Revolutionize P6 Database Maintenance

Written by Nicole Jardin, P.Eng. - CEO

When you have a large number of users in your P6 database, it is surprising how quickly that database can get “clogged up” with a lot of unwanted data. This happens even when using Sandbox databases, restricting privileges and every other trick you have thought of; long time P6 users know what I am talking about.

10 January 2018

P6-Loader - Easy Moving of Pre-Turnaround Work to the Turnaround Window

Written by Sue Hopkins - Implementation Specialist

On every Turnaround there are Pre-Turnaround activities that do not get done prior to the actual Turnaround and need to be moved into the Turnaround phase of the schedule.

The challenge is how to record actual hours earned in the PRE phase vs the TA phase, since a large number of these activities already have earned hours associated with them. Simply moving the activities would decrease the reporting of hours in PRE and create earned hours in TA for work that was actually done in PRE.

This can be done simply and quickly with P6-Loader.

28 December 2017

My PCM Forms/Reports are not Updating, What is Going on with BI Publisher?

Written by Dan MacMillan - Integration Specialist

In deploying our Emerald Primavera Contract Management (PCM) Productivity Cloud, we got the vanilla PCM installed and added our PCM add-on utilities for line numbering controls. Then we added some of our P6 and PCM automations to move change documents between the two systems.

To be on the safe side, we took backups and renamed databases, but we couldn't have predicted what would happen next...

28 September 2017

A Guide to P6 Archiving - Part 2

Written by Ian Nicholson, P.Eng. - VP Solutions

Archiving P6 Project Data and the Question of Location

This is part 2 of a series of blogs discussing best practices of P6 archiving. In Part 1 we discussed the question of time:

  • How long should you keep a P6 project file?
  • How do you track the date to archive your P6 project?


Now we will discuss the question of location.

 

archive project data

12 September 2017

A Guide to P6 Archiving - Part 1

Written by Ian Nicholson, P.Eng. - VP Solutions

Archiving P6 Project Data and the Question of Time

We get asked on a regular basis what the best way to archive P6 data is.

  1. How long should a project file be kept?
  2. What should be done with the project files when that time period has expired?
  3. Where should they be kept?
  4. How can we retrieve if we need them, especially with upgrades?


In this blog series, we’ll look at some of the options available to a P6 user and discuss the question of time.

 

Archiving P6 Project Data and the Question of Time

 

30 August 2017

How to upgrade Oracle OPPM from 16.1 to 16.1.3

Written by Paul Jardin - VP of Technology

Step by Step Instructions on how to Upgrade Oracle Primavera Portfolio Management

Here are step by step instructions on how to upgrade your Oracle Primavera Portfolio Management (OPPM) environment to the new 16.1.3 version. To learn more about OPPM you can visit our product page.

25 August 2017

What Is Happening With My Magic Quadrant Investor Map?

Written by Nicole Jardin, P.Eng. - CEO

A Look Inside Oracle Primavera Portfolio Management Graphical Analysis

Last week I logged in to my Oracle Primavera Portfolio Management environment and found that my items were in the wrong quadrants. Rather than having current tasks in my upper quadrants and future tasks in my lower ones, all my tasks were being broadcast as low priority and ending up at the bottom of the quadrant.

 

OPPM Magic Quadrant1

[12 3 4 5  >>